[digikam] [Bug 323210] New: Image History Bar Shows A Mess Of Derived Images And Identical Images That Are Neither Derived Nor Identical

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

            Bug ID: 323210
           Summary: Image History Bar Shows A Mess Of Derived Images And
                    Identical Images That Are Neither Derived Nor
                    Identical
    Classification: Unclassified
           Product: digikam
           Version: unspecified
          Platform: unspecified
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Versioning
          Assignee: [hidden email]
          Reporter: [hidden email]

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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #1 from Marcel Wiesweg <[hidden email]> ---
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?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #2 from C Doe <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #3 from C Doe <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #4 from Marcel Wiesweg <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #5 from C Doe <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #6 from C Doe <[hidden email]> ---
Reverted to 2.5x because 3.0 had an issue with the window manager menus.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

C Doe <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Platform|unspecified                 |Ubuntu Packages

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #7 from Marcel Wiesweg <[hidden email]> ---
No, I dont have an idea how the table gets populated.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=323210

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #8 from Gilles Caulier <[hidden email]> ---
C Doe,

What's new about this file using last digiKam 3.5.0 ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=323210

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WAITINGFORINFO

--- Comment #9 from Gilles Caulier <[hidden email]> ---
C Doe,

What's new about this file using last digiKam 4.2.0 ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #10 from C Doe <[hidden email]> ---
I'm still using 3.x under Ubuntu Trusty. Not sure if I can install 4.x

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #11 from Gilles Caulier <[hidden email]> ---
New digiKam 4.11.0 is available :

https://www.digikam.org/node/740

Can you reproduce the problem with this release ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[C Doe]

https://bugs.kde.org/show_bug.cgi?id=323210

--- Comment #12 from C Doe <[hidden email]> ---
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!

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=323210

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |4.12.0

--- Comment #13 from Gilles Caulier <[hidden email]> ---
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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=323210

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WAITINGFORINFO              |FIXED

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=323210

Johannes <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |johannes.lists+bugs.kde.org
                   |                            |@tannenhof-imshausen.de

--- Comment #14 from Johannes <[hidden email]> ---
Seems to be a duplicate of bug #305104

--
You are receiving this mail because:
You are the assignee for the bug.