Same problem on my end went from 0.9.0 to 0.9.6 Get the following errors:
btw. I this morning I also install eAccelerator so not sure if this is what broken this install(was working just fine with 0.9.0) and don't/didn't have ZEND installed. Tried to add the following to my php.ini(zend_optimizer.ze1_compatibility_mode = off) no luck.
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1222 (gallerystatus::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 (gallerymimetypemap::addmapentry)
in modules/core/CoreModuleExtras.inc at line 350 (gallerymimetypehelper_simple::initializemimetypes)
in modules/core/module.inc at line 513 (coremoduleextras::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 151 (upgradecoremodulestep::processrequest)
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
realpath(/var/www/html/gallery2/modules/core/classes/../../..)
Binding text domain: modules_core ->
/var/www/html/gallery2/modules/core/locale
file_exists(/var/www/html/gallery2/g2data//versions.dat)
file(/var/www/html/gallery2/g2data//versions.dat, )
file_exists(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
opendir(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
readdir(Resource id #36)
closedir(Resource id #36)
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): DELETE FROM g2_PluginParameterMap WHERE g_pluginType='modules'
AND g_pluginId='core' AND g_itemId=0 AND
g_parameterName='misc.useShortUrls'
--------------------------------------------------------------------------------
mysql error: [1062: Duplicate entry 'z' for key 1] in EXECUTE("INSERT INTO
g2_MimeTypeMap (g_extension, g_mimeType, g_viewable) VALUES
('z','application/x-compress',0)")
--------------------------------------------------------------------------------
(mysql): INSERT INTO g2_MimeTypeMap (g_extension, g_mimeType,
g_viewable) VALUES ('z', 'application/x-compress', 0)
--------------------------------------------------------------------------------
1062: Duplicate entry 'z' for key 1
adodb_mysql._execute(INSERT INTO
g2_MimeTypeMap (g_extension, g_mimeType, g_viewable)...) % line 818, file: adodb.inc.php
adodb_mysql.execute(INSERT INTO g2_MimeTypeMap
(g_extension, g_mimeType, g_viewable)..., 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
gallerymimetypemap.addmapentry(Array[3]) % line 213, file: GalleryMimeTypeHelper_simple.class
realpath(/var/www/html/gallery2/modules/core/classes/../../../)
Posts: 8601
1) please fill out the support template
2) did you get this error on the very first 0.9.0->0.9.6 upgrade attempt?
my guess is:
a) you're using "mysql (all versions)" for your db
b) it failed once with the error reported here and you got this error on the second try.
if so, i suggest:
i) update from anon cvs later today or get tomorrow's nightly snapshot, so the bug introduced last night is fixed
ii) start the upgrader.. on the core upgrade step if it still says it is upgrading from 0.9.0 then go into your db and delete all rows from g2_MimeTypeMap before clicking to start the core upgrade. the upgrade will populate the table.
Posts: 314
I am afraid you also need to clear a line from g2_Schema table that relates to MimeType (I am not sure and I don't have access to the system right now, but if you still have a problem - check if you have such line)
Posts: 8601
no, that's not needed.. upgrader will skip the table if it sees it exists.