Summary: | untagged images no longer shown in "no tags" overview when removing existing tag | ||
---|---|---|---|
Product: | [Applications] digikam | Reporter: | beaaeecffmiqwryxcmbw2ta2cukc4 |
Component: | Database-Mysql | Assignee: | Digikam Developers <digikam-bugs-null> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | caulier.gilles, metzpinguin, swatilodha27 |
Priority: | NOR | ||
Version: | 5.1.0 | ||
Target Milestone: | --- | ||
Platform: | Fedora RPMs | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | 5.8.0 |
Description
beaaeecffmiqwryxcmbw2ta2cukc4
2016-10-24 15:05:00 UTC
For those who want to "clean up" their database, that's how I did it. Please be REALLY careful and VERIFY the results BEFORE the delete statement. CREATE TABLE ImageDeleteMe (imageid INT(11) NOT NULL); INSERT INTO ImageDeleteMe SELECT DISTINCT imageid FROM ImageTags WHERE tagid IN ( SELECT id FROM Tags WHERE pid = ( SELECT id FROM Tags WHERE name = '_Digikam_Internal_Tags_' ) AND name LIKE ('% None') ) AND imageid NOT IN ( SELECT imageid FROM ImageTags WHERE tagid NOT IN ( SELECT id FROM Tags WHERE pid = ( SELECT id FROM Tags WHERE name = '_Digikam_Internal_Tags_' ) AND name LIKE ('% None') ) ); DELETE FROM ImageTags WHERE imageid IN ( SELECT imageid FROM ImageDeleteMe ); DROP TABLE ImageDeleteMe; This issue is reproducible for me. (Using digiKam 5.2.0) What I did : 1) Create a new album and add a new image. (Shown in "no tags" overview) 2) Assign a new tag (Removed from "no tags" overview) 3) Removed tag using Caption/Tags sidebar. Observations 1) I think on removing the tags from Caption/Tags sidebar, the tags are just removed from the picture. "Actually" the tags are still present in the database. On running : SELECT * FROM TAGS; before and after assigning tags, tags remains in the table. But, SELECT * FROM IMAGETAGS; the tag is present before removal in the table. This implies the "Apply" after unchecking the specific tag works fine. 2) After removal of tag, the image doesn't appear in "No tags" overview. Also, I note that: -->Select Tags view from left -->Click on the tag you assigned from the tags tree. -->No image is visible for that tag. Also, image isn't visible if digiKam is restarted at neither of the two places. Yes, the wrong tags display comes from wrong values of the lft/rgt columns. They wrong values were created by deleting or moving tags. This bug will be fixed in digiKam-5.8.0. However, you have to start with a clean DB. I close this bug. Maik |