2.1.2 upgrade problems (g2 did not upgrade correctly)

insanetional

Joined: 2007-04-05
Posts: 5
Posted: Fri, 2007-04-06 06:18


Gallery version: 2.1.2 (attempting to upgrade to that)
PHP version: 4.4.6
PHPInfo Link: joshyeh.com/gallery/phpinfo.php
Webserver: Apache 1.3.37 (Unix)
Database: 4.1.21-standard-log
Operating system: Linux

I posted this error earlier and Valiant told me that my g2 did not upgrade correctly.

This is the error that was found in the debug output: mysql error: [1054: Unknown column 'g2_AccessMap.g_userOrGroupId' in 'where clause'] in EXECUTE

Click here for the debug output.

(I guess Fantastico wasn't that fantastic.)

Please help. What should I do?

This is the error message when the page is accessed:

An error has occurred while interacting with the database.

Back to the Gallery

Error Detail -
Error (ERROR_STORAGE_FAILURE) :
in modules/core/classes/GalleryStorage.class at line 476 (gallerycoreapi::error)
in modules/core/classes/Gallery.class at line 223 (mysqlstorage::search)
in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 97 (gallery::search)
in modules/core/classes/GalleryCoreApi.class at line 445 (gallerypermissionhelper_simple::fetchaccesslistids)
in modules/core/classes/helpers/GalleryUserHelper_simple.class at line 88 (gallerycoreapi::fetchaccesslistids)
in modules/core/classes/helpers/GalleryUserHelper_simple.class at line 51 (galleryuserhelper_simple::hasitempermission)
in modules/core/classes/GalleryCoreApi.class at line 495 (galleryuserhelper_simple::asserthasitempermission)
in modules/core/ShowItem.inc at line 76 (gallerycoreapi::asserthasitempermission)
in modules/core/classes/GalleryView.class at line 317 (showitemview::loadtemplate)
in main.php at line 386 (showitemview::doloadtemplate)
in main.php at line 87
in main.php at line 80

Thanks in advance!
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2007-04-06 17:06

can you reinstall gallery or did you already add a lot of items / albums (/ invest a lot of time)?

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
insanetional

Joined: 2007-04-05
Posts: 5
Posted: Fri, 2007-04-06 17:59

I have over 45 albums and about 2,000 items. I'd like to try to fix the problem first.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2007-04-06 18:17

when did the error occur first? after an upgrade? what was the previous version?

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
insanetional

Joined: 2007-04-05
Posts: 5
Posted: Fri, 2007-04-06 19:20

This is what happened: I had Fantastico do part of the upgrade from, I believe, 2.0.1. After it finished it said I needed to use the wizard to finish the upgrade. During the System Check there was an error (ERROR_STORAGE_FAILURE) and I found out my "versions.dat" was missing, so I followed the FAQ instructions and replaced it. The wizard continued, but during the Modules Upgrade, the Cart and Shutterfly modules didn't upgrade correctly. It still proceeded and finished. Then when I tried to open my gallery that's where I first saw the error.

Would I be able to go back to my previous installation?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2007-04-06 19:29

> Would I be able to go back to my previous installation?

only if you have a complete backup:
http://codex.gallery2.org/Gallery2:How_To_Restore_From_Backup

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage