Not able to upgrade to 1.5 from 1.4.26 and 27

[lars_4]

Hi!

I am having serious issues of when upgrading to the latest 1.5 version.
It seems that the SQL query's are only partially being applied in the database.
I have tryed to run some SQL upgrade query's directly into the DB, some of them work and some not.
Most of the query's that fail manually are marked as "already done / applied" on the upgrade.php page.
The MySQL user has full privileges to that database.
I have now tryed to upgrade 5 times, and rolled back 5 times since i get Fatal errors on all the tries.

This is the first fatal error: accesslevel column is missing in the usergroups table (somewhat like that)

I have fixed that through manually pushing this update into the DB, then another issue pops up.
Also the third SQL statement in the update.sql seems to error manually, the INDEX (EXTENSTION) does not excist.

Server Info:
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny9 with Suhosin-Patch
MySQL client version: 5.0.51a
PHP extension: mysql

The files on disk are removed by the script, but 99% of the SQL query's for the update are marked as Already done / applied by the update.php script.

Does anyone has any suggestions?

I have used PHP / MySQL for years, i have never come across this issue before...

[Αndré]

I am having serious issues of when upgrading to the latest 1.5 version.

Moving from cpg1.5 install to cpg1.5 upgrading

This is the first fatal error: accesslevel column is missing in the usergroups table (somewhat like that)
[..]
Also the third SQL statement in the update.sql seems to error manually, the INDEX (EXTENSTION) does not excist.

I assume those are the queries that doesn't work:

Code Select Expand

ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';
ALTER TABLE CPG_usergroups ALTER access_level SET DEFAULT '3';
[..]
ALTER TABLE CPG_filetypes DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` );

The MySQL user has full privileges to that database.

I suggest to review that.