[Digikam-users] Disappearing images

[Milan Zamazal]

>>>>> "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';
  58669||imgp0100.pef|3|1|2010-08-14T22:31:44|15538784|b1a4c0e45f29ee15b207007767286165
  58672|49|imgp0039.pef|1|1|2010-08-08T18:49:29|15538784|b1a4c0e45f29ee15b207007767286165
  58677|361|imgp0039.pef|1|1|2010-08-08T18:49:29|15538784|b1a4c0e45f29ee15b207007767286165
  58683|372|pokusik.pef|1|1|2010-08-14T22:10:10|15538784|b1a4c0e45f29ee15b207007767286165
  58684|372|xxxx0100.pef|1|1|2010-08-14T22:31:44|15538784|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?