[SOLVED] Stage 7 (core) failure

sargonas

Joined: 2005-01-20
Posts: 4
Posted: Thu, 2005-01-20 17:38

I am getting the following error when installing gallery2. So far I have tried the alpha4 on the site, the 1-05-05 snapshot, and the latest nightly snapshot of 1-19-05 at 3am when i last tried to work on this yesterday evening. EVERYtime i get the following error. Each install attempt (several per revision) i work with a fresh clean directory, and a fresh clean database each time for peace of mind.

Error (ERROR_STORAGE_FAILURE) : 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 735 (gallerystatus::error) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage.class at line 220 (mysqldatabasestorage::search) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\Gallery.class at line 184 (gallerystorage::search) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 234 (gallery::search) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 175 (gallerypluginhelper_simple::fetchallparameters) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryCoreApi.class at line 203 (gallerypluginhelper_simple::getparameter) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\Gallery.class at line 468 (gallerycoreapi::getpluginparameter) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\Gallery.class at line 440 (gallery::getactivelanguagecode) 
in D:\HTML\gallery2.sargonas.com\gallery2\init.php at line 138 (gallery::inittranslator) 
in D:\HTML\gallery2.sargonas.com\gallery2\main.php at line 32

----

Gallery URL (optional):http://gallery2.sargonas.com/gallery2
Gallery version:1-19-05 3:33am snapshot
Webserver (with version): IIS5 on Win 2k
Datatabase (with version): MySQL 4.1.8 for windows
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s): imagemagik
Operating system: Windows 2k
Web browser/version: IE 6 and Firefox
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-01-20 19:53

look near the bottom of the debug output and post the database error here.
the subject implies this error is in the installer.. why is the stack trace for main.php?
 
sargonas

Joined: 2005-01-20
Posts: 4
Posted: Thu, 2005-01-20 19:58

rgr let me grab the nice long debug info, ill have to run though it all again to re-gen that.. do you want it all, or just that bit of info?
 
sargonas

Joined: 2005-01-20
Posts: 4
Posted: Thu, 2005-01-20 20:08

here is the stack trace:

Error (ERROR_STORAGE_FAILURE) : Error trying to load D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryPluginParameterMap.sql
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1258 (gallerystatus::error) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1075 (mysqldatabasestorage::_executesqlfile) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryStorage.class at line 338 (mysqldatabasestorage::configurestore) 
in D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\GalleryModule.class at line 154 (gallerystorage::configurestore) 
in D:\HTML\gallery2.sargonas.com\gallery2\install\steps\InstallCoreModuleStep.class at line 84 (coremodule::installorupgrade) 
in D:\HTML\gallery2.sargonas.com\gallery2\install\index.php at line 160 (installcoremodulestep::loadtemplatedata)

and here is the debug output info

wait a minute!! while looking at the VERY end of the debug i see this..

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(D:\HTML\gallery2.sargonas.com\gallery2\modules\core\classes\Gall...) % line 1075, file: DatabaseStorage.class
      mysqldatabasestorage.configurestore(core) % line  338, file: GalleryStorage.class
   gallerystorage.configurestore(core) % line  154, file: GalleryModule.class

realpath(D:\HTML\gallery2.sargonas.com\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

i never noticed this before but
1071: Specified key was too long; max key length is 1000 bytes
makes sense to me, since key fields after it are red... would that be the issue?
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-01-20 20:57

you need to change your database character set.. search the forums for the 1000 bytes error for more info.
 
sargonas

Joined: 2005-01-20
Posts: 4
Posted: Thu, 2005-01-20 22:55

yeah when the db was made in phpmyadmin the collation box was left unselected so ut ued whatever the default was.. i changed it following some suggestions in other threads, and im good to go now! thanks!