Disappearing images

[Milan Zamazal]

In digiKam 1.2.0 some images disappear from album views.  This possibly
happens after moving or copying images across albums (I often receive
strange, nonsense errors telling something about missing source albums
or image information during the operation).  An image is present on the
hard drive, it can be displayed in showfoto without problems, it's
present in showfoto when running it as `showfoto .', the image file
seems to be unmodified and it was previously normally displayed in an
album view.  But now I can't persuade digiKam to display it, digiKam
behaves like the image file wouldn't exist.  Moving or copying the image
to another album directory (using mv/cp), renaming it, deleting its rows
from `Images' database table or restarting digiKam or the machine
doesn't help.  One special thing is that the image directories are
stored on a remote file system.

What can be the problem?  Is there a way to persuade digiKam not to hide
such images anymore?


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Milan Zamazal]

>>>>> "MZ" == Milan Zamazal <[hidden email]> 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?


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Milan Zamazal]

>>>>> "MZ" == Milan Zamazal <[hidden email]> writes:

    MZ> I still don't know how to identify other possibly hidden images
    MZ> in the database.

I've found the hidden images are those which are present in Images table
but have no entries in ImageInformation table.  So the remedy is

  delete from Images where id not in (select imageid from ImageInformation);

It would be fine if digiKam wouldn't omit such images in album views and
added the missing entries to ImageInformation instead.


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users