On Tue, Nov 08, 2011 at 01:13:41PM +0100, Francesc Guasch wrote: > Hi. I am trying to upgrade to rt4. > > rt4 is in debian squeeze, db is a mysql 5.1.49-3 (Debian). > > I'm stuck upgrading the database. I am trying to upgrade from > an old mysql 4.0.24. > > perl etc/upgrade/upgrade-mysql-schema.pl > > Can't use an undefined value as an ARRAY reference at > etc/upgrade/upgrade-mysql-schema.pl line 442. > > I think the problem comes from this query returning empty: > > mysql> SELECT CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH FROM > information_schema.COLUMNS WHERE TABLE_SCHEMA = 'rt4' AND > TABLE_NAME = 'ACL' AND COLUMN_NAME = 'RightName'; > > yes, this is in mysql-5.1. > > I dumped the original rt3 DB, but I had no way to tell the character set > to mysqldump. I restored with --default-character-set=binary > and mysql character-set to Latin1.
You should look to see if any of your information_schema is filled -kevin
pgpgI91Jzr1Ti.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011