Problems upgrading from Gallery2 2.2 to 2.4

caineone

Joined: 2008-05-17
Posts: 1
Posted: Sat, 2008-05-17 21:20

I want to upgrade the core files and it fails at step 3.
Please help, what could I do bring my site back online?!


Gallery version (not just "2"): 2.2.2
PHP version (e.g. 5.1.6):5.2.0-8+etch10 apache2handler
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):Apache
Database (e.g. MySql 5.0.32): mysql 5.0.32-Debian_7etch5-log
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux):Linux 2.6.9-023stab043.1-enterprise #1 SMP Mon Mar 5 16:58:09 MSK 2007 i686
Browser (e.g. Firefox 2.0):Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9pre)Gecko/2008051606 Minefield/3.0pre

The upgrade fails with a Database Error:

Quote:
1054: Unknown column 'g_createSql' in 'field list'

This is the Stack Trace:

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 953 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage.class at line 493 (GalleryStorageExtras::execute)
* in modules/core/CoreModuleExtras.inc at line 2176 (GalleryStorage::execute)
* in modules/core/module.inc at line 433 (CoreModuleExtras::upgrade)
* in modules/core/classes/GalleryModule.class at line 159 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 85 (GalleryModule::installOrUpgrade)
* in upgrade/index.php at line 185 (UpgradeCoreModuleStep::processRequest)

And this the last part of the error report:

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

realpath(/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/core/classes/../../..)
Binding text domain: modules_core ->
/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/core/locale
file_exists(/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/comment/classes/GalleryStorage/schema.tpl)
file(/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/comment/classes/GalleryStorage/schema.tpl,
)
mysql error: [1054: Unknown column 'g_createSql' in 'field list'] in
EXECUTE("UPDATE g2_Schema SET g_createSql = 'CREATE TABLE
DB_TABLE_PREFIXComment(\n DB_COLUMN_PREFIXid int(11) NOT NULL,\n
DB_COLUMN_PREFIXcommenterId int(11) NOT NULL,\n DB_COLUMN_PREFIXhost
varchar(128) NOT NULL,\n DB_COLUMN_PREFIXsubject varchar(128),\n
DB_COLUMN_PREFIXcomment text,\n DB_COLUMN_PREFIXdate int(11) NOT NULL,\n
DB_COLUMN_PREFIXauthor varchar(128),\n PRIMARY KEY(DB_COLUMN_PREFIXid),\n
INDEX DB_TABLE_PREFIXComment_95610(DB_COLUMN_PREFIXdate)\n)
DB_TABLE_TYPE\n/*!40100 DEFAULT CHARACTER SET utf8 */;\n\nINSERT INTO
DB_TABLE_PREFIXSchema (\n DB_COLUMN_PREFIXname,\n DB_COLUMN_PREFIXmajor,\n
DB_COLUMN_PREFIXminor\n) VALUES(\'Comment\', 1, 2);\n\n' WHERE g_name =
'Comment'")

(mysql): UPDATE g2_Schema SET g_createSql = 'CREATE TABLE
DB_TABLE_PREFIXComment(\n DB_COLUMN_PREFIXid int(11) NOT NULL,\n
DB_COLUMN_PREFIXcommenterId int(11) NOT NULL,\n DB_COLUMN_PREFIXhost
varchar(128) NOT NULL,\n DB_COLUMN_PREFIXsubject varchar(128),\n
DB_COLUMN_PREFIXcomment text,\n DB_COLUMN_PREFIXdate int(11) NOT NULL,\n
DB_COLUMN_PREFIXauthor varchar(128),\n PRIMARY KEY(DB_COLUMN_PREFIXid),\n
INDEX DB_TABLE_PREFIXComment_95610(DB_COLUMN_PREFIXdate)\n)
DB_TABLE_TYPE\n/*!40100 DEFAULT CHARACTER SET utf8 */;\n\nINSERT INTO
DB_TABLE_PREFIXSchema (\n DB_COLUMN_PREFIXname,\n DB_COLUMN_PREFIXmajor,\n
DB_COLUMN_PREFIXminor\n) VALUES(\'Comment\', 1, 2);\n\n' WHERE g_name =
'Comment'

1054: Unknown column 'g_createSql' in 'field list'

ADOConnection._Execute(UPDATE g2_Schema SET
g_createSql = 'CREATE TABLE DB_TABLE_PREFIXComment(\n DB_COLUMN_PREFIXid
int(11) NOT NULL,\n DB_COLUMN_PREF...) %
line 870, file: adodb.inc.php
ADOConnection.Execute(UPDATE g2_Schema SET g_createSql = ?
WHERE g_name = ?, Array[2]) % line 946,
file: GalleryStorageExtras.class
GalleryStorageExtras.execute(UPDATE [GallerySchema] SET
[::createSql] = ? WHERE [::name] = ?, Array[2]) % line 493, file: GalleryStorage.class
GalleryStorage.execute(UPDATE [GallerySchema] SET
[::createSql] = ? WHERE [::name] = ?, Array[2]) % line 2176, file: CoreModuleExtras.inc
CoreModuleExtras.upgrade(Object:CoreModule, null,
Object:StatusTemplate) % line 433,
file: module.inc

realpath(/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/core/classes/../../../)
realpath(/var/www/vhosts/ms-dd.net/httpdocs/gallery/)
Error: Failed to upgrade the core module, this is the error stack trace:
Error (ERROR_STORAGE_FAILURE)in
modules/core/classes/GalleryStorage/GalleryStorageExtras.class at
line 953 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 493
(GalleryStorageExtras::execute)
in modules/core/CoreModuleExtras.inc at line 2176
(GalleryStorage::execute)
in modules/core/module.inc at line 433
(CoreModuleExtras::upgrade)
in modules/core/classes/GalleryModule.class at line 159
(CoreModule::upgrade)
in upgrade/steps/UpgradeCoreModuleStep.class at line 85
(GalleryModule::installOrUpgrade)
in upgrade/index.php at line 185
(UpgradeCoreModuleStep::processRequest)

realpath(/var/www/vhosts/ms-dd.net/httpdocs/gallery/modules/core/classes/../../../)
realpath(/var/www/vhosts/ms-dd.net/httpdocs/gallery/)
Login or register to post comments