Here I am again with an error of my gallery ;)
An error has occurred while interacting with the database.
Debug Output
file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) file_exists(/home/qualsde/public_html/gallery2/modules/rewrite/classes/parsers/modrewrite/ModRewriteUrlGenerator.class) getParameter shortUrls for rewrite plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/rewrite/0/0/0.inc) getParameter language.useBrowserPref for core plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/core/0/0/0.inc) controller , view Loading plugin core Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/core/module.inc) core plugin successfully instantiated file_exists(/home/qualsde/public_html/gallery2/g2data/versions.dat) file(/home/qualsde/public_html/gallery2/g2data/versions.dat, ) file_exists(/home/qualsde/public_html/gallery2/modules/httpauth/classes/HttpAuthPlugin.class) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/httpauth/0/0/0.inc) getParameter id.anonymousUser for core plugin [1210522893] can't guarantee 5 -- extending! file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/0/5.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/home/qualsde/public_html/gallery2/modules/core/ShowItem.inc) getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin getParameter id.anonymousUser for core plugin getParameter id.adminGroup for core plugin (mysqlt): SET NAMES "utf8" file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) (mysqlt): SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1 getParameter id.rootAlbum for core plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/0/7.inc) getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok file_exists(/home/qualsde/public_html/gallery2/g2data/cache/theme/matrix/0/0/0.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/theme/matrix/0/0/7.inc) (mysqlt): SELECT g2_Group.g_id, g2_Group.g_groupName FROM g2_UserGroupMap, g2_Group WHERE g2_Group.g_id = g2_UserGroupMap.g_groupId AND g2_UserGroupMap.g_userId = 5 ORDER BY g2_Group.g_groupName LIMIT 2147483647 (mysqlt): SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g2_PermissionSetMap realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_comment -> /home/qualsde/public_html/gallery2/modules/comment/locale realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_core -> /home/qualsde/public_html/gallery2/modules/core/locale realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_rating -> /home/qualsde/public_html/gallery2/modules/rating/locale realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_checkout -> /home/qualsde/public_html/gallery2/modules/checkout/locale (mysqlt): SELECT DISTINCT g2_AccessMap.g_accessListId FROM g2_AccessMap WHERE g2_AccessMap.g_userOrGroupId IN (5,4) AND g2_AccessMap.g_permission & 1 = 1 (mysqlt): SELECT g_itemId FROM g2_AccessSubscriberMap WHERE g_itemId=7 AND g_accessListId IN (587,588,585,586,589,590) LIMIT 1 getParameter modrewrite.galleryLocation for rewrite plugin file_exists(/home/qualsde/public_html/gallery2/modules/core/classes/../../../themes/local/matrix) getParameter modrewrite.galleryLocation for rewrite plugin getParameter misc.markup for core plugin file_exists(/home/qualsde/public_html/gallery2/modules/core/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/exif/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/search/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/albumselect/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/imageblock/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/imageblock/0/0/0.inc) Unimplemented: ImageFrameInterface_1_1 file_exists(/home/qualsde/public_html/gallery2/modules/core/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/checkout/Preloads.inc) file_exists(/home/qualsde/public_html/gallery2/modules/icons/classes/IconsImpl.class) getParameter iconpack for icons plugin file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/icons/0/0/0.inc) file_exists(/home/qualsde/public_html/gallery2/modules/colorpack/classes/ColorPackImpl.class) getParameter default.orderBy for core plugin getParameter default.orderDirection for core plugin (mysqlt): SELECT g2_ChildEntity.g_id, g2_Entity.g_creationTimestamp FROM g2_ChildEntity INNER JOIN g2_Entity ON g2_ChildEntity.g_id = g2_Entity.g_id INNER JOIN g2_Item ON g2_ChildEntity.g_id = g2_Item.g_id INNER JOIN g2_AccessSubscriberMap ON g2_ChildEntity.g_id = g2_AccessSubscriberMap.g_itemId WHERE g2_ChildEntity.g_parentId = 7 AND g2_AccessSubscriberMap.g_accessListId IN (587,588,585,586,589,590) ORDER BY g2_Entity.g_creationTimestamp, g2_ChildEntity.g_id LIMIT 15 Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/1/15.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/1/17.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/1/19.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/2/21.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/2/23.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/2/25.inc) (mysqlt): SELECT g2_AccessSubscriberMap.g_itemId, BIT_OR(g2_AccessMap.g_permission) FROM g2_AccessMap, g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId IN (15,17,19,21,23,25) AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND g2_AccessMap.g_userOrGroupId IN (5,4) GROUP BY g2_AccessSubscriberMap.g_itemId [1210522895] can't guarantee 30 -- extending! (mysqlt): SELECT g2_ChildEntity.g_parentId, COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_AccessSubscriberMap WHERE g2_ChildEntity.g_parentId IN (7,15,17,19,21,23,25) AND g2_AccessSubscriberMap.g_itemId = g2_ChildEntity.g_id AND g2_AccessSubscriberMap.g_accessListId IN (587,588,585,586,589,590) GROUP BY g2_ChildEntity.g_parentId getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok (mysqlt): SELECT g_parentSequence FROM g2_ItemAttributesMap WHERE g_itemId=7 file_exists(/home/qualsde/public_html/gallery2/g2data/cache/entity/0/0/6.inc) (mysqlt): SELECT g_itemId, g_viewCount FROM g2_ItemAttributesMap WHERE g_itemId IN (7,15,17,19,21,23,25) (mysqlt): SELECT g_itemId, g_descendentCount FROM g2_DescendentCountsMap WHERE g_userId=5 AND g_itemId IN (7,15,17,19,21,23,25) (mysqlt): SELECT g2_AccessSubscriberMap.g_itemId, BIT_OR(g2_AccessMap.g_permission) FROM g2_AccessMap, g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId IN (7) AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND g2_AccessMap.g_userOrGroupId IN (5,4) GROUP BY g2_AccessSubscriberMap.g_itemId Loading plugin customfield Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/customfield/module.inc) customfield plugin successfully instantiated Check the version of the customfield plugin The version of the customfield plugin is ok file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/1/15.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/0/0.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/1/17.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/1/19.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/2/21.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/2/23.inc) file_exists(/home/qualsde/public_html/gallery2/g2data/cache/module/customfield/0/2/25.inc) mysqlt error: [1017: Can't find file: 'g2_CustomFieldMap' (errno: 2)] in EXECUTE("SELECT g_itemId, g_field, g_value FROM g2_CustomFieldMap WHERE g_itemId IN (15,17,19,21,23,25)") (mysqlt): SELECT g_itemId, g_field, g_value FROM g2_CustomFieldMap WHERE g_itemId IN (15,17,19,21,23,25) 1017: Can't find file: 'g2_CustomFieldMap' (errno: 2)
adodb_mysqlt._execute(SELECT g_itemId, g_field, g_value FROM
g2_CustomFieldMap WHERE g_itemId IN (15,17,19,21,23,25)) % line 870, file: adodb.inc.php
adodb_mysqlt.execute(SELECT g_itemId,
g_field, g_value FROM g2_CustomFieldMap WHERE g_itemId IN (?,?,?,?,?,?),
Array[6]) % line 617, file: GalleryStorage.class
mysqlstorage.getmapentry(CustomFieldMap,
Array[3], Array[1], Array[0]) % line
2800, file: GalleryCoreApi.class
gallerycoreapi.getmapentry(CustomFieldMap,
Array[3], Array[1]) % line 222, file:
CustomFieldHelper.class
customfieldhelper.fetchfieldvalues(Array[6],
summary) % line 87, file: module.inc
Loading plugin customfield customfield plugin successfully instantiated Loading plugin watermark Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/watermark/module.inc) watermark plugin successfully instantiated Loading plugin password Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/password/module.inc) realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: modules_password -> /home/qualsde/public_html/gallery2/modules/password/locale password plugin successfully instantiated Loading plugin albumselect Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/albumselect/module.inc) albumselect plugin successfully instantiated Loading plugin httpauth Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/httpauth/module.inc) httpauth plugin successfully instantiated Loading plugin checkout Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/checkout/module.inc) checkout plugin successfully instantiated Loading plugin rewrite Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/rewrite/module.inc) rewrite plugin successfully instantiated Loading plugin quotas Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/quotas/module.inc) quotas plugin successfully instantiated Loading plugin imageblock Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/imageblock/module.inc) imageblock plugin successfully instantiated Loading plugin multilang Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/multilang/module.inc) multilang plugin successfully instantiated Loading plugin sizelimit Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/sizelimit/module.inc) sizelimit plugin successfully instantiated Loading plugin linkitem Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/linkitem/module.inc) linkitem plugin successfully instantiated Loading plugin permalinks Class not defined, trying to include it. file_exists(/home/qualsde/public_html/gallery2/modules/permalinks/module.inc) permalinks plugin successfully instantiated Loading plugin core core plugin successfully instantiated getParameter default.theme for core plugin Loading plugin matrix matrix plugin successfully instantiated Check the version of the matrix plugin The version of the matrix plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok getParameter id.adminGroup for core plugin realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../../) realpath(/home/qualsde/public_html/gallery2/) file_exists(/home/qualsde/public_html/gallery2/g2data/smarty/templates_c/%%3888041688) is_dir(/home/qualsde/public_html/gallery2/g2data/smarty/templates_c/%%3888041688) file_exists(/home/qualsde/public_html/gallery2/g2data/smarty/templates_c/%%3888041688) is_writeable(/home/qualsde/public_html/gallery2/g2data/smarty/templates_c/%%3888041688) file_exists(/home/qualsde/public_html/gallery2/g2data/smarty/templates_c/%%3888041688/v_12) file_exists(/home/qualsde/public_html/gallery2/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../..) Binding text domain: themes_matrix -> /home/qualsde/public_html/gallery2/themes/matrix/locale file_exists(/home/qualsde/public_html/gallery2/modules/core/../../themes/matrix/local/theme.css) file_exists(/home/qualsde/public_html/gallery2/modules/core/classes/../../../themes/matrix/local/theme.
I see where the problem is, but I´m not exactly sure what I can do about it, how it happened for I didn´t change anything (yeah, I know EVERYONE says that) and I also didn´t want to make it worse. Any help is hugely appreciated. Thanks.
Posts: 10096
Can you login to the admin page and disable the custom field module?
If the login view doesn't work, you can try to login manually with http://www.example.com/gallery/main.php?g2_controller=core.UserLogin&g2_form[formName]=UserLogin& g2_form[action][login]=Login&g2_form[username]=admin&g2_form[password]=secret
(replace "secret" with your own password)
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
That doesn´t seem to possible. If I try that, I get another output, though.
Before the debug output the following is displayed: (But that doesn´t seem to be connected to the forementioned error... or is it?)
Error Detail -
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage.class at line 624 (gallerycoreapi::error)
* in modules/core/classes/GalleryCoreApi.class at line 2800 (mysqlstorage::getmapentry)
* in modules/customfield/classes/CustomFieldHelper.class at line 222 (gallerycoreapi::getmapentry)
* in modules/customfield/module.inc at line 87 (customfieldhelper::fetchfieldvalues)
* in modules/core/classes/GalleryTheme.class at line 1519 (customfieldmodule::getitemsummaries)
* in themes/matrix/theme.inc at line 65 (matrixtheme::loadcommontemplatedata)
* in modules/core/classes/GalleryTheme.class at line 926 (matrixtheme::showalbumpage)
* in modules/core/classes/GalleryView.class at line 308 (matrixtheme::loadtemplate)
* in main.php at line 441 (showitemview::doloadtemplate)
* in main.php at line 94
* in main.php at line 83
System Information
Gallery version 2.2.3
PHP version 4.4.8 apache
Webserver Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8b
Database mysqlt 4.1.22-standard-log
Toolkits ImageMagick
Operating system Linux goofy.cirtexhosting.com 2.6.24.3-JS-grsec #1 SMP Tue Mar 18 02:32:53 CDT 2008 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
I suppose I have to do do something in the database itself?
Posts: 10096
FAQ: How can I deactivate a module when I am unable to login?
Try to disable the module module via phpMyadmin
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 21
Thank you for your answer.
I executed the following sql:
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='customfield';# Betroffene Datensätze: 1
DELETE FROM g2_FactoryMap WHERE g_implModuleId='customfield';# Betroffene Datensätze: 3
Then I tried to empty the cache as explained here: http://codex.gallery2.org/Gallery2:FAQ#How_can_I_clear_cached_data.3F
After I had typed in my password I get the following. Now, I can´t make anything out of that.
Warning: unlink(/home/qualsde/public_html/gallery2/g2data/cache/module/core/0/0/0.inc) [function.unlink]: Keine Berechtigung in /home/qualsde/public_html/gallery2/modules/core/classes/GalleryPlatform.class on line 481
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/qualsde/public_html/gallery2/modules/core/classes/GalleryPlatform.class:481) in /home/qualsde/public_html/gallery2/lib/support/GallerySetupUtilities.class on line 75
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/qualsde/public_html/gallery2/modules/core/classes/GalleryPlatform.class:481) in /home/qualsde/public_html/gallery2/lib/support/GallerySetupUtilities.class on line 75
Warning: Cannot modify header information - headers already sent by (output started at /home/qualsde/public_html/gallery2/modules/core/classes/GalleryPlatform.class:481) in /home/qualsde/public_html/gallery2/lib/support/GallerySetupUtilities.class on line 210
Posts: 962
"Keine Berechtigung" means that your apache process does not have permission to delete the file "/home/qualsde/public_html/gallery2/g2data/cache/module/core/0/0/0.inc"
This FAQ entry might be of help:
FAQ: How can I fix the filesystem permissions of the Gallery storage folder?
Posts: 21
Wow, thanks a lot! The gallery is up again. Everything worked the way you suggested!
THANK YOU!
I still get the following error output though:
17: Can't find file: 'g2_ImageBlockCacheMap' (errno: 2)
adodb_mysqlt._execute(SELECT COUNT(*) FROM
g2_ImageBlockCacheMap WHERE g2_ImageBlockCacheMap.g_userId =
6) % line 870, file: adodb.inc.php
adodb_mysqlt.execute(SELECT COUNT(*) FROM
g2_ImageBlockCacheMap WHERE g2_ImageBlockCacheMap.g_userId = ?,
Array[1]) % line 473, file: GalleryStorage.class
mysqlstorage.search(SELECT COUNT(*) FROM [ImageBlockCacheMap]
WHERE [ImageBlockCacheMap::userId] = ?, Array[1], Array[0]) % line 202, file: Gallery.class
gallery.search(SELECT
COUNT(*) FROM [ImageBlockCacheMap] WHERE [ImageBlockCacheMap::userId] = ?,
Array[1]) % line 660, file: ImageBlockHelper.class
imageblockhelper._iscached(6) % line 572, file: ImageBlockHelper.class
Error performing imageblock.LoadImageBlock callback realpath(/home/qualsde/public_html/gallery2/modules/core/classes/../../../) realpath(/home/qualsde/public_html/gallery2/) Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage.class at line 480 (gallerycoreapi::error)
* in modules/core/classes/Gallery.class at line 202 (mysqlstorage::search)
* in modules/imageblock/classes/ImageBlockHelper.class at line 660 (gallery::search)
* in modules/imageblock/classes/ImageBlockHelper.class at line 572 (imageblockhelper::_iscached)
* in modules/imageblock/classes/ImageBlockHelper.class at line 283 (imageblockhelper::fetchviewabledata)
* in modules/imageblock/classes/ImageBlockHelper.class at line 93 (imageblockhelper::_getblockdata)
* in modules/imageblock/Callbacks.inc at line 79 (imageblockhelper::loadimageblocks)
* in modules/core/classes/GalleryTemplateAdapter.class at line 875 (imageblockcallbacks::callback)
* in g2data/smarty/templates_c/%%3888041688/%%A3^A3E^A3E218EA%%ImageBlock.tpl.php at line 5 (gallerytemplateadapter::callback)
* in lib/smarty/Smarty.class.php at line 1871
* in modules/core/classes/GalleryTemplateAdapter.class at line 806 (gallerysmarty::_smarty_include)
* in g2data/smarty/templates_c/%%3888041688/%%B4^B49^B49848CB%%sidebar.tpl.php at line 6 (gallerytemplateadapter::block)
* in lib/smarty/Smarty.class.php at line 1871
* in modules/core/classes/GalleryTemplateAdapter.class at line 747 (gallerysmarty::_smarty_include)
* in g2data/smarty/templates_c/%%3888041688/%%42^42C^42CE7724%%album.tpl.php at line 9 (gallerytemplateadapter::theme)
* in lib/smarty/Smarty.class.php at line 1871
* in modules/core/classes/GalleryTemplateAdapter.class at line 747 (gallerysmarty::_smarty_include)
* in g2data/smarty/templates_c/%%3888041688/%%3A^3A8^3A818B59%%theme.tpl.php at line 49 (gallerytemplateadapter::theme)
* in lib/smarty/Smarty.class.php at line 1265
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 186 (gallerysmarty::fetch)
* in main.php at line 479 (gallerytemplate::fetch)
* in main.php at line 94
* in main.php at line 83