[Digikam-users] Disappearing images

Milan Zamazal pdm at zamazal.org
Sun Aug 15 19:13:46 BST 2010

>>>>> "MZ" == Milan Zamazal <pdm at zamazal.org> writes:

    MZ> But now I can't persuade digiKam to display it, digiKam behaves
    MZ> like the image file wouldn't exist.  Moving or copying the image
    MZ> to another album directory (using mv/cp), renaming it, deleting
    MZ> its rows from `Images' database table or restarting digiKam or
    MZ> the machine doesn't help.

I finally suceeded in recovering the image: digiKam started to display
it after I had removed all rows with the same `uniqueHash' (not only
name) value as the hidden image from `Images' table:

  sqlite> delete from Images where uniqueHash='b1a4c0e45f29ee15b207007767286165';

I still don't know how to identify other possibly hidden images in the
database.  Rows of the hidden images in Images table had looked mostly
innocent to me before I removed them:

  sqlite> select * from Images where uniqueHash='b1a4c0e45f29ee15b207007767286165';

I've got a copy of an old database exhibiting the problem so I can
investigate further what's the cause of the problem.  Any hints?  So far
performing `update Images set status=1 where status=3' didn't help, nor
removing the thumbnails database.  So what else could I try?

More information about the Digikam-users mailing list