Database Error
An error has occurred while interacting with the database.
Back to the Gallery
Error Detail +
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage.class at line 480 (GalleryCoreApi::error)
* in modules/core/classes/Gallery.class at line 202 (GalleryStorage::search)
* in modules/core/classes/helpers/GalleryUserGroupHelper_simple.class at line 105 (Gallery::search)
* in modules/core/classes/GalleryCoreApi.class at line 1791 (GalleryUserGroupHelper_simple::fetchGroupsForUser)
* in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 242 (GalleryCoreApi::fetchGroupsForUser)
* in modules/core/classes/GalleryCoreApi.class at line 640 (GalleryPermissionHelper_simple::fetchPermissionsForItems)
* in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 441 (GalleryCoreApi::fetchPermissionsForItems)
* in modules/core/classes/GalleryCoreApi.class at line 656 (GalleryPermissionHelper_simple::getPermissions)
* in modules/password/module.inc at line 169 (GalleryCoreApi::getPermissions)
* in modules/core/classes/GalleryEntity.class at line 468 (PasswordModule::onLoad)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 91 (GalleryEntity::onLoad)
* in modules/core/classes/GalleryCoreApi.class at line 2259 (GalleryEntityHelper_simple::loadEntitiesById)
* in modules/core/classes/GalleryView.class at line 363 (GalleryCoreApi::loadEntitiesById)
* in modules/core/ShowItem.inc at line 106 (GalleryView::getItem)
* in modules/core/classes/GalleryView.class at line 408 (ShowItemView::getItem)
* in modules/core/classes/GalleryView.class at line 267 (GalleryView::loadThemeAndParameters)
* in main.php at line 445 (GalleryView::doLoadTemplate)
* in main.php at line 94
* in main.php at line 83
Debug Output
file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter language.useBrowserPref for core plugin file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/module/core/0/0/0.inc) getParameter default.language for core plugin controller , view Loading plugin core Class not defined, trying to include it. file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/module.inc) core plugin successfully instantiated file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/versions.dat) file(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/versions.dat, ) getParameter id.anonymousUser for core plugin [1278591567] can't guarantee 5 -- extending! file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/entity/0/0/5.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/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 (mysqli): SET NAMES "utf8" file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/module/_all/0/0/GalleryStorage_describeMap.inc) mysqli error: [1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist] in EXECUTE("SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1") (mysqli): SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1 Query: SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1 failed. Table 'testuser_db1.g2_UserGroupMap' doesn't exist
1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist
ADOConnection._Execute(SELECT g_userId FROM g2_UserGroupMap
WHERE g_userId=5 AND g_groupId=3 LIMIT 1) % line 870, file: adodb.inc.php
ADOConnection.Execute(SELECT g_userId FROM
g2_UserGroupMap WHERE g_userId=? AND g_groupId=? LIMIT 1, Array[2],
false) % line 607, file: adodb-mysqli.inc.php
ADODB_mysqli.SelectLimit(SELECT g_userId FROM g2_UserGroupMap
WHERE g_userId=? AND g_groupId=?, 1, -1, Array[2]) % line 613, file: GalleryStorage.class
GalleryStorage.getMapEntry(GalleryUserGroupMap, Array[1],
Array[2], Array[1]) % line 2800, file:
GalleryCoreApi.class
GalleryCoreApi.getMapEntry(GalleryUserGroupMap, Array[1],
Array[2], Array[1]) % line 68, file:
GalleryUserGroupHelper_simple.class
getParameter id.rootAlbum for core plugin file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/entity/0/0/7.inc) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/password/module.inc) realpath(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/classes/../../..) Binding text domain: modules_password -> /srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/password/locale mysqli error: [1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist] in EXECUTE(" 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 18446744073709551615") (mysqli): 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 18446744073709551615 Query: 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 18446744073709551615 failed. Table 'testuser_db1.g2_UserGroupMap' doesn't exist
1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist
ADOConnection._Execute(
SELECT
g2_Group.g_id,
g2_Group.g_groupName
FROM
g2_UserGroupMap, g2_Group
WHERE
g2_G...) % line 870, file: adodb.inc.php
ADOConnection.Execute(
SELECT
g2_Group.g_id,
g2_Group.g_groupName
FROM
g2_UserGroupMap, g2_Group
WHERE
g2_G..., Array[1], false) % line
607, file: adodb-mysqli.inc.php
ADODB_mysqli.SelectLimit(
SELECT
g2_Group.g_id,
g2_Group.g_groupName
FROM
g2_UserGroupMap, g2_Group
WHERE
g2_G..., -1, -1, Array[1]) % line
469, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryGroup::id],
[GalleryGroup::groupName]
FROM
[GalleryUserGroupMap], [GalleryGroup]
..., Array[1], Array[1]) % line 202,
file: Gallery.class
Gallery.search(
SELECT
[GalleryGroup::id],
[GalleryGroup::groupName]
FROM
[GalleryUserGroupMap], [GalleryGroup]
..., Array[1], Array[1]) % line 105,
file: GalleryUserGroupHelper_simple.class
Loading plugin comment Class not defined, trying to include it. file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/comment/module.inc) comment plugin successfully instantiated Loading plugin password password plugin successfully instantiated Loading plugin rating Class not defined, trying to include it. file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/rating/module.inc) rating plugin successfully instantiated Loading plugin core core plugin successfully instantiated getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) 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 mysqli error: [1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist] in EXECUTE("SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1") (mysqli): SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1 Query: SELECT g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1 failed. Table 'testuser_db1.g2_UserGroupMap' doesn't exist
1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist
ADOConnection._Execute(SELECT g_userId FROM g2_UserGroupMap
WHERE g_userId=5 AND g_groupId=3 LIMIT 1) % line 870, file: adodb.inc.php
ADOConnection.Execute(SELECT g_userId FROM
g2_UserGroupMap WHERE g_userId=? AND g_groupId=? LIMIT 1, Array[2],
false) % line 607, file: adodb-mysqli.inc.php
ADODB_mysqli.SelectLimit(SELECT g_userId FROM
g2_UserGroupMap WHERE g_userId=? AND g_groupId=?, 1, -1,
Array[2]) % line 613, file: GalleryStorage.class
GalleryStorage.getMapEntry(GalleryUserGroupMap, Array[1],
Array[2], Array[1]) % line 2800, file:
GalleryCoreApi.class
GalleryCoreApi.getMapEntry(GalleryUserGroupMap, Array[1],
Array[2], Array[1]) % line 68, file:
GalleryUserGroupHelper_simple.class
realpath(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/classes/../../../) realpath(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/smarty/templates_c/%%779740250) is_dir(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/smarty/templates_c/%%779740250) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/smarty/templates_c/%%779740250) is_writeable(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/smarty/templates_c/%%779740250) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/bilder/smarty/templates_c/%%779740250/v_12) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) realpath(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/classes/../../..) Binding text domain: themes_matrix -> /srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/themes/matrix/locale file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/../../themes/matrix/local/theme.css) file_exists(/srv/www/vhosts/dev-teamdeluxe.de/httpdocs/gallery2/modules/core/classes/../../../themes/matrix/local/theme.css)
Posts: 8339
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 3
Die Tabelle existiert aber ... ;)
[img]http://gallery.menalto.com/files/screen1.JPG[/img]
Posts: 8339
Ihre alte Windows-Server wurde?
* Nix-Systeme sind bei sensative
UserGroupMap nicht das gleiche usergroupmap
Sorry, wenn mein Deutsch ist schlecht http://translate.google.com
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 8339
http://codex.gallery2.org/File:CaseSensitiveTables.zip
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 3
Okay... ich habe jetzt die installation neu ausgeführt. Die neu erstellten Tabellen habe ich geleert und die alten Inhalte eingeführt. Jetzt funktioniert die Gallery. Jedoch ist kein Album vorhanden ?!
Posts: 8339
Sie können Ihre alten Tabellen und Daten vor dem Import, aber Sie müssen die SQL aus der Tabelle fixieren Skript ausführen http://codex.gallery2.org/File:CaseSensitiveTables.zip
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2