https://bugs.kde.org/show_bug.cgi?id=375569
Bug ID: 375569
Summary: Wrong tags in tooltips
Product: digikam
Version: 5.4.0
Platform: openSUSE RPMs
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-de...@kde.org
Reporter: k...@forum.titlis.org
Target Milestone: ---
Created attachment 103649
--> https://bugs.kde.org/attachment.cgi?id=103649&action=edit
tooltip
when I hover over an image with many tags (including stacked tags), strange &
incomplete tag names are indicated on the tooltip. Please see attached
screenshot
On the screenshot, I see
- Leute/Flavia
- Leute/Kusi
- Flavia
- Kusi
- Maman
- Leute/Timea
The corresponding sql query
select Tags.name, Tags.id as TagId, pid as TagParentId from Images
join ImageTags on Images.id = ImageTags.imageid
join Tags on ImageTags.tagid = Tags.id
where
Images.name = "20161224T184451-D610-DSC_9616.JPG" AND
Images.album is not NULL;
returns
name name TagId TagParentId
20161224T184451-D610-DSC_9616.JPG Kusi 12 32
20161224T184451-D610-DSC_9616.JPG Celine Brun 101 401
20161224T184451-D610-DSC_9616.JPG Maman 103 102
20161224T184451-D610-DSC_9616.JPG Alessia 159 401
20161224T184451-D610-DSC_9616.JPG Color Label None 435 428
20161224T184451-D610-DSC_9616.JPG Pick Label None 445 428
20161224T184451-D610-DSC_9616.JPG Flavia 1'064 32
20161224T184451-D610-DSC_9616.JPG Timea 1'210 32
and select * from Tags where id in (32,401,102, 100) returns
id pid name icon iconkde lft rgt
32 0 Leute [NULL] [NULL] 1'030 1'631
100 32 Nathalie Famille [NULL] [NULL] 1'469 1'576
102 100 Papa [NULL] [NULL] 1'570 1'571
401 100 Stephane [NULL] [NULL] 1'528 1'531
It looks like the tooltip query doesn't handle multilevel (stacked) tags
correctly. The behavior in digikam is not consistent, this bug does not happen
with all stacked tags. For the example above, my db looks correct, though.
PS: for this query, are the lgt rgt columns needed?
--
You are receiving this mail because:
You are watching all bug changes.
