Problems upgrading Gallery 2 Core

silent

Joined: 2003-03-24
Posts: 1
Posted: Sun, 2005-03-13 23:49

Hi Guys,

All of a sudden my Gallery2 install decided that it wanted to upgrade itself - from Cire 0.8 to 0.9.0. I dumped the MySQL database as instructed and continued on my merry way.

The following error occurs:

Error (ERROR_STORAGE_FAILURE, ERROR_UNKNOWN)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1162 (gallerystatus::error) 
in modules/core/classes/GalleryStorage.class at line 241 (mysqldatabasestorage::execute) 
in modules/core/CoreModuleExtras.inc at line 330 (gallerystorage::execute) 
in modules/core/module.inc at line 512 (coremoduleextras::upgrade) 
in modules/core/classes/GalleryModule.class at line 137 (coremodule::upgrade) 
in upgrade/steps/UpgradeCoreModuleStep.class at line 68 (coremodule::installorupgrade) 
in upgrade/index.php at line 155 (upgradecoremodulestep::loadtemplatedata)

Various debug output ensues...

mysqlt error: [1051: Unknown table 'g2_ItemPropertiesMap'] in EXECUTE("
	    DROP TABLE g2_ItemPropertiesMap
	    ")

--------------------------------------------------------------------------------
(mysqlt): 
	    DROP TABLE g2_ItemPropertiesMap
	       
--------------------------------------------------------------------------------
1051: Unknown table 'g2_ItemPropertiesMap'
                  adodb_mysqlt._execute(
	    DROP TABLE g2_ItemPropertiesMap
	    , false) % line  833, file: adodb.inc.php
               adodb_mysqlt.execute(
	    DROP TABLE g2_ItemPropertiesMap
	    , Array[0]) % line 1156, file: DatabaseStorage.class
            mysqldatabasestorage.execute(
	    DROP TABLE [GalleryItemPropertiesMap]
	    , Array[0]) % line  241, file: GalleryStorage.class
         gallerystorage.execute(
	    DROP TABLE [GalleryItemPropertiesMap]
	    ) % line  330, file: CoreModuleExtras.inc
      coremoduleextras.upgrade(Object:coremodule, null) % line  512, file: module.inc

realpath(/var/www/html/silent-system.net/gallery/modules/core/classes/../../../)

----

Gallery URL (optional): http://www.silent-system.net/gallery2
Gallery version: 2 Beta1
Webserver (with version): Apache2 2.0.52-3.1
Datatabase (with version): MySQL 4.1.10
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s): Various
Operating system: Fedora Core 3
Web browser/version:
G1 version (for migration bugs):
 
kegobeer
kegobeer's picture

Joined: 2003-01-09
Posts: 8
Posted: Mon, 2005-03-14 01:27

Did you back up your database or do a drop? I don't remember the upgrade script asking to remove all the tables before proceeding. If you dropped your tables, that's probably causing your upgrade woes.
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Mon, 2005-03-14 04:56

that drop sql is part of the upgrade code, but perhaps should not be executing in this case.. i think bharat will be debugging this case. silent, which exact G2 version and core version were you upgrading from? (core 0.8 exactly, or 0.8.something ?)
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Mon, 2005-03-14 07:24

Silent, I just tried to ssh to your system with the u/p that you provided but I was unable to get in (and I have a theory why). If/when you're around can you catch me on irc so that we can try again? I'd like to investigate this and resolve this problem! Thanks.