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!
Posts: 32509
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
Posts: 5
I have over 45 albums and about 2,000 items. I'd like to try to fix the problem first.
Posts: 32509
when did the error occur first? after an upgrade? what was the previous version?
--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 5
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?
Posts: 32509
> 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