g2 installation error

nightyy

Joined: 2005-01-25
Posts: 6
Posted: Tue, 2005-01-25 17:25

Hi,
i get this error when installing, this is how it starts:

Stack Trace:
Error (ERROR_STORAGE_FAILURE) : Error trying to load C:\www\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPluginParameterMap.sql

* in C:\www\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1258 (MySqlDatabaseStorage::error)
* in C:\www\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1075 (MySqlDatabaseStorage::_executeSqlFile)
* in C:\www\gallery2\modules\core\classes\GalleryStorage.class at line 338 (MySqlDatabaseStorage::configureStore)
* in C:\www\gallery2\modules\core\classes\GalleryModule.class at line 163 (GalleryStorage::configureStore)
* in C:\www\gallery2\install\steps\InstallCoreModuleStep.class at line 84 (CoreModule::installOrUpgrade)
* in C:\www\gallery2\install\index.php at line 159 (InstallCoreModuleStep::loadTemplateData)

Debug Output:

file_exists(C:\www\gallery2\g2albums\/cache/entity)
file_exists(C:\www\gallery2\g2albums\/cache/layout)
file_exists(C:\www\gallery2\g2albums\/cache/module)
file_exists(C:\www\gallery2\g2albums\/cache/derivative)

(mysql): SHOW TABLES

file_exists(C:\www\gallery2\modules\core\classes\helpers/../../../../modules/core/module.inc)
file_exists(C:\www\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
opendir(C:\www\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
readdir(Resource id #47)
readdir(Resource id #47)
readdir(Resource id #47)
readdir(Resource id #47)
readdir(Resource id #47)

complete debug:
http://www.thestonyroad.com/g2.txt

Thanks,
N!ghtY

----

Gallery URL (optional):
Gallery version: 2-latest (25.01.2005)
Webserver (with version): 2.x
Datatabase (with version): 4.17
PHP version (eg 4.2.1): 4.1.9
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system: win2003 server
Web browser/version:
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-01-25 18:03

@mindless:
the actual error is here:

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(

[...]

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
1254, file: DatabaseStorage.class
         MySqlDatabaseStorage._executeSqlFile(C:\www\gallery2\modules\core\classes\GalleryStorage/../../../../...) % line 1075, file: DatabaseStorage.class
      MySqlDatabaseStorage.configureStore(core) % line  338, file: GalleryStorage.class
   GalleryStorage.configureStore(core) % line  163, file: GalleryModule.class
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Tue, 2005-01-25 19:46

you need to change the character set of your database.. search this forum for more detail.