How to Clean Up Orphaned Data?

yottabit

Joined: 2004-02-25
Posts: 36

Posted: Thu, 2009-10-15 21:37

Gallery URL = http://jacobmcdonald.net/gallery2/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.6-3ubuntu4.2 cgi-fcgi
Webserver = lighttpd/1.4.19
Database = mysqli 5.0.75-0ubuntu10.2, lock.system=flock
Toolkits = Exif, Getid3, LinkItemToolkit, Thumbnail, ArchiveUpload, Dcraw, Ffmpeg, jpegtran, NetPBM, Gd
Acceleration = partial/21600, partial/21600
Operating system = Linux eddie 2.6.28-15-server #52-Ubuntu SMP Wed Sep 9 11:34:09 UTC 2009 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 192
Rows in GalleryAccessSubscriberMap table = 17135
Rows in GalleryUser table = 6
Rows in GalleryItem table = 17129
Rows in GalleryAlbumItem table = 455
Rows in GalleryCacheMap table = 43

When running the Build All Thumbnails function I see a ton of output that doesn't really make sense to me. So I ran the Integrity Check, and it spit out this:

Checked 52201 entities
Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 77276, 77277, 77278, 77279, 77280, 77281, 77282, 77283, 77284, 77285, 77286, 77287, 77288, 77289, 77290, 77291, 77292, 77293, 77294, 77295, 77296, 77297, 77298, 77299
Path component /var/www/jacobmcdonald.net/gallery2/g2data/albums/vacations/album177/album178/Thumbs.db not connected to any item

I have phpMyAdmin installed and am capable of navigating the database, but I need some pointers on how to start. Could someone let me know where to start digging in order to get to the bottom of this orphaned data?

Thanks!

davert

Joined: 2009-01-22
Posts: 81

Posted: Fri, 2010-02-26 21:21

Did you ever figure it out:? I have the same problem.

alecmyers

Joined: 2006-08-01
Posts: 4342

Posted: Fri, 2010-02-26 23:16

My advice is to leave it alone. It won't do any harm, and if you dig around in the db without knowing what you are doing it can only go badly wrong.

davert

Joined: 2009-01-22
Posts: 81

Posted: Sun, 2010-02-28 01:05

Good point and you are absolutely right but I can't import into Gallery3.

yottabit Joined: 2004-02-25 Posts: 36	Posted: Thu, 2009-10-15 21:37
	Gallery URL = http://jacobmcdonald.net/gallery2/main.php Gallery version = 2.3 core 1.3.0 API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5 PHP version = 5.2.6-3ubuntu4.2 cgi-fcgi Webserver = lighttpd/1.4.19 Database = mysqli 5.0.75-0ubuntu10.2, lock.system=flock Toolkits = Exif, Getid3, LinkItemToolkit, Thumbnail, ArchiveUpload, Dcraw, Ffmpeg, jpegtran, NetPBM, Gd Acceleration = partial/21600, partial/21600 Operating system = Linux eddie 2.6.28-15-server #52-Ubuntu SMP Wed Sep 9 11:34:09 UTC 2009 x86_64 Default theme = matrix gettext = enabled Locale = en_US Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729) Rows in GalleryAccessMap table = 192 Rows in GalleryAccessSubscriberMap table = 17135 Rows in GalleryUser table = 6 Rows in GalleryItem table = 17129 Rows in GalleryAlbumItem table = 455 Rows in GalleryCacheMap table = 43 When running the Build All Thumbnails function I see a ton of output that doesn't really make sense to me. So I ran the Integrity Check, and it spit out this: Checked 52201 entities Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 77276, 77277, 77278, 77279, 77280, 77281, 77282, 77283, 77284, 77285, 77286, 77287, 77288, 77289, 77290, 77291, 77292, 77293, 77294, 77295, 77296, 77297, 77298, 77299 Path component /var/www/jacobmcdonald.net/gallery2/g2data/albums/vacations/album177/album178/Thumbs.db not connected to any item I have phpMyAdmin installed and am capable of navigating the database, but I need some pointers on how to start. Could someone let me know where to start digging in order to get to the bottom of this orphaned data? Thanks!
	XUser login Username: * Password: * Create new account Request new password
davert Joined: 2009-01-22 Posts: 81	Posted: Fri, 2010-02-26 21:21
	Did you ever figure it out:? I have the same problem.

alecmyers Joined: 2006-08-01 Posts: 4342	Posted: Fri, 2010-02-26 23:16
	My advice is to leave it alone. It won't do any harm, and if you dig around in the db without knowing what you are doing it can only go badly wrong.

davert Joined: 2009-01-22 Posts: 81	Posted: Sun, 2010-02-28 01:05
	Good point and you are absolutely right but I can't import into Gallery3.

How to Clean Up Orphaned Data?

XUser login