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

[jmoseley at corp.xanadoo.com]

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