digiital

Joined: 2003-02-22
Posts: 9
Posted: Wed, 2005-03-30 16:15

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/../../../)

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Wed, 2005-03-30 17:01

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.

 
virshu
virshu's picture

Joined: 2003-09-13
Posts: 314
Posted: Thu, 2005-03-31 03:12

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)

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-31 03:58

no, that's not needed.. upgrader will skip the table if it sees it exists.