"Fatal Error" after upgrade from 1.4.24 to 1.5.10

[profili]

Hello,
I have followed the instuctions of the upgrade process in one of my galleries, but it seems that something is going wrong and this gallery wont upgrade. Instead i got a simple error message and a blank page. Have searched around and I think I have the same problem as this here http://forum.coppermine-gallery.net/index.php/topic,65521.0.html
I have turned the debug mode on following this guide here http://documentation.coppermine-gallery.net/en/errors.htm#errors_fatal

And here we are:

Code Select Expand

While executing query 'SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg148_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323

mySQL error: Unknown column 'access_level' in 'field list'

But I don't know what to do with these codes, I don't understand anything there.

Please someone help me how to fix these problems.
The site http://www.galsh.com/

Thank you...

[profili]

Please some help here! 

[Αndré]

Run update.php.

[profili]

Run update.php.

I did it more than once, http://www.galsh.com/update.php
But again, the same problem. http://www.galsh.com/

[Αndré]

Make sure you have completely replaced the update.php file and all files in the sql directory. If it still doesn't work, perform the commands of sql/update.sql manually, especially that line:

Code Select Expand

ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';

[profili]

Make sure you have completely replaced the update.php file and all files in the sql directory.

Did those since the first time but still nothing.

If it still doesn't work, perform the commands of sql/update.sql manually, especially that line:

Code Select Expand

ALTER TABLE CPG_usergroups ADD access_level tinyint(4) NOT NULL default '3';

How do i do this?

Your help is very appreciated. Thank you.

[Αndré]

Use a tool like phpMyAdmin.

[profili]

Use a tool like phpMyAdmin.

Ok, but how do I perform the commands of sql/update.sql manually?

Thank you.

[Αndré]

Replace the table prefix CPG_ with your actual table prefix and copy it to the execution box (I don't know how it's called or where it is in phpMyAdmin, as I personally don't use it).

[profili]

Replace the table prefix CPG_ with your actual table prefix and copy it to the execution box (I don't know how it's called or where it is in phpMyAdmin, as I personally don't use it).

Maybe SQL query on database? Like this in the screenshot?

[Αndré]

Try the 'SQL' tab.

[profili]

Did it.

Code Select Expand

While executing query 'SELECT COUNT(*) FROM cpg148_categorymap WHERE group_id in (3)' in bridge/udb_base.inc.php on line 340

mySQL error: Table 'gsh_galeria.cpg148_categorymap' doesn't exist


This is now the new message from the debug mode.

[Αndré]

You have to run all commands that are in sql/update.sql (= the whole file).

[profili]

Everything in sql/update.sql or just one part of it?
Yes you said (= the whole file), but I need to be sure and not ruin the database.

[lurkalot]

but I need to be sure and not ruin the database.

As always,  Please do yourself a favour and back up your database first.  Then if it goes wrong you can restore it.

[Αndré]

Yes everything.

[profili]

It wont work!

Code Select Expand

Error

SQL query:

# Create temporary table to store messages carried over from one page to the other
CREATE TABLE CPG_temp_messages(
message_id varchar( 80 ) NOT NULL default '',
user_id int( 11 ) default '0',
time int( 11 ) default NULL ,
message text NOT NULL ,
PRIMARY KEY ( message_id )
) COMMENT = 'Used to store messages from one page to the other';

MySQL said: Documentation
#1050 - Table 'CPG_temp_messages' already exists

[phill104]

At this point I think you should restore to 1.4.x from your backup then begin again. Did you disable your bridge and all plugins before you started?

[profili]

I had no bridge installed and yes I have disabled the plugins before the begin of the upgrade. To restore a copy of the 1.4 version should be impossible, because I don't have it. Yes is stupid, but I haven't downloaded a copy of the DB before the update.

[phill104]

I cannot promise I can hel here but please could you email me a copy of your database if it is not too large and I will try and do something. Again, I cannot promise anything.