This error appears when I try to go to page 2 of the album Visual. I have run the Integrity module, and after clearing up what I can of the problems it reported it still shows "Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 21298, 21299, 21300 " - I'm not sure how to fix this one. I've run suprsidr's missingObjectFix script, and it reports everything OK.
Any suggestions?
**************************
Gallery URL = http://www.carlowphoto.ie/gallery/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.3.2-1ubuntu4.13 apache2handler
Webserver = Apache/2.2.14 (Ubuntu) PHP/5.3.2-1ubuntu4.13 with Suhosin-Patch
Database = mysqli 5.1.41-3ubuntu12.10, lock.system=database
Toolkits = Exif, Ffmpeg, ImageMagick, NetPBM, ArchiveUpload
Acceleration = none, none
Operating system = Linux glasnost 2.6.32-38-server #83-Ubuntu SMP Wed Jan 4 11:26:59 UTC 2012 x86_64
Default theme = carbon
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/534.52.7 (KHTML, like Gecko) Version/5.1.2 Safari/534.52.7
Rows in GalleryAccessMap table = 580
Rows in GalleryAccessSubscriberMap table = 4815
Rows in GalleryUser table = 56
Rows in GalleryItem table = 4805
Rows in GalleryAlbumItem table = 334
Rows in GalleryCacheMap table = 0
*******************
AK
Posted: Thu, 2012-02-16 13:16
Posts: 8339
That was always one of my dislikes about G2
it self crashes instead of handling errors gracefully.
How about show the rest of the page?
Anyways, we can try to remove the object, but if its an album it may remove more.
Try to gleam what type of object it is by searching the GalleryItem, GalleryEntity, GalleryDerivative tables for id 6763
My missing object fix basically checks to make sure the physical image is there to correspond to the entry in the DB not vise-versa
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
I had already looked at those tables - they give eg
mysql> select * from g2_Entity where g_id = 6763;
Empty set (0.00 sec)
I should perhaps mention that rebuilding thumbnails/resizes runs without error.
I have just changed the setting on the failing album to display 1 row & col per page, and stepped through the resulting 63 pages each with a single sub-album. It gives the error on 9 of them. I then looked at the list of albums (using Move) and I think I may have spotted a possible problem. Many of the pictures in the sub-albums would have been taken by a former club member whose account was deleted. Could this be the issue? And any suggestions on fixing it?
Thanks.
AK
Posts: 39
I tried
select * from g2_Item where g_ownerId = 6763;
and it returns 322 rows, and in most of them the title includes the deleted member's name. What would you think of
UPDATE g2_Item SET g_ownerId = 6 WHERE g_ownerId = 6763;
User 6 is Admin.
AK
Posts: 8339
Backup your DB first in case 6763 was not the former member.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
I first did a check to see that there was no member 6763, then closed for maintenance, backed up the database, and ran the update query, but assigning the items to a test user rather than admin. After clearing the cache, I could access the sub-albums of Visual, so I restored its theme settings to put all sub-albums on one page, and could still access it. Clicking into the formerly-crashing sub-albums also works, so I think we can mark this one solved.
Thanks for your help.
AK