[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Kris Boutilier]

Your local version of DBD::mysql is out of date. The relevant notes from my rt3.8 upgrade on Debian Etch are below. Hope that helps.

Kris Boutilier
Information Services Coordinator
Sunshine Coast Regional District

-------------------------

'column_info failed: column_info doesn't support column selection' means DBD::mysql is probably out of date, so check installed version of DBD::mysql

# perl -MCPAN -e 'print CPAN::Shell->r '

Package namespace         installed    latest  in CPAN file
...
DBD::mysql                   3.0008     4.007  CAPTTOFU/DBD-mysql-4.007.tar.gz
...

What does Debian provide as a package and are we up to date?

rt38:/# apt-cache search DBD::mysql
libdbd-mysql-perl - A Perl5 database interface to the MySQL database

rt38:/# apt-get install libdbd-mysql-perl
Reading package lists... Done
Building dependency tree... Done
libdbd-mysql-perl is already the newest version.

Hmmm.... http://packages.debian.org tells us that 4.007-1 is available in Testing. Can we easily install the package from Testing on this Stable machine?

[don't bother trying this route, it fails miserably...] rt38:/usr/src# wget http://http.us.debian.org/debian/pool/main/libd/libdbd-mysql-perl/libdbd-mysql-perl_4.007-1_amd64.deb

[clip]

... So, no. How about installing from sources, via CPAN?

rt38:/usr/src# wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.007.tar.gz

{clip}

12:12:57 (444.49 KB/s) - `DBD-mysql-4.007.tar.gz' saved [123516/123516]

rt38:/usr/src# tar -xvzf DBD-mysql-4.007.tar.gz

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL

Hmmmm... it needs access to the mysql_client binary to build, so:

rt38:/# apt-get install libmysqlclient15-dev

rt38:/usr/src/DBD-mysql-4.007# perl Makefile.PL
rt38:/usr/src/DBD-mysql-4.007# make
rt38:/usr/src/DBD-mysql-4.007# make install

And, try again:

rt38:/usr/src/rt-3.8.0rc3# perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root '' > sql.queries
rt3.Groups.Instance has type VARCHAR however mapping is missing.

Odd message, but everything seems to work now.


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of web master
Sent: Wednesday, July 16, 2008 3:00 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

Hi there
I am having schema.mysql-4.0-4.1.pl problems upgrading to version 3.8.0 from 3.6.6.
make upgrade worked well.

{clip}

[X at Y]#perl etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS  > sql.queries

but

DBD::mysql::db column_info failed: column_info doesn't support column selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
DBD::mysql::db column_info failed: column_info doesn't support column selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.

{clip}