error during upgrade..

[mareczek1982]

Hi
I'm trying to upgrade sugar from 4.5.1h to 5.0 but during pre- phase I've got this error in log:


Sat, 15 Dec 2007 20:26:47 +0100 [UpgradeWizard] - ***ERROR: test query is NOT running against a temp table!!!! -> UPDATE `CASES` SET NAME='UNSPECIFIED' WHERE NAME IS NULL
Sat, 15 Dec 2007 20:26:47 +0100 [UpgradeWizard] - *** ERROR: schema change script has errors - stopping execution


what does it mean ??

marekk

[momeara]

Hi
I'm trying to upgrade sugar from 4.5.1h to 5.0 but during pre- phase I've got this error in log:


Sat, 15 Dec 2007 20:26:47 +0100 [UpgradeWizard] - ***ERROR: test query is NOT running against a temp table!!!! -> UPDATE `CASES` SET NAME='UNSPECIFIED' WHERE NAME IS NULL
Sat, 15 Dec 2007 20:26:47 +0100 [UpgradeWizard] - *** ERROR: schema change script has errors - stopping execution


what does it mean ??

marekk

I'm seeing an identical issue.

[momeara]

I'm seeing an identical issue.

I fixed this, in 451_to_500_mysql.sql, I changed this:

update `cases` set name='Unspecified' where name is null;

to this:

UPDATE `cases` set `name`='Unspecified' where `name` is null;

[mareczek1982]

I will try tu update my environment next weekend and I will post a update info..
thanks for reply

marekk