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
Posts: 8601
to do a clean install you must empty or recreate the database as well as clearing the g2data directory.
Posts: 5
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.
Posts: 3236
I've NEVER had to re-do the user perms, just drop and re-add the db and rm -Rf /g2data/*
Posts: 2
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.
Posts: 3236
you should be able to just do a drop / create mysql command, two lines instead of killing the db on the file system.