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

[jmoseley at corp.xanadoo.com]

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