[rt-users] upgrade mysql schema problem in rt4

[Francesc Guasch]

Al 08/11/11 17:39, En/na Kevin Falcone ha escrit:
> On Tue, Nov 08, 2011 at 05:34:35PM +0100, Francesc Guasch wrote:
>> Al 08/11/11 17:26, En/na Kevin Falcone ha escrit:
>>> On Tue, Nov 08, 2011 at 01:13:41PM +0100, Francesc Guasch wrote:
>>>>
>>>> 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.

> Then look at the other parts of the where clause.  Is the database
> name right?  Are the column names right?
>

Ok, I found what happened. Our database has lower_case_table_names=1,
so the script didn't find the tables. I made this patch to
etc/upgrade/upgrade-mysql-schema.pl:

446,447c446
<             ." AND ( TABLE_NAME   = ". $dbh->quote($table)
<             ."       OR TABLE_NAME = ".lc($dbh->quote($table)).")"
---
 >             ." AND TABLE_NAME   = ". $dbh->quote($table)