<div dir="ltr">Timezones must be imported into mysql as well as present on the system. See the script:<br><div style="margin-left: 40px;">mysql_tzinfo_to_sql<br></div><br>Rather than edit the files to modify ENV, you can put in your Apache2 configuration, for each VirtualHost (or the main config):<br>
<div style="margin-left: 40px;">SetEnv TZ "CST"<br></div><br>HTH,<br>--joe<br><br><br><div class="gmail_quote">On Thu, Sep 4, 2008 at 1:46 PM, <span dir="ltr"><<a href="mailto:hammondthrasher_c@usp.ac.fj">hammondthrasher_c@usp.ac.fj</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Mason and Rick,<br>
<br>
Thanks for the thoughts. I will try out your suggestions when I get access to<br>
the box again in an hour or two.<br>
<br>
I am starting to have partial memories about encountering and resolving this<br>
problem while doing the initial 2.2.6 install two years ago, but I did not make<br>
any notes about the matter. Back then, I was humbled by SQL syntax differences<br>
between MySQL 4 and 5.<br>
<br>
More soon...<br>
<br>
-cht<br>
<div class="Ih2E3d"><br>
Quoting Mason James <<a href="mailto:mason.loves.sushi@gmail.com">mason.loves.sushi@gmail.com</a>>:<br>
<br>
><br>
> On 2008/09/4, at 7:21 PM, Rick Welykochy wrote:<br>
><br>
> > Mason James wrote:<br>
> ><br>
> >> Heya Chris.<br>
> >> try something like ..<br>
> >> $ENV{TZ} = 'CKT';<br>
> >> up the top of your file perhaps<br>
> ><br>
><br>
><br>
> ah make that something like ..<br>
><br>
> $ENV{TZ} = 'EAST';<br>
><br>
> CKT isnt valid<br>
><br>
> <a href="http://search.cpan.org/%7Esbeck/Date-Manip-5.54/lib/Date/Manip.pod#___top" target="_blank">http://search.cpan.org/~sbeck/Date-Manip-5.54/lib/Date/Manip.pod#___top</a><br>
><br>
<br>
<br>
<br>
<br>
</div><div class="Ih2E3d">-------------------------------------------------<br>
This mail sent through IMP: <a href="http://horde.org/imp/" target="_blank">http://horde.org/imp/</a><br>
_______________________________________________<br>
</div><div><div></div><div class="Wj3C7c">Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></div></blockquote></div><br></div>