Well I ran all the etc/upgrade/3.7.* upgrades and then created the query script with schema.mysql-4.0-4.1.pl and I get this error,
ERROR 1067 (42000) at line 36: Invalid default value for 'LookupType' I am using Server version: 5.0.51a. I am confused as well, if you are already on mysql > 4.0 do you need to run the queries created by schema.mysql-4.0-4.1.pl? I think the answer is probably yes, since the char set is changed to utf8. On Wed, 2008-07-16 at 11:03 -0500, [EMAIL PROTECTED] wrote: > 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" > <[EMAIL PROTECTED] > i.tracy.ca.us> To > "Ruslan Zakirov" > 07/16/2008 10:41 <[EMAIL PROTECTED]>, > AM <[EMAIL PROTECTED]> > cc > <[email protected]> > 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 > > -----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 _______________________________________________ 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
