Integrity Check Failing

mikeage
mikeage's picture

Joined: 2005-01-23
Posts: 138
Posted: Sun, 2008-05-04 08:54

Hi,

I just ran the Integrity Check for the first time on my gallery (after boosting memory_limit from 32M to 128M!), and it reported a bunch of errors:

Check data integrity and report any inconsistencies.

Last Run Details:

Failed to load entity ids: 17971, 17972, 17973, 17974, 17975, 17976, 17977, 17978, 17979, 17981, 17982, 17983, 17984, 17985, 17986, 17987, 17988, 17989, 17990, 17991, 17992, 17993, 17994, 17995, 17996, 17997, 17998, 18000, 18001, 18002, 18003, 18004, 18005, 18006, 18007, 18008, 18009, 18082, 18083, 18084, 18085, 18086, 18087, 18088, 18089, 18090, 18091, 18092, 18093, 18144, 18145, 18146, 18147, 18148, 18149, 18150, 18151, 18152, 18153, 18154, 18155, 18156, 18157, 18158, 18159, 18160, 18161, 18162, 18163, 18164, 18165, 18166, 18167, 18168, 18169, 18170, 18171, 18172, 18173, 18174, 18175, 18176, 18177, 18178, 18179, 18180, 18181, 18182, 18183, 18184, 18185, 18186, 18187, 18188, 18189, 18190, 18191, 18192, 18193, 18194, 18195, 18196, 18197, 18198, 18199, 18200, 18201, 18202, 18203, 18204, 18205, 18206, 18207, 18208, 18209, 18210, 18211, 18212, 18213, 18214, 18215, 18216, 18217, 18218, 18219, 18220, 18221, 18222, 18223, 18224, 18225, 18226, 18227, 18228, 18229, 18230, 18231, 18232, 18233, 18234, 18235, 18236, 18237, 18238, 18239, 18240, 18241, 18242, 18243, 18244, 18245, 18246, 18247, 18248, 18249, 18250, 18251, 18252, 18253, 18254, 18278, 18279, 18280, 18281, 18282, 18283, 18284, 18285, 18286, 18287, 18288, 18289, 18290, 18291, 18292, 18293, 18294, 18295, 18296, 18297, 18298, 18299, 18300, 18301, 18356, 18357, 18358, 18359, 18360, 18361, 18362, 18363, 18364, 18365, 18366, 18367, 18368, 18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378, 18379, 18380, 18381, 18382, 18443, 18444, 18445, 18446, 18447, 18456, 18458, 18459, 18461, 18463, 18466, 18467, 18469, 18470, 18471, 18473, 18474, 20518, 20519, 20520, 20521, 20522, 20616, 20617, 20618, 20619, 20620, 20621, 20622, 20623, 20624, 20625, 20626, 20627, 20900, 20901, 20902, 20903, 20967, 20968, 20969, 20970, 20971, 20972, 20973, 20974, 20975, 20976, 20977, 20978, 20979, 20980, 20981, 21141, 21142, 21143, 21144
Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 17417, 17418, 17419, 17420, 17421, 17423, 17424, 17433, 17435, 20660, 20662, 20669, 21454
Orphaned data in table DerivativePreferencesMap with no row in GalleryAlbumItem table; ids: 6905, 6940, 9741, 9742, 9743, 9744, 9745, 9746, 12208
Unknown plugin: module photolinks
Orphaned data in table PluginParameterMap with no row in PluginMap table; ids: module/core, module/jpegtran
Path component /home/mikeage/g2data_mikeage/albums/Family_0 not connected to any item
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0669.JPG missing for id 12248
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0694.JPG missing for id 12282
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0695.JPG missing for id 12285
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0670.JPG missing for id 12392
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0692.JPG missing for id 12395
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0603/CIMG0693.JPG missing for id 12398
Path component /home/mikeage/g2data_mikeage/albums/Family/2006/0605/CIMG0950.JPG not connected to any item

I understand the one about "Unknown plugin: module photolinks" (it was a module I once started working on, and then abandoned), although I'm not sure how to remove it completely. I understand that "Path compoennt <foo> missing for id <bar>" is a missing image (which I'll have to restore from a backup)", but what should/can/must I do about the "Orphaned data" and "Failed to load entity ids" messages?

I suspect some of the failed to load entity ids messages may be from an earlier attempt to remove comment spam by deleting items only from the g2_Comment table (yes, I've since learned better).


Gallery version = 2.1.2 core 1.1.0.2
PHP version = 4.4.4 cgi
Webserver = Apache/1.3.37 (Unix) mod_gzip/1.3.26.1a mod_fastcgi/2.4.2 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
Database = mysqlt 4.1.21-standard-log, lock.system=flock
Toolkits = Thumbnail, Gd, ArchiveUpload, Ffmpeg, ImageMagick, NetPBM
Acceleration = partial/21600, partial/21600
Operating system = Linux sirens.site5.com 2.6.9-34.0.2.ELsmp #1 SMP Fri Jul 7 19:52:49 CDT 2006 i686