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
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.