Summary: | timezone | ||
---|---|---|---|
Product: | Koha | Reporter: | Igor A. Sychev <Igor.A.Sychev> |
Component: | About | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | dcook, jonathan.druart |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Igor A. Sychev
2023-06-07 10:03:40 UTC
Hi Igor, are you sure about the text? I found Antarctica/McMurdo listed on Wikipedia for South Pole. 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. 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 /var/log/koha/lib/indexer-output.log: Invalid timezone in koha-conf.xml (Tomsk) at /usr/share/koha/lib/Koha/Config.pm line 205. Have you tried setting it to the other value I suggested? DBD::mysql::db do failed: Unknown or incorrect time zone: 'Antarctica/McMurdo' at /usr/share/koha/lib/Koha/Database.pm line 117. 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) 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` SELECT * FROM mysql.time_zone_name WHERE name="Asia/Tomsk"; +------------+--------------+ | Name | Time_zone_id | +------------+--------------+ | Asia/Tomsk | 323 | +------------+--------------+ After restarting memcached, the working. |