Menu

How to thumbnail specific album/picture?

Fuse314
2009-02-07
2013-04-25
  • Fuse314

    Fuse314 - 2009-02-07

    I have an issue with linpha 1.3.4 in a hosted environment:
    Sometimes (around 1 in 5 times) the thumbnails for the new images are not created correctly.
    The Progress just goes very quick and says i.E. "41 thumbnails created", but in the album overview, no thumbnails are displayed (just the "thumbnail" - alt-Text).

    I tried finding the reason for this behavior (checked image files/permissions), but since it only appears sometime, I cannot track it to its root. (and if I recreate the thumbnails, they are created correctly for all the images)

    Now my question:
    Since it takes a VERY long time to rebuild the thumbnails for ALL (around 7000) images, is there a way to reset the import status for single images or to rebuild the thumbnails just for a single album?
    I searched in the database for clues where the already processed files are stored but could not find it. Even if I delete the rows of the wrongly-imported thumbnails manually, they never get re-created.

    Thanks in advance for your help.
      Gottfried

     
    • Fuse314

      Fuse314 - 2009-02-09

      I found a way after some research (This is what create_all_thumbs.php does) :

      WARNING: This is a workaround that requires to modify the data in the database directly, be very careful as you could break the functionality of linpha!

      How to reset thumbnails of specific images:

      1) open phpMyAdmin and open the linpha_photos table.
      2) go to the last page, new images are added at the end of the table
      3) in my case the images with the "broken" thumbnail all had a BLOB size of around 600bytes in the thumbnail column.
      4) Run the following SQL statement (in the SQL Tab): "UPDATE linpha_photos SET thumbnail = NULL WHERE ID > 7654" (without the quotes. Instead of 7654, you have to enter the ID of the last good image row)

      5) Open linpha admin and CREATE the thumbnails (no recreate required). The missing thumbnails are now created again.

      I still have to figure out why the thumbnails are not created correctly sometimes on my install, but this helps me fix the problem on a file-to-file basis.

      Thanks for the great software, Team LinPHA!

       

Log in to post a comment.