[Bug 296767] New: pick labels lost somewhere during digikam update

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

            Bug ID: 296767
          Severity: major
           Version: unspecified
          Priority: NOR
          Assignee: [hidden email]
           Summary: pick labels lost somewhere during digikam update
    Classification: Unclassified
                OS: Linux
          Reporter: [hidden email]
          Hardware: Gentoo Packages
            Status: UNCONFIRMED
         Component: Database
           Product: digikam

User-Agent:       Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.11 (KHTML,
like Gecko) Chrome/17.0.963.83 Safari/535.11
Build Identifier:

Hi

I have a collection of a quite large amount of pictures and I used pick labels
to mark the ones in the selection to show to the people. I just noticed, that
all pick labels were lost. I might have a backup that still has them, but I'm
not sure. I'm currently using 2.5.0 but I cannot tell when I lost them because
I just noticed it.

Reproducible: Always




I know that I'm quite vague about the problem, but I don't know what else to
tell you. I have sqliteviewer installed, so I could give you much info about
the database. May be you could tell me where they are stored so I can check the
backup

--
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=296767

--- Comment #1 from Marcel Wiesweg <[hidden email]> ---
Pick labels are assigned just like tags in the ImageTags table.
The tags table gives you information when you then have the ids of assigned
tags - the pick label tags have the name "Pick Label ..."

--
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

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

--- Comment #2 from Benjamin Schindler <[hidden email]> ---
Just so I get it correctly, the idea is - the id of the Pick tag is used in the
ImageTags table?
The thing which confuses me is that I have a digikam3.db and a digikam.4.db -
which one do I have to check?

--
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

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

--- Comment #3 from Benjamin Schindler <[hidden email]> ---
Actually, I just noticed that the corruption in my db is more serious than
initially thought. I not only lost all the pick labels, tags got messed up as
well.

Some images have tags which they didn't have before, and vice-versa. I have
year-collection tags, and suddenly, there were images which had tags from 2007
and 2008 etc.

I just checked my backup and the pick labels are lost in there too, so I have
no way to even trying to reproduce the bug :(

Is there anything I can do to track this down? How can I trust a software after
such a hickup?

--
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=296767

--- Comment #4 from Marcel Wiesweg <[hidden email]> ---
You may guess that we dont have SQL code which introduces random changes inside
the tags table. Did you check the database for corruption?
http://www.sqlite.org/howtocorrupt.html
http://www.sqlite.org/pragma.html#pragma_integrity_check

--
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

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

--- Comment #5 from Benjamin Schindler <[hidden email]> ---
I'm unsure on how to set these pragmas... is there a way without modifying the
source?

I don't find that argument with random changes particularly convincing after
loosing so much data. Bugs happen - I'm a software developer myslef. I have a
bug open since a few months which is about digikam stripping exif information
in certain cases - I lost about 50% of the exif tags of my whole collection
(jpeg's only fortunatelly, raws are unaffected).

So basically, I lost now 50% of my exifs, now the pick labels, all in
connection with digikam. You understand why the trust in the software has
suffered quite a bit.

--
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=296767

--- Comment #6 from Marcel Wiesweg <[hidden email]> ---
Open your database file, or a copy of this file, with the sqlite3 command line
tool.

--
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=296767

--- Comment #7 from Gilles Caulier <[hidden email]> ---
Official digiKam 2.6.0 release is out since few days now :

http://www.digikam.org/drupal/node/656

Please, check if this entry still valid, or update report accordingly.

Thanks in advance.

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=296767

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WAITINGFORINFO

--- Comment #8 from Gilles Caulier <[hidden email]> ---
We needs a fresh feedback here 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

[Gilles Caulier-4]

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

--- Comment #9 from Gilles Caulier <[hidden email]> ---
New digiKam 4.11.0 is available with official PKG installer for OSX.

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

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WAITINGFORINFO              |FIXED
   Version Fixed In|                            |5.0.0
                 CC|                            |[hidden email]

--- Comment #10 from [hidden email] ---
Try the latest 5.0.0 version.

If you think the report is still valid, feel free to re-open and provide
necessary updates.

--
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=296767

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Migration

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