Mason, Rick, and Joe (and anyone else who was looking into this), It turns out that the solution is much easier than we had been discussing. Date::Manip is working just as expected and documented by checking for the system's timezone in various places including environment variables, the shell command `data`, and in /etc/timezone . The problem is that Date::Manip does not know what to make of having "Pacific/Rarotonga" in /etc/timezone or "CKT" in the output of `date`. Both of these are set by tzconfig. To solve the problem, I reran tzconfig and set the timezone to Hawaii (the same zone as the Cook Islands) which set /etc/timezone to "US/Hawaii" and the output of `date` to "HST". When I have time, I'll file this as a bug with the author of Date::Manip. I assume he/she wants to support all of the timezones that ship with major linux distros. Thanks again for all of your help! -cht Quoting Joe Atzberger <ohiocore@gmail.com>:
Timezones must be imported into mysql as well as present on the system. See the script: mysql_tzinfo_to_sql
Rather than edit the files to modify ENV, you can put in your Apache2 configuration, for each VirtualHost (or the main config): SetEnv TZ "CST"
HTH, --joe
On Thu, Sep 4, 2008 at 1:46 PM, <hammondthrasher_c@usp.ac.fj> wrote:
Mason and Rick,
Thanks for the thoughts. I will try out your suggestions when I get access to the box again in an hour or two.
I am starting to have partial memories about encountering and resolving this problem while doing the initial 2.2.6 install two years ago, but I did not make any notes about the matter. Back then, I was humbled by SQL syntax differences between MySQL 4 and 5.
More soon...
-cht
Quoting Mason James <mason.loves.sushi@gmail.com>:
On 2008/09/4, at 7:21 PM, Rick Welykochy wrote:
Mason James wrote:
Heya Chris. try something like .. $ENV{TZ} = 'CKT'; up the top of your file perhaps
ah make that something like ..
$ENV{TZ} = 'EAST';
CKT isnt valid
------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------- This mail sent through IMP: http://horde.org/imp/