2.2 upgrade from 2.0 - An error occurred while upgrading Gallery Core Module

GScharoff

Joined: 2006-04-30
Posts: 2
Posted: Sun, 2007-07-15 13:05

I have attemped to upgrade from 2.0.2 to 2.2.2 but have run into a problem...I have attached the error logs...the earliest one with the "missing" files has been corrected...I did a complete overwrite install...but now I am unable to upgrde the core..I do not have a backup...and I realize now that some of this may be 3rd party modules that are not compatible...but I am stuck at this point...please help

AttachmentSize
error_logs.zip56.23 KB
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 14:50

the first upgrade attempt seems to have failed because of:
> mysql error: [1283: Column 'g_theme' cannot be part of FULLTEXT index]

from your system information:
> Database: mysql 4.1.18-nt

a similar upgrade problem from a few months ago:
http://gallery.menalto.com/node/64239#comment-233985

any idea why it reports that FULLTEXT index error? did you do anything special with your gallery database?

the second attempt seems to have failed as a consequence of the first attempt.
that is, the first upgrade attempt already completed the change for the AccessMap table migration and all other upgrade attempts error out because they try to do that change again.

> I do not have a backup

that is very unfortunate. it means that a) it may be very difficult to restore your g2 and b) it's more work for me to provide you with help.

the good news though is that you're using a non-transactional database. so all the changes are not lost. we can probably continue the upgrade quite easily after fixing 1, 2 minor things in your gallery.

- change your g2data/versions.dat (it's a normal text file with a .dat file-extension). change the first line to: 1.0.26.
- use phpmyadmin to change a value in your database: UPDATE g2_PluginParameterMap SET g_parameterValue = '1.0.26' WHERE g_pluginId = 'core' AND g_parameterName = '_version';

maybe you'll get the FULLTEXT index error again. we'll need to know more about your gallery database to find out why you got that error in the first place.
maybe that was a bug in mysql 4.1.x, you knows.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
GScharoff

Joined: 2006-04-30
Posts: 2
Posted: Sun, 2007-07-15 15:45

Thanks

Worked like a charm...you are a life saver!!!

Gary
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2007-07-15 16:17

Excellent.
Note: This was just that easy because you are using an older database driver. If your database connection was transactional, it would have been very, very difficult if not impossible to fix your Gallery.

-> Please backup your gallery database from time to time, and especially before upgrades.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage