Query DB for broken thumbnails

agaudio

Joined: 2008-01-02
Posts: 15
Posted: Wed, 2008-04-30 18:27

I was just looking for some insight as to what query I could use on the gallery2 db's to determine if a thumbnail is broken or not. I did notice in the Derivative Table that there is a field isBroken. There are some instances where this is still set to 1 for images that don't have a broken thumbnail.

Thank you!

- Anthony

Login or register to post comments
valiant

Joined: 2003-01-04
Posts: 31891
Posted: Sun, 2008-05-04 20:32

> There are some instances where this is still set to 1 for images that don't have a broken thumbnail.

how do you determine that the thumbnail isn't broken?

say the derivative (= thumbnail, resized image or watermarked image) has an id of 57, then you'd enter this URL into your browser to view it:

http://example.com/gallery2/main.php?g2_view=core.DownloadItem&g2_itemId=57

make sure your browser's cache is empty or make a hard refresh to download the image.

if it shows up fine and if the database row has isBroken = 1, then it's truly a wrong value.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage

Login or register to post comments