Error after upgrade

Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-06-23 16:18

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-06-23 18:15
Quote:
mysqli error: [0: Missing extension for native] in CONNECT(localhost, ?, ?,
funre0_gallery2)

Do you have the PHP mysqli extension loaded?

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-06-23 22:17

<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. :/

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-06-23 23:22

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-06-23 23:30
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-06-23 23:41

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 08:00

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-07-21 13:39

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 14:38

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-07-21 14:46

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 18:47

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?

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-07-21 19:11

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 19:32

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?

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 19:48

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)

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 19:51

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2013-07-21 22:10

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Sun, 2013-07-21 23:24

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2013-07-22 01:04

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Mon, 2013-07-22 01:48

Thanks again, suprsidr. I had to open it in Wordpad, otherwise there was no spaces, linefeeds, anything. :/

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2013-07-22 02:31
 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Mon, 2014-03-17 16:44

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!

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Mon, 2014-03-17 17:09

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

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2014-03-17 17:17

did you run the upgrader again first?

Quote:
Third insert line I get this:
#1062 - Duplicate entry 'SessionMap' for key 'PRIMARY'

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

 
Jeepix

Joined: 2010-05-01
Posts: 19
Posted: Thu, 2014-03-20 08:36
Quote:
Why 8 months between posts?

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.