[SOLVED] 0.9.0 -->0.9.8 Stack Trace Storage Error on upgr

BozzA

Joined: 2005-03-11
Posts: 5
Posted: Thu, 2005-04-07 05:38

Heremy error on upgrade. G2 was running smooth beforehand.

Any ideas?
Daniel

Stack Trace:
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1222 (MySqlDatabaseStorage::error)
* in modules/core/classes/GalleryStorage.class at line 261 (MySqlDatabaseStorage::addMapEntry)
* in modules/core/classes/interfaces/GalleryMimeTypeMap.inc at line 96 (GalleryStorage::addMapEntry)
* in modules/core/classes/helpers/GalleryMimeTypeHelper_simple.class at line 213 (CoreModule::addMapEntry)
* in modules/core/CoreModuleExtras.inc at line 350 (CoreModule::initializeMimeTypes)
* in modules/core/module.inc at line 515 (CoreModule::upgrade)
* in modules/core/classes/GalleryModule.class at line 137 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 72 (CoreModule::installOrUpgrade)
* in upgrade/index.php at line 152 (UpgradeCoreModuleStep::processRequest)

Debug Output:

(mysql): SHOW TABLES

file_exists(/usr/local/apache2/htdocs/picsoc05/PicSocData//versions.dat)
file(/usr/local/apache2/htdocs/picsoc05/PicSocData//versions.dat, )
file_exists(/usr/local/apache2/htdocs/picsoc05/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
opendir(/usr/local/apache2/htdocs/picsoc05/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
readdir(Resource id #48)
closedir(Resource id #48)

(mysql): SHOW TABLES

(mysql): SELECT ps_name, ps_major, ps_minor FROM piccy_Schema

(mysql): DELETE FROM piccy_PluginParameterMap WHERE
ps_pluginType='modules' AND ps_pluginId='core' AND ps_itemId=0 AND
ps_parameterName='misc.useShortUrls'

mysql error: [1062: Duplicate entry 'z' for key 1] in EXECUTE("INSERT INTO
piccy_MimeTypeMap (ps_extension, ps_mimeType, ps_viewable) VALUES
('z','application/x-compress',0)")

(mysql): INSERT INTO piccy_MimeTypeMap (ps_extension, ps_mimeType,
ps_viewable) VALUES ('z', 'application/x-compress', 0)

1062: Duplicate entry 'z' for key 1

ADODB_mysql._Execute(INSERT INTO
piccy_MimeTypeMap (ps_extension, ps_mimeType, ps_vie...) % line 818, file: adodb.inc.php
ADODB_mysql.Execute(INSERT INTO
piccy_MimeTypeMap (ps_extension, ps_mimeType, ps_vie...,
Array[3]) % line 1219, file: DatabaseStorage.class
MySqlDatabaseStorage.addMapEntry(GalleryMimeTypeMap,
Array[3]) % line 261, file: GalleryStorage.class
GalleryStorage.addMapEntry(GalleryMimeTypeMap,
Array[3]) % line 96, file: GalleryMimeTypeMap.inc
CoreModule.addMapEntry(Array[3]) % line 213, file: GalleryMimeTypeHelper_simple.class

realpath(/usr/local/apache2/htdocs/picsoc05/modules/core/classes/../../../)

 
virshu
virshu's picture

Joined: 2003-09-13
Posts: 314
Posted: Thu, 2005-04-07 15:11

what bersion are you upgrading from? I assume that new version is 0.9.9 (please confirm)
Thank you

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-04-07 17:42

delete all rows in piccy_MimeTypeMap and retry the upgrade.

 
BozzA

Joined: 2005-03-11
Posts: 5
Posted: Mon, 2005-04-11 08:15

It's 0.9.8 I changed to, not the 0.9.9 because that wasn't out when i tried. i deleted that table. It took a few minutes to click over... but now it works.

I think you can mark this one as [solved]

Thanks a bunch.

It's still not particularly fast though.