[SOLVED] ERROR_STORAGE_FAILURE line 1126

moogleii

Joined: 2004-01-26
Posts: 20
Posted: Sun, 2005-02-20 20:39

I've installed G2, and the installation seemed fine, however when i try to view the gallery, i get this:

Error
Error (ERROR_STORAGE_FAILURE) :

* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1126 (MySqlDatabaseStorage::error)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\GalleryStorage.class at line 220 (MySqlDatabaseStorage::search)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\Gallery.class at line 189 (GalleryStorage::search)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 256 (Gallery::search)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 197 (Gallery::fetchAllParameters)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\GalleryCoreApi.class at line 204 (Gallery::getParameter)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\Gallery.class at line 507 (Gallery::getPluginParameter)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\modules\core\classes\Gallery.class at line 479 (Gallery::getActiveLanguageCode)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\init.php at line 140 (Gallery::initTranslator)
* in C:\Program Files\Apache Group\Apache2\htdocs\gallery2\main.php at line 32

Debug Output

file_exists(C:\g2data\cache\module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
-----
(mysql):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

-----

file_exists(C:\g2data\cache\module/_all/0/0)
fopen(C:\g2data\cache\module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc,
wb, 0)
flock(Resource id #32, 2, )
fwrite(Resource id #32, ..., )
fwrite(Resource id #32, ..., )
fwrite(Resource id #32, ..., )
fwrite(Resource id #32, ..., )
fclose(Resource id #32)
Unimplemented: GalleryUrlGenerator
file_exists(C:\g2data\sessions\52aab765fd2b6ef65f9bfccf3bf51e91)
file_exists(C:\g2data\cache\module/core/0/0/0.inc)
mysql error: [1146: Table 'gallery2.g2_pluginparametermap' doesn't exist]
in EXECUTE("
SELECT
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_parameterValue
FROM
g2_PluginParameterMap
WHERE
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_pluginId = 'core'
AND
g2_PluginParameterMap.g_itemId = 0
")

-----
(mysql):
SELECT
g2_PluginParameterMap.g_parameterName,
g2_PluginParameterMap.g_parameterValue
FROM
g2_PluginParameterMap
WHERE
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_pluginId = 'core'
AND
g2_PluginParameterMap.g_itemId = 0

-----
1146: Table 'gallery2.g2_pluginparametermap' doesn't exist

ADODB_mysql._Execute(
SELECT
g2_PluginParameter...) % line 818, file: adodb.inc.php
ADODB_mysql.Execute(
SELECT
g2_PluginParameter..., Array[3]) % line 1118, file: DatabaseStorage.class
MySqlDatabaseStorage.search(
SELECT
[GalleryPluginPara..., Array[3], Array[0]) % line 220, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryPluginPara..., Array[3], Array[0]) % line 189, file: Gallery.class
Gallery.search(
SELECT
[GalleryPluginPara..., Array[3]) % line 256, file: GalleryPluginHelper_simple.class

realpath(C:\Program Files\Apache
Group\Apache2\htdocs\gallery2\modules\core\classes/../../../)

----

Gallery URL (optional):
Gallery version: G2 2-19-05
Webserver (with version): apache 2.0.53
Datatabase (with version): mysql 4.1.10-nt
PHP version (eg 4.2.1): 5.0.3
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system: XP SP1
Web browser/version: Firefox 1
 
volksport
volksport's picture

Joined: 2002-10-06
Posts: 239
Posted: Sun, 2005-02-20 21:31

First, did you use a .zip and unzip with Winzip? (I'm assuming yes)

Next, remove all the tables in the database, and delete all G2 files, including your g2data directory.

Unzip the archive using something other than winzip, and run the installation. Make sure when you finish there are tables in the database (~39, I don't remember)

Now try using your gallery.
 
Skansberget

Joined: 2003-09-25
Posts: 27
Posted: Mon, 2005-02-21 18:05

I think i have the same problem.

I do NOT use winzip. I use winrar.

Here is the long code.

Stack Trace:

in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line  1124 
(MySqlDatabaseStorage::error) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryStorage.class at line 220
(MySqlDatabaseStorage::search) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\Gallery.class at line 189 
(GalleryStorage::search) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 256 
(Gallery::search) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 197 
(CoreModule::fetchAllParameters) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 344 
(CoreModule::getParameter) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryCoreApi.class at line 263
(CoreModule::fetchPluginStatus) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryPlugin.class at line 136
(CoreModule::fetchPluginStatus) 
in C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryModule.class at line 275
(CoreModule::activate) 
in C:\Program\Apache2\htdocs\gallery2\install\steps\InstallCoreModuleStep.class at line 90
(CoreModule::activate) 
in C:\Program\Apache2\htdocs\gallery2\install\index.php at line 168
(InstallCoreModuleStep::loadTemplateData)

Debug Output:

.............................
.
.
-----

fopen(C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryStorage/../../../../modules
/core/classes/GalleryStorage/DatabaseStorage/schema
/platform/mysql/GalleryPluginParameterMap.sql,
r, 0)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
fgets(Resource id #80, 4096)
feof(Resource id #80)
mysql error: [1071: Specified key was too long; max key length is 1000
bytes] in EXECUTE("-- This file was automatically generated from an XSL
template, which is
    -- why it looks so ugly.  Editing it by hand would be a bad idea.
    --

    CREATE TABLE g2_PluginParameterMap (
  g_pluginType
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      ,
    g_pluginId
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      ,
    g_itemId
      int(11)
    
    NOT NULL
  
      ,
    g_parameterName
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      ,
    g_parameterValue
      varchar(
      
          255
        
      )
    
    NOT NULL
  
    , 
  
      UNIQUE KEY (g_pluginType
        ,
      g_pluginId
        ,
      g_itemId
        ,
      g_parameterName)
    
    , 
  
    INDEX (g_pluginType
      ,
    g_pluginId
      ,
    g_itemId)
    
      ,
    
    INDEX (g_pluginType)
    

    ) TYPE=MyISAM")

-----
(mysql): -- This file was automatically generated from an XSL template, 
which is
    -- why it looks so ugly.  Editing it by hand would be a bad idea.
    --

    CREATE TABLE g2_PluginParameterMap (
  g_pluginType
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      , 
    g_pluginId
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      , 
    g_itemId
      int(11)
    
    NOT NULL
  
      , 
    g_parameterName
      varchar(
      
          128
        
      )
    
    NOT NULL
  
      , 
    g_parameterValue
      varchar(
      
          255
        
      )
    
    NOT NULL
  
    ,  
  
      UNIQUE KEY (g_pluginType
        , 
      g_pluginId
        , 
      g_itemId
        , 
      g_parameterName)
    
    ,  
  
    INDEX (g_pluginType
      , 
    g_pluginId
      , 
    g_itemId)
    
      , 
    
    INDEX (g_pluginType)
    

    ) TYPE=MyISAM
-----
1071: Specified key was too long; max key length is 1000 bytes
               ADODB_mysql._Execute(-- This file was
automatically generated from an XSL template, w..., false) % line  833, file: adodb.inc.php
            ADODB_mysql.Execute(-- This file was automatically generated
from an XSL template, w...) % line
1649, file: DatabaseStorage.class
         MySqlDatabaseStorage._executeSqlFile(C:\Program\Apache2\htdocs\gallery2\modules\core\classes\GalleryS...) % line 1469, file: DatabaseStorage.class
      MySqlDatabaseStorage.configureStore(core) % line  338, file: GalleryStorage.class
   GalleryStorage.configureStore(core) % line  132, file: GalleryModule.class

realpath(C:\Program\Apache2\htdocs\gallery2\modules\core\classes/../../../)
-----
(mysql): 
                SELECT
                  g2_FactoryMap.g_classType, 
                  g2_FactoryMap.g_className, 
                  g2_FactoryMap.g_implId, 
                  g2_FactoryMap.g_implPath, 
                  g2_FactoryMap.g_hints
                FROM
                  g2_FactoryMap
                ORDER BY
                  g2_FactoryMap.g_orderWeight ASC
                
-----

-----
(mysql): 
            SELECT
              g2_PluginMap.g_pluginId, 
              g2_PluginMap.g_active
            FROM
              g2_PluginMap
            WHERE
              g2_PluginMap.g_pluginType = 'module'
            
-----

opendir(C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers/../../../../modules/)
readdir(Resource id #84)
readdir(Resource id #84)
readdir(Resource id #84)
is_dir(C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers/../../../../modules/albumselect)
file_exists(C:\Program\Apache2\htdocs\gallery2\modules\core\classes\helpers/../../../../modules/albumselect/module.inc)
mysql error: [1146: Table 'gallery2.g2_pluginparametermap' doesn't exist]
in EXECUTE("
                  SELECT
                    g2_PluginParameterMap.g_parameterName,
                    g2_PluginParameterMap.g_parameterValue
                  FROM
                    g2_PluginParameterMap
                  WHERE
                    g2_PluginParameterMap.g_pluginType = 'module'
                    AND
                    g2_PluginParameterMap.g_pluginId = 'albumselect'
                    AND
                    g2_PluginParameterMap.g_itemId = 0
                  ")

-----
(mysql): 
                  SELECT
                    g2_PluginParameterMap.g_parameterName, 
                    g2_PluginParameterMap.g_parameterValue
                  FROM
                    g2_PluginParameterMap
                  WHERE
                    g2_PluginParameterMap.g_pluginType = 'module'
                    AND
                    g2_PluginParameterMap.g_pluginId = 'albumselect'
                    AND
                    g2_PluginParameterMap.g_itemId = 0
                  
-----
1146: Table 'gallery2.g2_pluginparametermap' doesn't exist
                     
        ADODB_mysql._Execute(
                  SELECT
                    g2_PluginParameter...) % line  818, file: adodb.inc.php
                          
ADODB_mysql.Execute(
                  SELECT
                    g2_PluginParameter..., Array[3]) % line 1116, file: DatabaseStorage.class
                        MySqlDatabaseStorage.search(
                  SELECT
                    [GalleryPluginPara..., Array[3], Array[0]) % line  220, file: GalleryStorage.class
                     GalleryStorage.search(
                  SELECT
                    [GalleryPluginPara..., Array[3], Array[0]) % line  189, file: Gallery.class
                  Gallery.search(
                  SELECT
                    [GalleryPluginPara..., Array[3]) % line  256, file: GalleryPluginHelper_simple.class

realpath(C:\Program\Apache2\htdocs\gallery2\modules\core\classes/../../../)
-----
(mysql): 
                SELECT
                  g2_FactoryMap.g_classType, 
                  g2_FactoryMap.g_className, 
                  g2_FactoryMap.g_implId, 
                  g2_FactoryMap.g_implPath, 
                  g2_FactoryMap.g_hints
                FROM
                  g2_FactoryMap
                ORDER BY
                  g2_FactoryMap.g_orderWeight ASC
                
-----
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Mon, 2005-02-21 18:17

change charset of your database to not be utf-8
 
Skansberget

Joined: 2003-09-25
Posts: 27
Posted: Mon, 2005-02-21 19:05
mindless wrote:
change charset of your database to not be utf-8

Thank you very much. Now it's up and running.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2005-02-21 19:09

mindless, why can't we check for this incompatibility in the installer?
 
moogleii

Joined: 2004-01-26
Posts: 20
Posted: Tue, 2005-02-22 02:59

whoops sorry thought i turned on notification by email.

Looks like mindless answered it tho, i do have utf-8 enabled. Thanks for the help!
:D
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Tue, 2005-02-22 03:02

valiant, maybe we can but someone has to write it.
the install usually fails in this condition of course.. i don't know how moogleii reached main.php