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
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 ..."
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?
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 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
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.
Open your database file, or a copy of this file, with the sqlite3 command line tool.
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
We needs a fresh feedback here using last digiKam 4.2.0. Gilles Caulier
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
Try the latest 5.0.0 version. If you think the report is still valid, feel free to re-open and provide necessary updates.