2006/3/25, Michael Schultheiss <[EMAIL PROTECTED]>: > Arno Lepisk wrote: > > Upgrade from gallery 2.0.x fails on step 3 with the following output: > > (this might be a problem already reported to upstream: > > http://gallery.menalto.com/node/46044 ) > > I'll contact upstream and make sure they're aware of this issue.
I managed to temporarily fix the problem by editing /usr/share/gallery2/modules/core/classes/GalleryStorage/schema.tpl: alfa:/usr/share/gallery2/modules/core/classes/GalleryStorage# diff -u schema.tpl~ schema.tpl --- schema.tpl~ 2006-03-20 17:38:59.000000000 +0100 +++ schema.tpl 2006-03-26 21:53:22.000000000 +0200 @@ -809,9 +809,13 @@ # A_GalleryAccessMap_1.0 DROP INDEX DB_TABLE_PREFIXAccessMap_33666; -ALTER TABLE DB_TABLE_PREFIXAccessMap ADD COLUMN DB_COLUMN_PREFIXuserOrGroupId INTEGER DEFAULT '0'; +ALTER TABLE DB_TABLE_PREFIXAccessMap ADD COLUMN DB_COLUMN_PREFIXuserOrGroupId INTEGER; -ALTER TABLE DB_TABLE_PREFIXAccessMap ALTER DB_COLUMN_PREFIXuserOrGroupId SET NOT NULL; +UPDATE DB_TABLE_PREFIXAccessMap SET DB_COLUMN_PREFIXuserOrGroupId = 0; + +ALTER TABLE DB_TABLE_PREFIXAccessMap ALTER COLUMN DB_COLUMN_PREFIXuserOrGroupId SET DEFAULT '0'; + +ALTER TABLE DB_TABLE_PREFIXAccessMap ALTER COLUMN DB_COLUMN_PREFIXuserOrGroupId SET NOT NULL; UPDATE DB_TABLE_PREFIXSchema SET DB_COLUMN_PREFIXmajor=1, DB_COLUMN_PREFIXminor=1 /A
