[Koha] Urgent 2.2.6 to 2.2.9 upgrade help

[hammondthrasher_c at usp.ac.fj]

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 at 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 at 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 at 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
> > >
> > >
>
http://search.cpan.org/~sbeck/Date-Manip-5.54/lib/Date/Manip.pod#___top<http://search.cpan.org/%7Esbeck/Date-Manip-5.54/lib/Date/Manip.pod#___top>
> > >
> >
> >
> >
> >
> > -------------------------------------------------
> > This mail sent through IMP: http://horde.org/imp/
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/