[Bug 33936] New: timezone
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 Bug ID: 33936 Summary: timezone Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: About Assignee: koha-bugs@lists.koha-community.org Reporter: Igor.A.Sychev@mail.ru QA Contact: testopia@bugs.koha-community.org If in koha-conf.xml set <timezone>Antarctica/South_Pole</timezone> and restart koha-common, then the error "Internal Server Error" comes out /cgi-bin/koha/about.pl -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Igor, are you sure about the text? I found Antarctica/McMurdo listed on Wikipedia for South Pole. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #2 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- Hi, Katrin! This line <timezone>Antarctica/South_Pole</timezone> is taken from the wiki https://wiki.koha-community.org/wiki/Time_Zone_Configuration Initially I set 'Asia/Tomsk', but I got an error. /var/log/koha/lib/indexer-output.log: DBD::mysql::db do failed: Unknown or incorrect time zone: 'Asia/Tomsk' at /usr/share/koha/lib/Koha/Database.pm line 117. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #3 from David Cook <dcook@prosentient.com.au> --- That's a MySQL database error, so the problem is on the database side. Take a look at something like this: https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #4 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- /var/log/koha/lib/indexer-output.log: Invalid timezone in koha-conf.xml (Tomsk) at /usr/share/koha/lib/Koha/Config.pm line 205. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Have you tried setting it to the other value I suggested? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #6 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- DBD::mysql::db do failed: Unknown or incorrect time zone: 'Antarctica/McMurdo' at /usr/share/koha/lib/Koha/Database.pm line 117. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- In the link David provided there is a paragraph about setting up the database for timezones. Maybe that's the cause? I think maybe this topic would also be better on the mailing list (more readers) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com --- Comment #8 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- I've tried <timezone>Asia/Tomsk</timezone> And about.pl shows: Time zone: Used: Asia/Tomsk | Config: Asia/Tomsk | Environment (TZ): Undefined Using 10.5.20-MariaDB-1. What does return the following command? SELECT * FROM mysql.time_zone_name WHERE name="Asia/Tomsk"; Is this table empty? Did you read David's link? https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html Looks like the relevant command is `mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql` -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #9 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- SELECT * FROM mysql.time_zone_name WHERE name="Asia/Tomsk"; +------------+--------------+ | Name | Time_zone_id | +------------+--------------+ | Asia/Tomsk | 323 | +------------+--------------+ -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 --- Comment #10 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- After restarting memcached, the working. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33936 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org