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