CVS (as of 2005/05/01) fails upgrading/installing Core mod

Tufqi

Joined: 2005-01-05
Posts: 2
Posted: Wed, 2005-01-05 20:42

Hello,
Trying a fresh install (Database and g2data directory wiped out) of the latest Gallery 2 CVS
fails during 7th step of the installer.

Everything is running fine going thru the steps of the installer, then I get:

Error (ERROR_STORAGE_FAILURE) : Error trying to load /home/tufqi/tmp/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Schema.sql

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1258 (gallerystatus::error)
    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1040 (mysqldatabasestorage::_executesqlfile)
    * in modules/core/classes/GalleryStorage.class at line 338 (mysqldatabasestorage::configurestore)
    * in modules/core/classes/GalleryModule.class at line 163 (gallerystorage::configurestore)
    * in install/steps/InstallCoreModuleStep.class at line 84 (coremodule::installorupgrade)
    * in install/index.php at line 160 (installcoremodulestep::loadtemplatedata) 

I have the full debug output handy if it helps, though the revelant part is, I guess:

mysql error: [1062: Duplicate entry 'Schema' for key 1] in EXECUTE("INSERT
INTO g2_Schema (
      g_name,
      g_major,
      g_minor
      ) VALUES (
      'Schema',
      1,
      0
      )")

Hope it helps, I'm a fellow G2 user and I can't wait testing the latest features :)

----

Gallery URL (optional):
Gallery version: CVS 2005/01/05
Webserver (with version): Apache 1.3.33 (Debian package)
Datatabase (with version): MySQL 4.1.7
PHP version (eg 4.2.1): 4.3.10 (apache module)
phpinfo URL (optional):
Graphics Toolkit(s): NetPBM, ImageMagick, GD2
Operating system: Linux 2.6
Web browser/version: Firefox 1.0

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Wed, 2005-01-05 22:15

to do a clean install you must empty or recreate the database as well as clearing the g2data directory.

 
cmcdotcom

Joined: 2004-12-30
Posts: 5
Posted: Thu, 2005-01-06 18:31

I had this similar problem until I redid the GRANT permissions for the gallery user. Try killing the user, and redoing it with GRANT ALL.

 
fryfrog

Joined: 2002-10-30
Posts: 3236
Posted: Fri, 2005-01-07 00:44

I've NEVER had to re-do the user perms, just drop and re-add the db and rm -Rf /g2data/*

 
Tufqi

Joined: 2005-01-05
Posts: 2
Posted: Fri, 2005-01-07 15:13

Hello,

Following up on this one, I re-did everything (wiping the data directory, and the database) and this time it worked.

As I was erasing the DB thru the filesystem, I might have skipped accidentally a "mysqladmin flush-tables" once.

Sorry for the trouble then, works like a charm now.

 
fryfrog

Joined: 2002-10-30
Posts: 3236
Posted: Sat, 2005-01-08 00:47

you should be able to just do a drop / create mysql command, two lines instead of killing the db on the file system.