[Koha] Trouble with MySQL, DBI/DBD::mysql

[Chris Hammond-Thrasher]

Vincent, Chris, and list,

I updated DBD::mysql (there was a new version released yesterday) and I can
now view the main opac page and the main intranet page. However, all queries
fail due to a timezone related error with Date::Manip::Date_TimeZone . If I
cannot get to the bottom of it, I will post here.

Thank you, guys.

-cht

 
Chris Hammond-Thrasher  MLIS
Library Systems Manager
University of the South Pacific
Suva, Fiji
+679 3232233
hammondthrasher_c at usp.ac.fj

-----Original Message-----
From: Vincent Danjean [mailto:vdanjean.ml at free.fr] 
Sent: Wednesday, 7 February 2007 7:26 PM
To: hammondthrasher_c at usp.ac.fj
Cc: Koha at lists.katipo.co.nz
Subject: Re: [Koha] Trouble with MySQL, DBI/DBD::mysql

Chris Cormack a écrit :
> Vincent Danjean wrote:
> 
>>
>> IMHO, you probably has to upgrade php[45]-mysql. When using apt-cache to
>> look at php4-mysql, I can see that sarge version is still linked with
>> libmysqlclient12 whereas etch/sid is linked with new
>> libmysqlclient15off :
>>
> Vincent is on the right track it is the passwords. But upgrading PHP
> wont help, as Koha is written in perl.

Oups, I would say it's too early ;-)

> Either that, or try upgrading the DBD::MySQL perl module, perhaps try
> that first.

Yes, there is the same situation as php for DBD::MySQL perl module:
vdanjean at cayuga:~$ LC_ALL=C apt-cache policy libdbd-mysql-perl
libdbd-mysql-perl:
  Installed: 3.0008-1
  Candidate: 3.0008-1
  Version table:
 *** 3.0008-1 0
        990 http://ftp.fr.debian.org unstable/main Packages
        500 http://ftp.fr.debian.org testing/main Packages
        100 /var/lib/dpkg/status
     2.9006-1 0
        500 http://ftp.fr.debian.org stable/main Packages
vdanjean at cayuga:~$ apt-cache show libdbd-mysql-perl
Package: libdbd-mysql-perl
[...]
Version: 3.0008-1
Depends: libc6 (>= 2.3.6-6), libmysqlclient15off (>= 5.0.24-2), perl (>=
5.8.8
[...]

Package: libdbd-mysql-perl
[...]
Version: 2.9006-1
Depends: libc6 (>= 2.3.2.ds1-4), libmysqlclient12, zlib1g (>= 1:1.2.1), perl

  Best regards,
    Vincent