Upgrade problems from 2.0.1 to 2.0.2

PaulUTK

Joined: 2004-11-05
Posts: 2
Posted: Fri, 2005-12-02 00:19

[ebuild R ] dev-lang/php-5.0.5-r4
[ebuild R ] www-apps/gallery-2.0.2
[ebuild R ] net-www/apache-2.0.55
[ebuild R ] dev-db/mysql-4.1.15-r1

I'm getting an error about a table column with a duplicate name:

ysql error: [1060: Duplicate column name 'g_originationTimestamp'] in
EXECUTE("ALTER TABLE g2_Item
ADD COLUMN g_originationTimestamp
int(11)")

(mysql): ALTER TABLE g2_Item
ADD COLUMN g_originationTimestamp
int(11)

1060: Duplicate column name 'g_originationTimestamp'

ADOConnection._Execute(ALTER TABLE g2_Item
ADD COLUMN g_originationTimestamp
int(11), false) % line 855,
file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE g2_Item
ADD COLUMN g_originationTimestamp
int(11)) % line 1814, file: DatabaseStorage.class
DatabaseStorage._executeSqlFile(/var/www/localhost/htdocs/gallery/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseSt...) % line 1546, file: DatabaseStorage.class
DatabaseStorage.configureStore(core) % line 387, file: GalleryStorage.class
GalleryStorage.configureStore(core) % line 145, file: GalleryModule.class

realpath(/var/www/localhost/htdocs/gallery/modules/core/classes/../../../)
Error: Failed to configure the persistent store, this is the error stack
trace: Error (ERROR_STORAGE_FAILURE) : Error trying to load
/var/www/localhost/htdocs/gallery/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/._cfg0000_A_GalleryItem_1.0.sqlin
modules/core/classes/GalleryStorage/DatabaseStorage.class at line
1818 (GalleryStatus::error)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at
line 1546 (DatabaseStorage::_executeSqlFile)
in modules/core/classes/GalleryStorage.class at line 387
(DatabaseStorage::configureStore)
in modules/core/classes/GalleryModule.class at line 145
(GalleryStorage::configureStore)
in upgrade/steps/UpgradeCoreModuleStep.class at line 79
(GalleryModule::installOrUpgrade)
in upgrade/index.php at line 183
(UpgradeCoreModuleStep::processRequest)

realpath(/var/www/localhost/htdocs/gallery/modules/core/classes/../../../)

And here is the Stack Trace:

Error (ERROR_STORAGE_FAILURE) : Error trying to load /var/www/localhost/htdocs/gallery/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/._cfg0000_A_GalleryItem_1.0.sql

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1818 (GalleryStatus::error)
* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1546 (DatabaseStorage::_executeSqlFile)
* in modules/core/classes/GalleryStorage.class at line 387 (DatabaseStorage::configureStore)
* in modules/core/classes/GalleryModule.class at line 145 (GalleryStorage::configureStore)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 79 (GalleryModule::installOrUpgrade)
* in upgrade/index.php at line 183 (UpgradeCoreModuleStep::processRequest)

Any help would be greatly appreciated.

Thanks,

Paul
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-12-02 00:27

there was no such change between 2.0.1 and 2.0.2 .

FAQ: How can I make sure that my installation files are all intact?
 
PaulUTK

Joined: 2004-11-05
Posts: 2
Posted: Fri, 2005-12-02 00:40

I'm not getting any errors though, it says success on all the steps.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-12-02 02:39

if it was a 2.0.1 -> 2.0.2 upgrade, there shouldn't have been any database changes involved. that doesn't make sense at all.

i hope you have a backup from before the upgrade (since we recommend to do a backup regularely and especially before upgrades), then we could rollback and do it again and first make sure your files are ok and that your prior version was really 2.0.1.
 
vxo

Joined: 2006-01-15
Posts: 1
Posted: Sun, 2006-01-15 11:40

This is all most curious. I just ran into the same problem myself...

For now, I'm still back on 2.0. The files all appear to be ok.

There is another thing in common here, though! At the top of the original post, I spy some gentoo linux emerge output!

I too have installed through emerge.. and run into the same mess.

Might it, at this point, be a better idea to start with a clean install and import my existing albums back into it? This is just getting silly.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2006-01-15 13:57

please check the $this->setVersion('1.0.1'); line in your modules/core/module.inc from your old and from your new gallery2 version/installation.
it should be 1.0.0 for G 2.0 and 1.0.0.2 for G 2.0.2