[SOLVED] Upgrade error: beta 1 -> beta 2

grokus

Joined: 2005-05-10
Posts: 6
Posted: Tue, 2005-05-10 14:00

Please help with these errors, thanks.

Quote:
file_exists(e:\data\g2data\/cache/entity)
file_exists(e:\data\g2data\/cache/layout)
file_exists(e:\data\g2data\/cache/module)
file_exists(e:\data\g2data\/cache/derivative)

(mysql): SHOW TABLES

file_exists(C:\apache\htdocs\gallery2\modules\core\classes\helpers/../../../../modules/core/module.inc)
file_exists(e:\data\g2data\\versions.dat)
file(e:\data\g2data\\versions.dat, )

P.S. FWIW, it'd be nice if the installation script can remove obsolete files automatically. It's too painful to remove 100+ files manually.

----

Gallery URL (optional):
Gallery version: beta 2
Webserver (with version): apache 2.0.50
Datatabase (with version): mySQL 3.23.55
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s): ImageMagick
Operating system: Windows 2003 Server
Web browser/version: FireFox 1.0.3
G1 version (for migration bugs):
 
grokus

Joined: 2005-05-10
Posts: 6
Posted: Tue, 2005-05-10 19:59

Tried this again and I'm seeing new errors. Any suggestion would be greatly appreciated.

An error ocurred while upgrading Gallery Core Module

Stack Trace:

Quote:
Error (ERROR_STORAGE_FAILURE) : Error trying to load C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Copy of GalleryItemPropertiesMap.sql

* in C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1734 (gallerystatus::error)
* in C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1538 (mysqldatabasestorage::_executesqlfile)
* in C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage.class at line 338 (mysqldatabasestorage::configurestore)
* in C:\apache\htdocs\gallery2\modules\core\classes\GalleryModule.class at line 132 (gallerystorage::configurestore)
* in C:\apache\htdocs\gallery2\upgrade\steps\UpgradeCoreModuleStep.class at line 72 (coremodule::installorupgrade)
* in C:\apache\htdocs\gallery2\upgrade\index.php at line 152 (upgradecoremodulestep::processrequest)

Debug Output:

Quote:
(mysql): SHOW TABLES

file_exists(e:\data\g2data\\versions.dat)
file(e:\data\g2data\\versions.dat, )
file_exists(C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
opendir(C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
readdir(Resource id #46)
closedir(Resource id #46)

(mysql): SHOW TABLES

(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema

fopen(C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/Copy
of GalleryItemPropertiesMap.sql, r, 0)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fgets(Resource id #49, 4096)
feof(Resource id #49)
fclose(Resource id #49)
mysql error: [1050: Table 'g2_itempropertiesmap' already exists] 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_ItemPropertiesMap (
g_itemId
int(11)

NOT NULL

,
g_key
varchar(

128

)

NOT NULL

,
g_value
text

) 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_ItemPropertiesMap (
g_itemId
int(11)

NOT NULL

,
g_key
varchar(

128

)

NOT NULL

,
g_value
text

) TYPE=MyISAM

1050: Table 'g2_itempropertiesmap' already exists

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
1730, file: DatabaseStorage.class
mysqldatabasestorage._executesqlfile(C:\apache\htdocs\gallery2\modules\core\classes\GalleryStorage/.....) % line 1538, file: DatabaseStorage.class
mysqldatabasestorage.configurestore(core) % line 338, file: GalleryStorage.class
gallerystorage.configurestore(core) % line 132, file: GalleryModule.class

realpath(C:\apache\htdocs\gallery2\modules\core\classes/../../../)

 
grokus

Joined: 2005-05-10
Posts: 6
Posted: Tue, 2005-05-10 21:32

I deleted my gallery2 directory and "tar xvf" again, but got the original errors again. I guess that I have to revert back to beta 1 if I can't figure this out.

Quote:
file_exists(e:\data\g2data\/cache/entity)
file_exists(e:\data\g2data\/cache/layout)
file_exists(e:\data\g2data\/cache/module)
file_exists(e:\data\g2data\/cache/derivative)

(mysql): SHOW TABLES

file_exists(C:\apache\htdocs\gallery2\modules\core\classes\helpers/../../../../modules/core/module.inc)
file_exists(e:\data\g2data\\versions.dat)
file(e:\data\g2data\\versions.dat, )
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Tue, 2005-05-10 21:33

save your config.php, remove/move away your gallery2 codebase, extract a current nightly snapshot, put config.php in place, then try the upgrade again. let us know how it goes..
 
grokus

Joined: 2005-05-10
Posts: 6
Posted: Tue, 2005-05-10 22:16

Much better this time. Thanks!