I am getting the same column_info failed error message when running the script. I'm using mysql5.0.22 on Ubuntu. I did have to move this file to the DB server since we are not running RT and the DB on the same machine.
--Ryan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov Sent: Wednesday, July 16, 2008 6:57 AM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: [rt-users] Upgrading to 3.8.0: schema.mysql,column_info selection problem In 3.8.0 it's one step :) However, we've done changes to mysql DB that require additional upgrade steps for mysql, and this step fails. On Wed, Jul 16, 2008 at 5:24 PM, <[EMAIL PROTECTED]> wrote: > Did you follow these steps first? > > You may also need to update RT's database. To find out, type: > > ls etc/upgrade > > For each item in that directory whose name is greater than > your previously installed RT version, run: > > /opt/rt3/sbin/rt-setup-database --action schema \ > --datadir etc/upgrade/<version> > /opt/rt3/sbin/rt-setup-database --action acl \ > --datadir etc/upgrade/<version> > /opt/rt3/sbin/rt-setup-database --action insert \ > --datadir etc/upgrade/<version> > > > There are 10 3.7.xx directories that you'll need to go through. > > > James Moseley > > > > > > "web master" > <[EMAIL PROTECTED] > ra.com> To > Sent by: [email protected] > rt-users-bounces@ cc > lists.bestpractic > al.com Subject > [rt-users] Upgrading to 3.8.0: > schema.mysql, column_info > 07/16/2008 05:00 selection problem > AM > > > > > > > > > > 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. > > As in point 4) of UPGRADING.mysql > > [EMAIL PROTECTED] etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries > > but > > usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password > > Ok, then I inserted the info needed > > [EMAIL PROTECTED] 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. > > RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need > to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in > 3.6.6 tarball), it seems to suggest so. > > Can anybody please help? > Cheers > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
