[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem
Scott T. Hildreth
shildret at scotth.emsphone.com
Wed Jul 16 12:53:16 EDT 2008
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, jmoseley at corp.xanadoo.com 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"
> <Ryan.Hardester at c
> i.tracy.ca.us> To
> "Ruslan Zakirov"
> 07/16/2008 10:41 <ruz at bestpractical.com>,
> AM <jmoseley at corp.xanadoo.com>
> cc
> <rt-users at 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
>
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Ruslan
> Zakirov
> Sent: Wednesday, July 16, 2008 6:57 AM
> To: jmoseley at corp.xanadoo.com
> Cc: rt-users at 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.
>
> On Wed, Jul 16, 2008 at 5:24 PM, <jmoseley at corp.xanadoo.com> 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"
> > <webmaster at acelle
> > ra.com>
> To
> > Sent by: rt-users at 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 at 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 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.
> >
> > 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: sales at bestpractical.com
> >
> >
> > 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: sales at 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 at bestpractical.com
>
>
> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
More information about the rt-users
mailing list