restoring Gallery

www.nodaddy.com yes godaddy absolutely sucks all around.

This is a total WTF moment to have to uninstall all that to enable SSH. But it sounds they, as usual, totally screw with their customers to do this.

Since you may or may not have moved physical servers, try to make sure you followed these directions as closely as possible, it sounds like a permissions issue most likely:
FAQ: How can I move my gallery installation from one server to another?

FAQ: How can I fix the filesystem permissions of the Gallery storage folder?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

OK. The fact that the root gallery for your installation is showing empty ("has no items") means that the database that you're pointing the G2 code to (via the entries in the config.php) is *not* the one that contains your image data. That's where you need to be checking. Whhich database did you recover your data to, and which database is your config.php pointing at.

Oh, that was easy. Set debug to true and got this output. Am I missing a plugin?

Error
Error (ERROR_STORAGE_FAILURE)

    * in modules/core/classes/GalleryStorage.class at line 495 (GalleryCoreApi::error)
    * in modules/core/classes/GalleryStorage.class at line 1291 (GalleryStorage::search)
    * in modules/core/classes/GalleryStorage.class at line 1238 (GalleryStorage::_getEntityOrMapInfo)
    * in modules/core/classes/GalleryStorage.class at line 572 (GalleryStorage::describeMap)
    * in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry)
    * in modules/core/classes/GallerySession.class at line 872 (GalleryCoreApi::getMapEntry)
    * in modules/core/classes/GallerySession.class at line 231 (GallerySession::_loadSessionData)
    * in modules/core/classes/Gallery.class at line 294 (GallerySession::init)
    * in init.inc at line 128 (Gallery::initSession)
    * in main.php at line 81

Debug Output

file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
Unimplemented: GalleryUrlGenerator
getParameter session.lifetime for core plugin
file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/cache/module/core/0/0/0.inc)
getParameter session.inactivityTimeout for core plugin

(mysql): SET NAMES "utf8"   


mysql error: [1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist] in
EXECUTE("SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1")


(mysql): SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1   

1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist

                     
     ADOConnection._Execute(SELECT g2_Schema.g_info FROM
g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc...) % line  872, file: adodb.inc.php
                        ADOConnection.Execute(SELECT g2_Schema.g_info
FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc..., Array[2]) % line 
488, file: GalleryStorage.class
                     GalleryStorage.search(SELECT [Schema::info] FROM
[GalleryPluginMap], [Schema]
		       WHERE [GalleryPluginMap::pluginId] = [Schema::pluginId]
			 AND..., Array[2]) % line 1291,
file: GalleryStorage.class
                  GalleryStorage._getEntityOrMapInfo(map, false) % line 1238, file: GalleryStorage.class
               GalleryStorage.describeMap(GallerySessionMap) % line  572, file: GalleryStorage.class


Loading plugin core
Class not defined, trying to include it.
file_exists(/home/content/g/r/i/griztown1/html/gallery/modules/core/module.inc)
core plugin successfully instantiated
Check the version of the core plugin
file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
The version of the core plugin is ok
file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/versions.dat)
file(/home/content/g/r/i/griztown1/html/gallery/g2data/versions.dat, )
getParameter language.useBrowserPref for core plugin
getParameter default.language for core plugin
getParameter default.theme for core plugin
Loading plugin matrix
Class not defined, trying to include it.
file_exists(/home/content/g/r/i/griztown1/html/gallery/themes/matrix/theme.inc)
matrix plugin successfully instantiated
Check the version of the matrix plugin
file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/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 smarty.compile_check for core plugin
getParameter id.adminGroup for core plugin
mysql error: [1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist] in
EXECUTE("SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1")


(mysql): SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1   

1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist

                     
           ADOConnection._Execute(SELECT g2_Schema.g_info FROM
g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc...) % line  872, file: adodb.inc.php
                           
  ADOConnection.Execute(SELECT
g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc..., Array[2]) % line 
488, file: GalleryStorage.class
                          
GalleryStorage.search(SELECT
[Schema::info] FROM [GalleryPluginMap], [Schema]
		       WHERE [GalleryPluginMap::pluginId] = [Schema::pluginId]
			 AND..., Array[2]) % line 1291,
file: GalleryStorage.class
                        GalleryStorage._getEntityOrMapInfo(map,
false) % line 1238, file: GalleryStorage.class
                     GalleryStorage.describeMap(GalleryUserGroupMap) % line  572, file: GalleryStorage.class


realpath(/home/content/g/r/i/griztown1/html/gallery/modules/core/classes/../../../)
realpath(/home/content/g/r/i/griztown1/html/gallery/)
getParameter id.rootAlbum for core plugin
[1269627934] can't guarantee 5 -- extending!
file_exists(/home/content/g/r/i/griztown1/html/gallery/g2data/cache/entity/0/0/7.inc)
mysql error: [1146: Table 'kat1007611361892.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 = 0
	    ORDER BY
	      g2_Group.g_groupName
	     LIMIT 2147483647")


(mysql): 
	    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 = 0
	    ORDER BY
	      g2_Group.g_groupName
	     LIMIT 2147483647   

1146: Table 'kat1007611361892.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  872, 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]) % line  498,
file: adodb-mysql.inc.php
                           
              ADODB_mysql.SelectLimit(
	    SELECT
	      g2_Group.g_id,
	      g2_Group.g_groupName
	    FROM
	      g2_UserGroupMap, g2_Group
	    WHERE
	      g2_G..., -1, -1, Array[1]) %
line  484, file: GalleryStorage.class
                           
           GalleryStorage.search(
	    SELECT
	      [GalleryGroup::id],
	      [GalleryGroup::groupName]
	    FROM
	      [GalleryUserGroupMap], [GalleryGroup]
..., Array[1], Array[1]) % line  209,
file: Gallery.class
                           
        Gallery.search(
	    SELECT
	      [GalleryGroup::id],
	      [GalleryGroup::groupName]
	    FROM
	      [GalleryUserGroupMap], [GalleryGroup]
..., Array[1], Array[1]) % line  105,
file: GalleryUserGroupHelper_simple.class


getParameter id.adminGroup for core plugin
mysql error: [1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist] in
EXECUTE("SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1")


(mysql): SELECT g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Schema.g_type = 'map' AND g2_PluginMap.g_active = 1   

1146: Table 'kat1007611361892.g2_PluginMap' doesn't exist

                     
        ADOConnection._Execute(SELECT g2_Schema.g_info FROM
g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc...) % line  872, file: adodb.inc.php
                          
ADOConnection.Execute(SELECT
g2_Schema.g_info FROM g2_PluginMap, g2_Schema
		       WHERE g2_PluginMap.g_pluginId = g2_Schema.g_pluginId
			 AND g2_Sc..., Array[2]) % line 
488, file: GalleryStorage.class
                        GalleryStorage.search(SELECT [Schema::info] FROM
[GalleryPluginMap], [Schema]
		       WHERE [GalleryPluginMap::pluginId] = [Schema::pluginId]
			 AND..., Array[2]) % line 1291,
file: GalleryStorage.class
                     GalleryStorage._getEntityOrMapInfo(map,
false) % line 1238, file: GalleryStorage.class
                  GalleryStorage.describeMap(GalleryUserGroupMap) % line  572, file: GalleryStorage.class


realpath(/home/content/g/r/i/griztown1/html/gallery/modules/core/classes/../../../)
realpath(/home/content/g/r/i/griztown1/html/gallery/)

So it says PluginsMap is missing. Searching the database backup file it is definitely in there. Then I noticed that my db restore didn't actually work! Woops! I was given this error:

I've commented out the CREATE DATABASE and USE lines at the top and am trying to restore again. Hopefully this will work.

Because that's a normal part of that table.

Then you are missing the columns g_createSql, g_pluginId, g_type, g_info. I deduce that your backup/restore procedure failed at some point.

Please don't post debug logs as quotes - post them as .txt attachments, otherwise it makes the thread very difficult to read. Thanks.

Gallery version 1 doesn't use a database at all.

If you can't restore from a backup, install a fresh installation (looks like you've already done that bit ok) and import all your pictures from scratch. You can do that in one go if there are sufficiently few of them (depending on your server resources) by moving the g2data/albums directory from the old installation somewhere else on the server before the reinstallation - that directory contains the jpgs - and using the serveradd module, which will allow you to import from a local directory on the server. Obviously point it at wherever you moved the old g2data/albums directory to.

You will not be able to import any other data though, like titles, comments, users, and so forth.