hi: maybe your version of DBD::mysql is too old? you can try rt3.8.1rc2, the "make testdeps" will check DBD::mysql version. i got errors before upgrade my DBD::mysql, but i forgot the error message.
2008/8/7 Jean-Michel Barbet <[EMAIL PROTECTED]>: > d tbsky wrote: >> >> hi: >> your upgrade procedure is like what i did, which is wrong. >> if you use mysql, you should run the mysql upgrade script first, >> then run the rt upgrade script. or you will get empty "RT at glance" page. > > Thanks very much, > > So, trying to follow directions posted in thread : > "RT at a Glance HASH ref error during upgrade from 3.4 to 3.8", > I am reloading my RT 3.2.1/mysql 4.0.20 database in the new > RT 3.8.0/mysql 5.0.45. to do again the upgrade procedure. > > If I understood well, steps are : > > a) save DB on old server : > > mysqldump -u rt_user -p xxx --single-transaction --databases rt3 > dump > > b) reload DB on new server : > > mysql -u root -p < dump > > c) launch mysql upgrade script : etc/upgrade/schema.mysql-4.0-4.1.pl > > d) update the schema (I suppose the best is with the following) : > > /opt/rt3/sbin/rt-setup-database --dba root > --prompt-for-dba-password --action upgrade > > Unfortunately the mysql upgrade script fails : > > [root]# perl rt-3.8.0/etc/upgrade/schema.mysql-4.0-4.1.pl rt3 rt_user xxxxx > DBD::mysql::db column_info failed: column_info doesn't support column > selection at rt-3.8.0/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 rt-3.8.0/etc/upgrade/schema.mysql-4.0-4.1.pl line 227. > > Also, I am not sure if I have to run this mysql update script ... > > I do not know what is the default Mysql character set in 4.0 and > I do not know how to set it in the new Mysql 5.0... The systems both > have locale set to en_US.UTF-8... > > Thanks for advices. > > JM > > > -- > ------------------------------------------------------------------------ > Jean-michel BARBET | Tel: +33 (0)2 51 85 84 86 > Laboratoire SUBATECH Nantes France | Fax: +33 (0)2 51 85 84 79 > CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: [EMAIL PROTECTED] > ------------------------------------------------------------------------ > _______________________________________________ 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
