Database Integrity Checker

hazzy

Joined: 2005-05-07
Posts: 55
Posted: Tue, 2010-02-09 14:52

Hi All,

Having some 3000+ images loaded, I find I have a bit of database corruption. Images show up in gallery but without a thumbnail or main file. Not sure how it happened but I would like to sort it out without reloading everything again if possible.

Is anyone aware of a way of verifying what is in the database against the actual files present and producing a report? Is there a module to do this check?

Once I know what is wrong, I could then manually delete database items that have no matching file entry to syncronise them again. Then reupload the missing images the normal way.

Cheers,

John

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 22892
Posted: Tue, 2010-02-09 15:05

Here is a recent change that might be related:
http://github.com/gallery/gallery3/commit/225fe81ce0121176dc11a646d78b3c3dcc479fa9
a upgrade should fix your issue.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
hazzy

Joined: 2005-05-07
Posts: 55
Posted: Wed, 2010-02-10 15:25

Hi Dave,

Thanks for the idea but I am already at Gallery version 26 so I guess this fix is applied.

John