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/../../../)
Posts: 314
what bersion are you upgrading from? I assume that new version is 0.9.9 (please confirm)
Thank you
Posts: 8601
delete all rows in piccy_MimeTypeMap and retry the upgrade.
Posts: 5
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.