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

Scott T. Hildreth shildret at scotth.emsphone.com
Wed Jul 16 17:17:45 EDT 2008


On Wed, 2008-07-16 at 11:53 -0500, Scott T. Hildreth wrote:
> 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 looked at the sql,

  ALTER TABLE CustomFields MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT NULL;

  ...I guess it doesn't like "NOT NULL" defaulting to ...well NULL. :-)

  There were 5 of these, so I removed the "DEFAULT NULL" and all was well. 

>grep "NOT NULL DEFAULT NULL" sql.queries
 
ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARBINARY(255) NOT NULL DEFAULT NULL;
ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARBINARY(64) NOT NULL DEFAULT NULL;
ALTER TABLE Transactions MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NOT NULL DEFAULT NULL;

 



> 
> 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
> _______________________________________________
> 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