[rt-users] upgrade mysql schema problem in rt4

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20111108/a3dca3c3/attachment.sig>