[rt-users] upgrade mysql schema problem in rt4

[Ruslan Zakirov]

On Wed, Nov 9, 2011 at 6:45 PM, Francesc Guasch <frankie at telecos.upc.edu> wrote:
> 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)


Try the following patch I want to push into the repo. Thanks for
investigating and returning back to the list.

http://users.bestpractical.com/~ruz/p/2011-11-10AqjN_uH7


>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Barcelona, Spain  November 28 & 29, 2011
>



-- 
Best regards, Ruslan.