Some JPG images don't show up in Digikam. However, if you check: Settings → Configure digiKam → Editing Images → Always show original images, the missing images appear. But image history bar shows a mess of Derived Images and Identical Images that are neither derived nor identical. digiKam Version 2.5.0 Using KDE Development Platform 4.8.5 (4.8.5) Ubuntu 12.04.1 LTS
Is this in some way reproducible? Did you see this appear once, or are images missing regularly? Are any of the derived images actually edited with digikam?
I went into digikam4.db using a database tool (sqliteman) and dropped and re-created the imagerelations table. I don't know if dropping that table might screw up other things in the database. I hope not. Then I re-started digikam (2.5x) and let it "do its thing" overnight. Things are better than they were before. Some of the erroneous version relationships are back, notably with an mp4 video. And the imagerelations table has stuff in it, which I didn't expect because looking in the filesystem I don't see any files with version numbers embedded in the filename, but I'm not sure where to look. Can you give me a 'find' command to track them down?? Since then, I've also upgraded to digikam 3.0 from Philip Johnsson ppa. But haven't repeated the drop table exercise since I upgraded.
More info regarding the mp4 video: The "erroneous version relationship" I mentioned consists of three "Identical Images" in the "Versions and applied filters in a combined list" view, two of which have the animated circular dots "updating/progress" icon where the thumbnail should be.
Dropping the relations table has no side effects, you just lose relations. Locating identical images is not based on the relations table, it's based on file hash and file size (seems not to work with mp4 videos) The first edited file usually has "_v1" appended to the file's base name, and so on.
OK, so there are at least a couple images in the imagerelations table that have what looks like hundreds or thousands of related images. But there shouldn't be any related images. I don't use digikam for editing images. I use Gimp. Looking at one of the "parent" images in digikam Versions pane, I see that the supposedly related images are not related to the parent. Not sure how the imagerelations table got re-populated. Is that what you would expect? Select count(*) gives 4526 rows.
Reverted to 2.5x because 3.0 had an issue with the window manager menus.
No, I dont have an idea how the table gets populated.
C Doe, What's new about this file using last digiKam 3.5.0 ? Gilles Caulier
C Doe, What's new about this file using last digiKam 4.2.0 ? Gilles Caulier
I'm still using 3.x under Ubuntu Trusty. Not sure if I can install 4.x
New digiKam 4.11.0 is available : https://www.digikam.org/node/740 Can you reproduce the problem with this release ? Gilles Caulier
Using digiKam 3.5.0 on Ubuntu, the sqlite digikam4.db imagerelations table looks clean. MUCH better than before, for sure. There are several relations in the table, and a perfunctory examination seems to indicate they are legit. There are also other images that exist in the filesystem that are also "related", but don't appear in the imagerelations table. Again, I'm not sure how the imagerelations table gets populated or what actually SHOULD be in there. But there are no longer thousands of rows in the table that do not belong there. Yay!
Ok, fine i close this file now. We have a plenty of reports about Database integrity to review, including last stuff that you report in your last comment. Gilles Caulier
Seems to be a duplicate of bug #305104