Interesting. We’re running 5.0.27 and the script worked just fine.
However, I ran all the schema/acl/insert upgrade commands using all the
5.7.xx directories in etc/upgrade.
Still waiting to hear from Ruslan to confirm 100% that you don’t need to
run all these commands and you need only run the schema.mysql-4.0-4.1.pl
script.
Additionally, not entirely sure, but it sounds like he acknowledges there
is a problem with the script.
James Moseley
"Ryan Hardester"
<Ryan.Hardester@c
i.tracy.ca.us> To
"Ruslan Zakirov"
07/16/2008 10:41 <ruz@bestpractical.com>,
AM <jmoseley@corp.xanadoo.com>
cc
<rt-users@lists.bestpractical.com>
Subject
RE: [rt-users] Upgrading to 3.8.0:
schema.mysql,column_info selection
problem
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
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
ZakirovSent: Wednesday, July 16, 2008 6:57 AM
To: jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com
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.
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"
<webmaster@acelle
ra.com>
To
Sent by: rt-users@lists.bestpractical.com
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
[X@Y]#perl 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
[X@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.
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
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
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: sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
direct select on mysql command