G2 doesn't want to create table "g2_GalleryModuleParame

birdisthelaw
birdisthelaw's picture

Joined: 2002-10-25
Posts: 10
Posted: Wed, 2002-12-18 16:08

This is the debug information:

Quote:
(mysql): SELECT g2_GalleryModuleParameterMap.g_parameterName,g2_GalleryModuleParameterMap.g_parameterValue FROM g2_GalleryModuleParameterMap WHERE g2_GalleryModuleParameterMap.g_moduleName='core'
--------------------------------------------------------------------------------
1146: Table 'gallery2.g2_GalleryModuleParameterMap' doesn't exist
mysql error: [1146: Table 'gallery2.g2_GalleryModuleParameterMap' doesn't exist] in EXECUTE("SELECT g2_GalleryModuleParameterMap.g_parameterName,g2_GalleryModuleParameterMap.g_parameterValue FROM g2_GalleryModuleParameterMap WHERE g2_GalleryModuleParameterMap.g_moduleName='core'") Can't load core version -- assuming that the core needs installation opendir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): SELECT g2_GalleryModuleParameterMap.g_parameterName,g2_GalleryModuleParameterMap.g_parameterValue FROM g2_GalleryModuleParameterMap WHERE g2_GalleryModuleParameterMap.g_moduleName='core'
--------------------------------------------------------------------------------
1146: Table 'gallery2.g2_GalleryModuleParameterMap' doesn't exist
mysql error: [1146: Table 'gallery2.g2_GalleryModuleParameterMap' doesn't exist] in EXECUTE("SELECT g2_GalleryModuleParameterMap.g_parameterName,g2_GalleryModuleParameterMap.g_parameterValue FROM g2_GalleryModuleParameterMap WHERE g2_GalleryModuleParameterMap.g_moduleName='core'") file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/) fopen(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data//setup8982, w, 0) unlink(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data//setup8982) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/albums/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/albums/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/albums/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/albums/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/cache/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/cache/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/cache/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/cache/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/tmp/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/tmp/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/tmp/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/tmp/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/templates_c/) is_dir(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/templates_c/) file_exists(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/templates_c/) is_writeable(/usr/local/psa/home/vhosts/dominikgolob.com/httpdocs/cgi-php/gallery2/data/smarty/templates_c/) Congratulations, we’ve successfully connected to your storage system. This means that the authentication information you entered in your gallery/config.php is valid.

What could be wrong?
.:b.i.r.d:.

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Sun, 2002-12-29 19:41

That's not actually an error. You'll see that a bit farther down it says:

Quote:
Can't load core version -- assuming that the core needs installation

Gallery uses the existence of the "g2_GalleryModuleParameterMap" table to decide whether or not the core module is installed yet. If that table is not installed then it proceeds to install the table. Most folks won't see this because this error is captured and handled (so it'll only show up in the debug logs).

Did everything else work?

 
birdisthelaw
birdisthelaw's picture

Joined: 2002-10-25
Posts: 10
Posted: Tue, 2002-12-31 13:52

No, it's not OK. When I go to main.php it says(with debug mode "false"):

Quote:
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1165
in modules/core/classes/Gallery.class at line 370
in modules/core/classes/GalleryModuleParameterMap.class at line 135
in modules/core/classes/Gallery.class at line 1200
in modules/core/classes/GalleryModule.class at line 299
in modules/core/module.inc at line 288
in init.php at line 111
in main.php at line 47
in main.php at line 30

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Wed, 2003-01-01 10:46

Humm. That's odd. Can you get the latest code, then put your G2 in buffered debug mode, delete everything under your gallery data directory (make sure it's writeable by apache though) then private message me your G2 URL and config password? I'll try configuring it remotely and see what I can learn.