Gallery down after upgrade attempt to 2.31

sterlingII

Joined: 2010-01-23
Posts: 6
Posted: Sat, 2010-01-23 18:23

Hello,
I've attempted to upgrade from 2.2.5 to 2.3.1 and now receive an HTTP 500 error. I recently upgraded mysql from 4 to 5. Because the new mysql5 is on a different server I had to backup from 4, then restore to 5. After updating config.php the site was functional. I then initiated the upgrade and ran into a 777 issue in step 3 which I corrected after searching the FAQ. I then completed all upgrade steps with no errors other than a warning on step 3 where it said I may have some unused files.

Any help is greatly appreciated. This site's been running Gallery for many years...

I am in debug mode, following is the output:

Quote:
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
Debug Output
file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter language.useBrowserPref for core plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/module/core/0/0/0.inc) getParameter default.language for core plugin controller , view Loading plugin core Class not defined, trying to include it. file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/core/module.inc) core plugin successfully instantiated file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/versions.dat) file(/home/content/c/m/m/cmmtc/html/gallery/g2data/versions.dat, ) getParameter id.anonymousUser for core plugin [1264269584] can't guarantee 5 -- extending! file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/0/0/5.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/core/ShowItem.inc) getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin
--------------------------------------------------------------------------------
(mysqlt): SET NAMES "utf8"
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_Group.g_id, g_Group.g_groupName FROM g_UserGroupMap, g_Group WHERE g_Group.g_id = g_UserGroupMap.g_groupId AND g_UserGroupMap.g_userId = 5 ORDER BY g_Group.g_groupName LIMIT 2147483647
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_Schema.g_info FROM g_PluginMap, g_Schema WHERE g_PluginMap.g_pluginId = g_Schema.g_pluginId AND g_Schema.g_type = 'map' AND g_PluginMap.g_active = 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g_PermissionSetMap
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT DISTINCT g_AccessMap.g_accessListId FROM g_AccessMap WHERE g_AccessMap.g_userOrGroupId IN (5,4) AND g_AccessMap.g_permission & 1 = 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_value FROM g_CacheMap WHERE g_key='1d15d0630dd703522b42aee9c1c4df7c' AND g_type='page' AND g_userId=5 AND g_timestamp >1264226384 AND g_isEmpty=0
--------------------------------------------------------------------------------
getParameter smarty.compile_check for core plugin getParameter id.anonymousUser for core plugin getParameter id.adminGroup for core plugin
--------------------------------------------------------------------------------
(mysqlt): SELECT g_userId FROM g_UserGroupMap WHERE g_userId=5 AND g_groupId=3 LIMIT 1
--------------------------------------------------------------------------------
getParameter id.anonymousUser for core plugin getParameter id.rootAlbum for core plugin
--------------------------------------------------------------------------------
(mysqlt): SELECT DISTINCT g_AccessMap.g_accessListId FROM g_AccessMap WHERE g_AccessMap.g_userOrGroupId IN (5,4) AND g_AccessMap.g_permission & 1 = 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_itemId FROM g_AccessSubscriberMap WHERE g_itemId=7 AND g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) LIMIT 1
--------------------------------------------------------------------------------
getParameter id.rootAlbum for core plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/0/0/7.inc)
--------------------------------------------------------------------------------
(mysqlt): SELECT g_itemId FROM g_AccessSubscriberMap WHERE g_itemId=7 AND g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) LIMIT 1
--------------------------------------------------------------------------------
Loading plugin matrix Class not defined, trying to include it. file_exists(/home/content/c/m/m/cmmtc/html/gallery/themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/theme/matrix/0/0/0.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/theme/matrix/0/0/7.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/theme/_all/localUrlMap.txt)
--------------------------------------------------------------------------------
(mysqlt): SELECT g_itemId FROM g_AccessSubscriberMap WHERE g_itemId=7 AND g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SET AUTOCOMMIT=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): BEGIN
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): UPDATE g_ItemAttributesMap SET g_viewCount = g_ItemAttributesMap.g_viewCount + 1 WHERE g_itemId=7
--------------------------------------------------------------------------------
getParameter misc.markup for core plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/comment/Preloads.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/exif/Preloads.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/core/Preloads.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/core/Preloads.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/icons/classes/IconsImpl.class) getParameter iconpack for icons plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/module/icons/0/0/0.inc) Unimplemented: ColorPackInterface_1_0
--------------------------------------------------------------------------------
(mysqlt): SELECT g_ChildEntity.g_id, g_ItemAttributesMap.g_orderWeight FROM g_ChildEntity INNER JOIN g_ItemAttributesMap ON g_ChildEntity.g_id = g_ItemAttributesMap.g_itemId INNER JOIN g_Item ON g_ChildEntity.g_id = g_Item.g_id INNER JOIN g_AccessSubscriberMap ON g_ChildEntity.g_id = g_AccessSubscriberMap.g_itemId WHERE g_ChildEntity.g_parentId = 7 AND g_AccessSubscriberMap.g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) ORDER BY g_ItemAttributesMap.g_orderWeight, g_ChildEntity.g_id LIMIT 18
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_ChildEntity.g_parentId, COUNT(g_ChildEntity.g_id) FROM g_ChildEntity, g_AccessSubscriberMap WHERE g_ChildEntity.g_parentId IN (7) AND g_AccessSubscriberMap.g_itemId = g_ChildEntity.g_id AND g_AccessSubscriberMap.g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) GROUP BY g_ChildEntity.g_parentId
--------------------------------------------------------------------------------
getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/9/1/915.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/2/5/2538.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/0/7/75.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/2/5/2535.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/8/2/824.inc) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/1/6/1650.inc)
--------------------------------------------------------------------------------
(mysqlt): SELECT g_AccessSubscriberMap.g_itemId, BIT_OR(g_AccessMap.g_permission) FROM g_AccessMap, g_AccessSubscriberMap WHERE g_AccessSubscriberMap.g_itemId IN (915,2538,75,2535,824,1650) AND g_AccessSubscriberMap.g_accessListId = g_AccessMap.g_accessListId AND g_AccessMap.g_userOrGroupId IN (5,4) GROUP BY g_AccessSubscriberMap.g_itemId
--------------------------------------------------------------------------------
[1264269585] can't guarantee 30 -- extending!
--------------------------------------------------------------------------------
(mysqlt): SELECT g_parentSequence FROM g_ItemAttributesMap WHERE g_itemId=7
--------------------------------------------------------------------------------
file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/entity/0/0/6.inc)
--------------------------------------------------------------------------------
(mysqlt): SELECT g_itemId, g_viewCount FROM g_ItemAttributesMap WHERE g_itemId IN (7,915,2538,75,2535,824,1650)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_ChildEntity.g_parentId, COUNT(g_ChildEntity.g_id) FROM g_ChildEntity, g_AccessSubscriberMap WHERE g_ChildEntity.g_parentId IN (915,2538,75,2535,824,1650) AND g_AccessSubscriberMap.g_itemId = g_ChildEntity.g_id AND g_AccessSubscriberMap.g_accessListId IN (7282,7281,7280,7277,7278,7279,7286,7502) GROUP BY g_ChildEntity.g_parentId
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_itemId, g_descendentCount FROM g_DescendentCountsMap WHERE g_userId=5 AND g_itemId IN (7,915,2538,75,2535,824,1650)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SELECT g_AccessSubscriberMap.g_itemId, BIT_OR(g_AccessMap.g_permission) FROM g_AccessMap, g_AccessSubscriberMap WHERE g_AccessSubscriberMap.g_itemId IN (7) AND g_AccessSubscriberMap.g_accessListId = g_AccessMap.g_accessListId AND g_AccessMap.g_userOrGroupId IN (5,4) GROUP BY g_AccessSubscriberMap.g_itemId
--------------------------------------------------------------------------------
Loading plugin rearrange Class not defined, trying to include it. file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/rearrange/module.inc) rearrange plugin successfully instantiated Check the version of the rearrange plugin The version of the rearrange plugin is ok Loading plugin shutterfly Class not defined, trying to include it. file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/shutterfly/module.inc) shutterfly plugin successfully instantiated Check the version of the shutterfly plugin The version of the shutterfly plugin is ok Loading plugin comment Class not defined, trying to include it. file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/comment/module.inc) comment plugin successfully instantiated Check the version of the comment plugin The version of the comment plugin is ok getParameter comments.latest for comment plugin file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/cache/module/comment/0/0/0.inc) mysqlt error: [1054: Unknown column 'g_Comment.g_publishStatus' in 'where clause'] in EXECUTE(" SELECT g_ChildEntity.g_parentId, COUNT(g_Comment.g_id) FROM g_Comment, g_ChildEntity WHERE g_ChildEntity.g_parentId IN (915,2538,75,2535,824,1650) AND g_ChildEntity.g_id = g_Comment.g_id AND g_Comment.g_publishStatus = 0 GROUP BY g_ChildEntity.g_parentId ")
--------------------------------------------------------------------------------
(mysqlt): SELECT g_ChildEntity.g_parentId, COUNT(g_Comment.g_id) FROM g_Comment, g_ChildEntity WHERE g_ChildEntity.g_parentId IN (915,2538,75,2535,824,1650) AND g_ChildEntity.g_id = g_Comment.g_id AND g_Comment.g_publishStatus = 0 GROUP BY g_ChildEntity.g_parentId
--------------------------------------------------------------------------------
1054: Unknown column 'g_Comment.g_publishStatus' in 'where clause'

ADOConnection._Execute(
SELECT
g_ChildEntity.g_parentId,
COUNT(g_Comment.g_id)
FROM
g_Comment, g_ChildEntity
WHERE
g_ChildEntity.g_paren...) % line
872, file: adodb.inc.php

ADOConnection.Execute(
SELECT
g_ChildEntity.g_parentId,
COUNT(g_Comment.g_id)
FROM
g_Comment, g_ChildEntity
WHERE
g_ChildEntity.g_paren..., Array[7])
% line 488, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryChildEntity::parentId],
COUNT([GalleryComment::id])
FROM
[GalleryComment], [GalleryChildEntity]
WHER..., Array[7], Array[0]) % line
209, file: Gallery.class
Gallery.search(
SELECT
[GalleryChildEntity::parentId],
COUNT([GalleryComment::id])
FROM
[GalleryComment], [GalleryChildEntity]
WHER..., Array[7]) % line 273, file:
GalleryCommentHelper.class
GalleryCommentHelper.fetchCommentCounts(Array[6]) % line 292, file: module.inc
getParameter id.adminGroup for core plugin getParameter default.theme for core plugin Loading plugin matrix matrix plugin successfully instantiated Check the version of the matrix plugin The version of the matrix plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok getParameter id.adminGroup for core plugin realpath(/home/content/c/m/m/cmmtc/html/gallery/modules/core/classes/../../../) realpath(/home/content/c/m/m/cmmtc/html/gallery/) Loading plugin matrix matrix plugin successfully instantiated Check the version of the matrix plugin The version of the matrix plugin is ok file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/smarty/templates_c/%%1137619580/matrix) is_dir(/home/content/c/m/m/cmmtc/html/gallery/g2data/smarty/templates_c/%%1137619580/matrix) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/smarty/templates_c/%%1137619580/matrix) is_writeable(/home/content/c/m/m/cmmtc/html/gallery/g2data/smarty/templates_c/%%1137619580/matrix) file_exists(/home/content/c/m/m/cmmtc/html/gallery/g2data/smarty/templates_c/%%1137619580/matrix/v_14) file_exists(/home/content/c/m/m/cmmtc/html/gallery/lib/javascript/local/BlockToggle.js) file_exists(/home/content/c/m/m/cmmtc/html/gallery/modules/core/../../themes/matrix/local/theme.css)

Server technologies: Server technologies: LINUX, PHP 5.1, CGI 2.0, PERL 5.0, PYTHON 2.4, RUBY 1.8.4, MYSQL 4.0.27, 4.1, 5.0 (using mysql5)

Gallery version (not just "2"):2.3.1
PHP version (e.g. 5.1.6):5.1
Database (e.g. MySql 5.0.32):MySql5
Activated toolkits (e.g. NetPbm, GD):Multiple Imagemagic, ffmpeg and more
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Ie8
http://marlinandtuna.com/gallery/main.php
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Sun, 2010-01-24 00:40
Quote:
mysqlt error: [1054: Unknown column 'g_Comment.g_publishStatus' in 'where clause'] in EXECUTE(" SELECT g_ChildEntity.g_parentId, COUNT(g_Comment.g_id) FROM g_Comment, g_ChildEntity WHERE g_ChildEntity.g_parentId IN (915,2538,75,2535,824,1650) AND g_ChildEntity.g_id = g_Comment.g_id AND g_Comment.g_publishStatus = 0 GROUP BY g_ChildEntity.g_parentId ")

Looks like an issue with the Comment plugin. Is that still installed and did it get upgraded when you upgraded to 2.3.1?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
sterlingII

Joined: 2010-01-23
Posts: 6
Posted: Sun, 2010-01-24 06:16

I didn't receive an error on any plugin upgrades but I am not certain of the status of this one. I'm going to roll back again, remove it, and give it another shot.
 
sterlingII

Joined: 2010-01-23
Posts: 6
Posted: Sun, 2010-01-24 13:53

Is there an ini file, or other way, to exclude plugins? Rather than trying to do it through the admin interface, which is not working at this time?
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Sun, 2010-01-24 16:18

Is nothing working or all of Site Admin or just Site Admin > Plugins?

You can disable plugins this way:
FAQ: How can I deactivate a module when I am unable to login?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
sterlingII

Joined: 2010-01-23
Posts: 6
Posted: Sun, 2010-01-24 18:34

Nothing was working. I rolled back and am not able to uninstall the comment module. It appears the core rolled back but not many of the modules. The Gallery is now back up, although limping along, on the old version. I've spent days on this and am turning my sights to installing Gallery 3 beta 3, although I've hit some issues there as well but am hopeful that version moves to production soon as I'd rather work out the kinks on an updated solution.