Search Bug

fatman

Test on 1.4.4, when there is garbage data (records exist in image table but not in album table) and search criteria hit them, the search function will fail (the sql query assume the images.albumid is valid)

It could be fixed by perform a database refresh.

sbillard

yes. A database refrsh will purge out of the database any items that no longer exist.

Of course, it is best to remove things via Zenphoto in the first place, then you do not get into this sitation.

fatman

It is a Blank page when the search fail.

I think it should add a checking on the Image table query result set, then it could be fixed.

sbillard

Please crete an issue on this then. But understand that it is pretty well impossible for a piece of software to anticipate all the ways someone can screw with it outside of its knowledge. The standard to date for Zenphoto is to throw an error indicating it detected an invalid album and continue. Downstream code may or may not try to check if the album is valid. Since normally it would be it is not at all clear that it would be worth the cost of placing a test on each and every object reference to determine if it is valid.