My hosting company switched to 5.3.16. My Gallery2 software stopped working after the upgrade, so I followed the upgrade path of copying all the files over (making a backup of the old directories and the SQL DB first) and going to the site URL and running the installation/upgrade.
All seemed OK, only one error of not being able to upgrade the Notification plugin- figured no big deal. However, when I open the site (http://www.funreviews.net/gallery2/main.php) under Firefox I get the following- any suggestions? (many thanks in advance!!!!):
UPDATE: enabled debug mode and this is at the end now:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 40961 bytes) in /home/funre0/public_html/gallery2/g2data/smarty/templates_c/%%4101765948/matrix/%%A5^A5B^A5BC82F5%%debug.tpl.php on line 7
An error has occurred while interacting with the database.
The exact nature of database errors is not captured unless Gallery debug mode is enabled in config.php. Before seeking support for this error please enable buffered debug output and retry the operation. Look near the bottom of the lengthy debug output to find error details.
Back to the Gallery
Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage.class at line 495 (GalleryCoreApi::error)
in modules/core/classes/Gallery.class at line 209 (GalleryStorage::search)
in modules/comment/classes/GalleryCommentHelper.class at line 273 (Gallery::search)
in modules/comment/module.inc at line 292 (GalleryCommentHelper::fetchCommentCounts)
in modules/core/classes/GalleryTheme.class at line 1563 (CommentModule::getItemSummaries)
in themes/matrix/theme.inc at line 65 (GalleryTheme::loadCommonTemplateData)
in modules/core/classes/GalleryTheme.class at line 932 (MatrixTheme::showAlbumPage)
in modules/core/classes/GalleryView.class at line 301 (GalleryTheme::loadTemplate)
in main.php at line 465 (GalleryView::doLoadTemplate)
in main.php at line 104
in main.php at line 88
System Information
Gallery version 2.3.2
PHP version 5.3.16 cgi-fcgi
Webserver Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.5
Database mysqli 5.1.62-cll
Toolkits ImageMagick, Gd
Operating system Linux skylark.lunarbreeze.com 2.6.9-89.0.19.ELsmp #1 SMP Fri Jan 8 06:32:22 EST 2010 i686
Browser Mozilla/5.0 (Windows NT 6.1; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0
Posts: 8339
Do you have the PHP mysqli extension loaded?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
<shrug> how would I tell? I cannot get into the dang thing via admin panel. This all worked fine until upgraded prompted because of the PHP upgrade from my hosting company. :/
Posts: 8339
create a phpInfo and post the link to it.
FAQ: What information is required when I ask for help in the forums?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
Thanks.
http://funreviews.net/phpinfo.php
Posts: 8339
Hmmm. extension is there.
Can you perform a clean install in an adjacent directory w/ a new DB and see if all functions ok?
http://codex.galleryproject.org/Gallery2:How_do_I_Install_Gallery2#Installing_Gallery_2_2
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
So, I'm finally back to working on this. :P I reinstalled it fresh into a new directory and it installs. I edit the config.php file to point to the old database and it lets me log in, but none of the pictures show up, even if I upload them to the proper directory. I'm thinking the application is looking for it in the old /gallery2 directory instead of new /gallery?
Anyway, went to 'clear cache' on the database and it all blew up again. So, I'm going through the reinstall using the old database and telling it to keep all the table data and when it gets to the Install Plugins part I get this:
Unable to load the notification module
Error (ERROR_PLUGIN_VERSION_MISMATCH) : [notification] db: (v: 0.9.0 core api: 7/10, module api: 3/1) code: (v: 1.0.3 core api: 7/54, module api: 3/9)
in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 178 (GalleryCoreApi::error)
in modules/core/classes/GalleryCoreApi.class at line 273 (GalleryPluginHelper_simple::loadPlugin)
in install/steps/InstallOtherModulesStep.class at line 161 (GalleryCoreApi::loadPlugin)
in install/index.php at line 170 (InstallOtherModulesStep::loadTemplateData)
Now it's making a little sense based on the error I put on the first post at the top of this thread, some of the errors are jiving, but how do I get the proper plugins installed if the installer is putting the wrong ones in?
Thanks in advance,
-g
Posts: 8339
copy new gallery files to your new gallery directory. make sure you have all the same plugins present
copy the config file from old -> new
run the gallery upgrader not the installer
yoursite.com/path to new gallery/upgrade/
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
How do I make sure the same 'plugins are present'? I have the old directory backed up, do I copy a directory from the old install to a directory in the new install?
Thanks!
-gw
Posts: 8339
make sure any plugins/modules you had active in the original installation (gallery2/modules) are in the new codebase.
if there is no new version of these plugins/modules copy the old -> new. Some user contributed module may never have been updated.
Also any theme you had active in the old installation will also need to be present.
Your old G2 database will have these set as active and will be expecting them to be present.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
Cool, Thanks! I'm assuming that before I run the 'upgrade' I move all the folders/files from /gallery2/g2data/albums over to the new directory, too?
Posts: 8339
when you copy the config file from old to new, it should have the full system path to the g2data directory it was using.
You should read through it to make sure all info is correct. And if you want to move g2data, just update config to point to the proper place.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
So, my old install was /gallery2, the new is /gallery. After the upgrade installation in /gallery, I'll run Gallery2 from /gallery, but it'll pull the images from /gallery2?
Posts: 19
OK, so I went through what you recommended with the plugins and during the upgrade installation I get the following and it appears to stop the upgrade: :/
Unable to upgrade the Notification module
Upgrade Plugins
Stack Trace:
Error (ERROR_MISSING_VALUE) : Undefined map: NotificationSubscriptions
in modules/core/classes/GalleryStorage.class at line 1257 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 1249 (GalleryStorage::describeMap)
in modules/core/classes/GalleryStorage.class at line 572 (GalleryStorage::describeMap)
in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry)
in modules/notification/module.inc at line 269 (GalleryCoreApi::getMapEntry)
in modules/core/classes/GalleryModule.class at line 175 (NotificationModule::upgrade)
in upgrade/steps/UpgradeOtherModulesStep.class at line 77 (GalleryModule::installOrUpgrade)
in upgrade/index.php at line 186 (UpgradeOtherModulesStep::processRequest)
Posts: 19
If I skip the Notification Module upgrade I get the following:
Database Error
An error has occurred while interacting with the database.
The exact nature of database errors is not captured unless Gallery debug mode is enabled in config.php. Before seeking support for this error please enable buffered debug output and retry the operation. Look near the bottom of the lengthy debug output to find error details.
Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage.class at line 495 (GalleryCoreApi::error)
in modules/core/classes/Gallery.class at line 209 (GalleryStorage::search)
in modules/comment/classes/GalleryCommentHelper.class at line 273 (Gallery::search)
in modules/comment/module.inc at line 292 (GalleryCommentHelper::fetchCommentCounts)
in modules/core/classes/GalleryTheme.class at line 1563 (CommentModule::getItemSummaries)
in themes/matrix/theme.inc at line 65 (GalleryTheme::loadCommonTemplateData)
in modules/core/classes/GalleryTheme.class at line 932 (MatrixTheme::showAlbumPage)
in modules/core/classes/GalleryView.class at line 301 (GalleryTheme::loadTemplate)
in main.php at line 465 (GalleryView::doLoadTemplate)
in main.php at line 104
in main.php at line 88
System Information
Gallery version 2.3.2
PHP version 5.2.17 cgi
Webserver Apache/2.2.24 (Unix) mod_ssl/2.2.24 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.6
Database mysqli 5.5.30-cll
Toolkits ImageMagick, Gd
Operating system Linux servername.server.com 2.6.9-89.0.19.ELsmp #1 SMP Fri Jan 8 06:32:22 EST 2010 i686
Browser Mozilla/5.0 (Windows NT 6.1; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0
Posts: 8339
first lets make sure we disable the notification module.
execute this query on your G2 database using phpMyAdmin or similar tool:
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='notification';
it also looks like maybe comments is having issues, so lets disable that as well:
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='comment';
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
suprsidr- I really appreciate all your help. This is getting frustrating. :/ To make sure the problem wasn't a partially upgraded database, I dropped the tables and imported the original database. Then I dropped your queries above. I then got an error it had trouble disabling two themes, OpticalPork and Fluid- so I did the same as you did above and re-ran the upgrade from the previous step, it no longer had an issue with those themes. Then when it went to upgrade the plugins, it couldn't update quite a few of them, but did some including 'core'. However, now, at the end of the upgrade, when I go to the main.php page it just says "an error has occured".
Should I disable all the plugins via the query method that are an issue and retry? At least some or all of them could have been ones I added. Could they be preventing Gallery2 from running properly?
Thanks again,
-g
Posts: 8339
put your gallery in debug mode.
Copy the output to a txt file and attach it to this thread.
FAQ: How to set/use Gallery in debug mode?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
Thanks again, suprsidr. I had to open it in Wordpad, otherwise there was no spaces, linefeeds, anything. :/
Posts: 8339
http://galleryproject.org/node/88038#comment-309349
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
I went to the link and ran the query for the first insert and got this:
#1062 - Duplicate entry 'CacheMap' for key 'PRIMARY'
Second insert line insert I get this:
#1062 - Duplicate entry 'PluginPackageMap' for key 'PRIMARY'
Third insert line I get this:
#1062 - Duplicate entry 'SessionMap' for key 'PRIMARY'
Help. :/ Thanks!
Posts: 19
I dropped the database and reimported the backup I made before I started all this.
When I run the insert queries I get this now:
#1136 - Column count doesn't match value count at row 1
Thanks!
-gw
Posts: 8339
did you run the upgrader again first?
This was the only one of the three inserts that your debug.txt above required.
Why 8 months between posts?
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 19
Because I got totally frustrated with this and gave up on it for a while. I'm really close to calling it quits. I really appreciate your efforts, though.