Hi,
I got this error when I tried to activate the module "create new album when a new user register"
here's the error
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 797 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 261 (mysqldatabasestorage::addmapentry)
* in modules/core/classes/interfaces/GalleryPluginParameterMap.inc at line 124 (gallerystorage::addmapentry)
* in modules/core/classes/helpers/GalleryPluginHelper_medium.class at line 385 (gallerypluginparametermap::addmapentry)
* in modules/core/classes/helpers/GalleryPluginHelper_medium.class at line 335 (gallerypluginhelper_medium::_addparameter)
* in modules/core/classes/GalleryCoreApi.class at line 306 (gallerypluginhelper_medium::setparameter)
* in modules/core/classes/GalleryPlugin.class at line 210 (gallerycoreapi::setpluginparameter)
* in modules/useralbum/module.inc at line 67 (useralbummodule::setparameter)
* in modules/core/classes/GalleryModule.class at line 168 (useralbummodule::upgrade)
* in modules/core/AdminModules.inc at line 68 (useralbummodule::installorupgrade)
* in main.php at line 170 (adminmodulescontroller::handlerequest)
* in main.php at line 47
* in main.php at line 40
btw, this is the latest g2 snapshot from the CVS website. I downloaded the one from 12/15/04
Posted: Wed, 2004-12-15 17:18
Posts: 8601
try again with buffered debug mode in config.php and try to find the database error near the bottom of the debug output. post that here.
i just tried activating the module and it's ok, so i think this is an issue in your environment.
Posts: 12
mindless,
can you explain to me how to do the buffered debug mode in config.php?
when I tried to go to gallery2/config.php directly, this is what I got
Fatal error: Call to a member function on a non-object in /home/darwin/public_html/gallery2/config.php on line 35
Posts: 113
Hint: Open config.php in notepad. Scroll down to "Put Gallery into debug mode. Useful for tracking down problems with the application. Not a good idea to leave it this way, though. Possible debug choices are: 'buffered', 'logged', 'immediate' or false. Don't forget to use the quotes for any value but false!"
Then change the line after the comments from $gallery->setDebug(false); to $gallery->setDebug('buffered');
Save the file, and you're done. Remember to change it back after ;)
Posts: 12
got it....
here's the code from the middle of the page to the end of the line....
Is there anything wrong with it?
(mysql): INSERT INTO g2_ImageBlockCacheMap SELECT DISTINCT 5, 2, g2_Entity.g_creationTimestamp, g2_Entity.g_id FROM g2_Entity, g2_PermissionMap, g2_ChildEntity, g2_Derivative WHERE g2_Entity.g_entityType = 'GalleryAlbumItem' AND (g2_PermissionMap.g_userId = 5 OR g2_PermissionMap.g_groupId IN (1, 3, 2)) AND g2_PermissionMap.g_permission & 1 > 0 AND g2_PermissionMap.g_itemId = g2_Entity.g_id AND g2_ChildEntity.g_parentId = g2_Entity.g_id AND g2_Derivative.g_id = g2_ChildEntity.g_id AND g2_Derivative.g_derivativeType = 1 (mysql): SELECT g2_ImageBlockCacheMap.g_itemId, g2_ImageBlockCacheMap.g_itemTimestamp FROM g2_ImageBlockCacheMap WHERE g2_ImageBlockCacheMap.g_userId = 5 AND g2_ImageBlockCacheMap.g_itemType = 1 ORDER BY RAND() LIMIT 1 file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/members/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_members -> /home/darwin/public_html/gallery2/modules/members/locale file_exists(/home/darwin/public_html/gallery2/g2data/cache/module/members/0/0/0.inc) (mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 5 AND g2_UserGroupMap.g_groupId = '3' LIMIT 1 (mysql): SELECT COUNT(g2_UserGroupMap.g_userId) FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_groupId = '1' file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/newitems/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_newitems -> /home/darwin/public_html/gallery2/modules/newitems/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/panorama/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_panorama -> /home/darwin/public_html/gallery2/modules/panorama/locale file_exists(/home/darwin/public_html/gallery2/g2data/cache/module/panorama/0/0/0.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/rearrange/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_rearrange -> /home/darwin/public_html/gallery2/modules/rearrange/locale (mysql): SELECT g2_ChildEntity.g_parentId, COUNT(DISTINCT g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_PermissionMap WHERE g2_ChildEntity.g_parentId IN (6) AND g2_PermissionMap.g_itemId = g2_ChildEntity.g_id AND (g2_PermissionMap.g_userId = 5 OR g2_PermissionMap.g_groupId IN (1, 3, 2)) AND g2_PermissionMap.g_permission & 1 > 0 GROUP BY g2_ChildEntity.g_parentId file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/register/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_register -> /home/darwin/public_html/gallery2/modules/register/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/search/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_search -> /home/darwin/public_html/gallery2/modules/search/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/slideshow/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_slideshow -> /home/darwin/public_html/gallery2/modules/slideshow/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/debug/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_debug -> /home/darwin/public_html/gallery2/modules/debug/locale (mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 5 AND g2_UserGroupMap.g_groupId = '2' LIMIT 1 file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) (mysql): SELECT g2_ChildEntity.g_parentId, COUNT(DISTINCT g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_PermissionMap WHERE g2_ChildEntity.g_parentId IN (6) AND g2_PermissionMap.g_itemId = g2_ChildEntity.g_id AND (g2_PermissionMap.g_userId = 5 OR g2_PermissionMap.g_groupId IN (1, 3, 2)) AND g2_PermissionMap.g_permission & 1 > 0 GROUP BY g2_ChildEntity.g_parentId (mysql): SELECT g2_Derivative.g_id, g2_ChildEntity.g_parentId FROM g2_Derivative, g2_ChildEntity WHERE g2_Derivative.g_id = g2_ChildEntity.g_id AND g2_ChildEntity.g_parentId IN (6) AND g2_Derivative.g_derivativeType IN (1) ORDER BY g2_Derivative.g_id ASC (mysql): SELECT g2_PermissionMap.g_itemId, BIT_OR(g2_PermissionMap.g_permission) FROM g2_PermissionMap WHERE g2_PermissionMap.g_itemId IN (0) AND (g2_PermissionMap.g_userId = 5 OR g2_PermissionMap.g_groupId IN (1, 3, 2)) GROUP BY g2_PermissionMap.g_itemId file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/gd/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_gd -> /home/darwin/public_html/gallery2/modules/gd/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/imageframe/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_imageframe -> /home/darwin/public_html/gallery2/modules/imageframe/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/randomhighlight/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_randomhighlight -> /home/darwin/public_html/gallery2/modules/randomhighlight/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/remote/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_remote -> /home/darwin/public_html/gallery2/modules/remote/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/squarethumb/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_squarethumb -> /home/darwin/public_html/gallery2/modules/squarethumb/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/thumbnail/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_thumbnail -> /home/darwin/public_html/gallery2/modules/thumbnail/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/uploadapplet/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_uploadapplet -> /home/darwin/public_html/gallery2/modules/uploadapplet/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/watermark/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_watermark -> /home/darwin/public_html/gallery2/modules/watermark/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/webcam/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_webcam -> /home/darwin/public_html/gallery2/modules/webcam/locale file_exists(/home/darwin/public_html/gallery2/modules/imageframe/classes/ImageFrameImpl.class)Posts: 8601
make sure you're looking at the debug output from the exact request where the error occurs.. there are no errors above. click the "activate" link for User Albums and look at the debug output on the page with the error at the top.
Posts: 12
Here's the debug after I click install on the "create new album when a user register"
Error (ERROR_STORAGE_FAILURE): * in file modules/core/classes/GalleryStorage/DatabaseStorage.class at line 797 (gallerystatus::error) * in file modules/core/classes/GalleryStorage.class at line 261 (mysqldatabasestorage::addmapentry) * in file modules/core/classes/interfaces/GalleryPluginParameterMap.inc at line 124 (gallerystorage::addmapentry) * in file modules/core/classes/helpers/GalleryPluginHelper_medium.class at line 385 (gallerypluginparametermap::addmapentry) * in file modules/core/classes/helpers/GalleryPluginHelper_medium.class at line 335 (gallerypluginhelper_medium::_addparameter) * in file modules/core/classes/GalleryCoreApi.class at line 306 (gallerypluginhelper_medium::setparameter) * in file modules/core/classes/GalleryPlugin.class at line 210 (gallerycoreapi::setpluginparameter) * in file modules/useralbum/module.inc at line 67 (useralbummodule::setparameter) * in file modules/core/classes/GalleryModule.class at line 168 (useralbummodule::upgrade) * in file modules/core/AdminModules.inc at line 68 (useralbummodule::installorupgrade) * in file main.php at line 170 (adminmodulescontroller::handlerequest) * in file main.php at line 47 * in file main.php at line 40 file_exists(/home/darwin/public_html/gallery2/g2data/sessions/60bec4b3b2e647a93787a95596ec086e) clearstatcache() filesize(/home/darwin/public_html/gallery2/g2data/sessions/60bec4b3b2e647a93787a95596ec086e) fopen(/home/darwin/public_html/gallery2/g2data/sessions/60bec4b3b2e647a93787a95596ec086e, rb, 0) flock(Resource id #17, 6, ) fread(Resource id #17, 5315) flock(Resource id #17, 3, ) fclose(Resource id #17) file_exists(/home/darwin/public_html/gallery2/g2data/cache/module/core/0/0/0.inc) Initializing navigation Continuing navigation x9999749e file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_core -> /home/darwin/public_html/gallery2/modules/core/locale file_exists(/home/darwin/public_html/gallery2/g2data//versions.dat) file(/home/darwin/public_html/gallery2/g2data//versions.dat, ) [1103213770] can't guarantee 5 -- extending! file_exists(/home/darwin/public_html/gallery2/g2data/cache/entity/0/0/5.inc) file_exists(/home/darwin/public_html/gallery2/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/AdminModules.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/../../../modules/core/AdminModules.inc) (mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 5 AND g2_UserGroupMap.g_groupId = '2' LIMIT 1 file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/useralbum/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_useralbum -> /home/darwin/public_html/gallery2/modules/useralbum/locale file_exists(/home/darwin/public_html/gallery2/g2data/cache/module/useralbum/0/0/0.inc) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/useralbum/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql) (mysql): SHOW TABLES (mysql): SELECT g_name, g_major, g_minor FROM g2_Schema mysql error: [1062: Duplicate entry 'module-useralbum-0-view' for key 1] in EXECUTE("INSERT INTO g2_PluginParameterMap (g_pluginType, g_pluginId, g_itemId, g_parameterName, g_parameterValue) VALUES ('module', 'useralbum', 0, 'view', 'everybody')") (mysql): INSERT INTO g2_PluginParameterMap (g_pluginType, g_pluginId, g_itemId, g_parameterName, g_parameterValue) VALUES ('module', 'useralbum', 0, 'view', 'everybody') 1062: Duplicate entry 'module-useralbum-0-view' for key 1 adodb_mysql._execute(INSERT INTO g2_PluginParameterMap (g_pluginType, g_pluginId, g_i...) % line 818, file: adodb.inc.php adodb_mysql.execute(INSERT INTO g2_PluginParameterMap (g_pluginType, g_pluginId, g_i..., Array[5]) % line 794, file: DatabaseStorage.class mysqldatabasestorage.addmapentry(GalleryPluginParameterMap, Array[5]) % line 261, file: GalleryStorage.class gallerystorage.addmapentry(GalleryPluginParameterMap, Array[5]) % line 124, file: GalleryPluginParameterMap.inc gallerypluginparametermap.addmapentry(Array[5]) % line 385, file: GalleryPluginHelper_medium.class realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../../) file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/comment/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_comment -> /home/darwin/public_html/gallery2/modules/comment/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/customfield/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_customfield -> /home/darwin/public_html/gallery2/modules/customfield/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/exif/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_exif -> /home/darwin/public_html/gallery2/modules/exif/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/gd/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_gd -> /home/darwin/public_html/gallery2/modules/gd/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/imageframe/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_imageframe -> /home/darwin/public_html/gallery2/modules/imageframe/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/newitems/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_newitems -> /home/darwin/public_html/gallery2/modules/newitems/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/panorama/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_panorama -> /home/darwin/public_html/gallery2/modules/panorama/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/randomhighlight/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_randomhighlight -> /home/darwin/public_html/gallery2/modules/randomhighlight/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/register/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_register -> /home/darwin/public_html/gallery2/modules/register/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/remote/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_remote -> /home/darwin/public_html/gallery2/modules/remote/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/slideshow/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_slideshow -> /home/darwin/public_html/gallery2/modules/slideshow/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/squarethumb/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_squarethumb -> /home/darwin/public_html/gallery2/modules/squarethumb/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/thumbnail/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_thumbnail -> /home/darwin/public_html/gallery2/modules/thumbnail/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/uploadapplet/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_uploadapplet -> /home/darwin/public_html/gallery2/modules/uploadapplet/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/watermark/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_watermark -> /home/darwin/public_html/gallery2/modules/watermark/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/webcam/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_webcam -> /home/darwin/public_html/gallery2/modules/webcam/locale file_exists(/home/darwin/public_html/gallery2/modules/core/classes/helpers/../../../../modules/debug/module.inc) realpath(/home/darwin/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_debug -> /home/darwin/public_html/gallery2/modules/debug/locale file_exists(/home/darwin/public_html/gallery2/modules/debug/classes/DebugStatusFormatter.class) file_exists(/home/darwin/public_html/gallery2/g2data/smarty/templates_c/%%592542992) is_dir(/home/darwin/public_html/gallery2/g2data/smarty/templates_c/%%592542992) file_exists(/home/darwin/public_html/gallery2/g2data/smarty/templates_c/%%592542992) is_writeable(/home/darwin/public_html/gallery2/g2data/smarty/templates_c/%%592542992) file_exists(/home/darwin/public_html/gallery2/g2data/smarty/templates_c/%%592542992/v_3) file_exists(/home/darwin/public_html/gallery2/modules/debug/classes/../templates/DebugStatusFormatter.tpl.local) stat(/home/darwin/public_html/gallery2/modules/debug/classes/../templates/DebugStatusFormatter.tpl)Posts: 8601
in your database do:
delete from g2_PluginParameterMap where g_pluginId = 'useralbum';
then try again.. if you get a different error, post that here.