Gallery2 umzug auf neuen Server

Bl4ckJok3r

Joined: 2010-07-08
Posts: 3
Posted: Thu, 2010-07-08 12:22

Hallo zusammen,

ich möchte meine Gallery2 (Version 2.2) auf einen neuen Server umziehen.
Ich habe die Datenbank via PHPmyAdmin gesichert und alle Files inklusive Datenordner auf den neuen FTP geladen.

Danach habe ich die config.php im Gallery2-Ordner für den neuen MySQL Server angepasst.

Wnn ich die Gallery über den Browser öffne, erscheint folgender Fehler:

Quote:
Error
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

Smarty Debug:

Quote:
Smarty Debug Console
included templates & config files (load time in seconds)
themes/matrix/templates/error.tpl (0,10892) (total)
modules/core/templates/ErrorPage.tpl (0,00418)
assigned template variables
{$ErrorPage} Array (3)
isAdmin => false
stackTrace => "Error (ERROR_STORAGE_FAILURE)<ul><li..."
code => Array (1)
storageFailure => true
{$SCRIPT_NAME} "/gallery2/main.php"
{$_debug_config_keys} Array (2)
0 => "files"
1 => "vars"
{$_debug_config_vals} Array (2)
0 => Array (0)
1 => Array (0)
{$_debug_keys} Array (5)
0 => "ErrorPage"
1 => "SCRIPT_NAME"
2 => "head"
3 => "l10Domain"
4 => "theme"
{$_debug_tpls} Array (2)
0 => Array (3)
type => "template"
filename => "themes/matrix/templates/error.tpl"
depth => 0
1 => Array (4)
type => "template"
filename => "modules/core/templates/ErrorPage.tpl"
depth => 1
exec_time => 0,004176139831543
{$_debug_vals} Array (5)
0 => Array (3)
isAdmin => false
stackTrace => "Error (ERROR_STORAGE_FAILURE)<ul><li..."
code => Array (1)
storageFailure => true
1 => "/gallery2/main.php"
2 => Array (3)
tpl => Array (0)
style => Array (0)
javascript => Array (1)
0 => "lib/javascript/BlockToggle.js"
3 => "themes_matrix"
4 => Array (1)
errorTemplate => "modules/core/templates/ErrorPage.tpl"
{$debug_output} "<!DOCTYPE html PUBLIC "-//W3C//DTD XH..."
{$head} Array (3)
tpl => Array (0)
style => Array (0)
javascript => Array (1)
0 => "lib/javascript/BlockToggle.js"
{$l10Domain} "themes_matrix"
{$theme} Array (1)
errorTemplate => "modules/core/templates/ErrorPage.tpl"
assigned config file variables (outer template scope)
{#files#} Array (0)
{#vars#} Array (0)

Debug

Quote:
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)

Ich hoffe ihr könnt damit mehr anfangen wie ich.

Viele Dank für eure Hilfe schon im Voraus.

Gruss
Dominik

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-07-08 12:33
Quote:
1146: Table 'testuser_db1.g2_UserGroupMap' doesn't exist

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

 
Bl4ckJok3r

Joined: 2010-07-08
Posts: 3
Posted: Thu, 2010-07-08 12:51

Die Tabelle existiert aber ... ;)

[img]http://gallery.menalto.com/files/screen1.JPG[/img]

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-07-08 13:03

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-07-08 13:15
 
Bl4ckJok3r

Joined: 2010-07-08
Posts: 3
Posted: Thu, 2010-07-08 13:26

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 ?!

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-07-08 13:42

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