[SOLVED] errors in 2.0 beta upgrader

carpe869

Joined: 2005-04-08
Posts: 2
Posted: Fri, 2005-04-08 13:11

password=ddduck
from version .8 to .90
begin install. There is nothing in there to mess up..

----

Gallery URL (optional):http://chubbytoe.com/gallery2
Gallery version:G2
Webserver (with version):Apache version 1.3.33 (Unix)
Datatabase (with version):4.0.20-standard
PHP version (eg 4.2.1):4.3.10
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:
G1 version (for migration bugs):
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-04-08 13:16

the relevant error

 Error (ERROR_STORAGE_FAILURE)

    * 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) 

[...]

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


(mysql): 
	    DROP TABLE g2_ItemPropertiesMap
	       

1051: Unknown table 'g2_ItemPropertiesMap'

                  adodb_mysql._execute(
	    DROP TABLE g2_ItemPropertiesMap
	    , false) % line  833, file: adodb.inc.php
               adodb_mysql.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
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-04-08 13:20

as a fix, i'd suggest creating the table g2_ItemPropertiesMap manually with phpmyadmin, then try to run the upgrader again. the table can be empty, it doesn't matter what's in it.

but i don't know why that happened.

carpe869, what version / release name was your old gallery2 version? alpha 3? upgrading is only supported for alpha 4 and newer and my guess is that 0.8 is older than alpha 4.
 
carpe869

Joined: 2005-04-08
Posts: 2
Posted: Fri, 2005-04-08 13:29

I am using gallery 2 beta 1. This is the most recent, correct? I removed the files in the g2data directory (the one outside the web folders) and ran the installer again and it worked. Let me know if this is the latest release and if the upgrade should work with this version. THanks
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-04-08 13:35

i'm not talking about your new version, i'm talking about your old version, the 0.8 aka alpha 3 or whatever.

however. now you have beta 1 and everything should be fine. i mark this issue as solved.