Bug 425100

Summary: No photos show up when selecting a face tag in "People" panel
Product: [Applications] digikam Reporter: spam-receiver
Component: Faces-WorkflowAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version: 7.0.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed In: 7.1.0
Sentry Crash Report:
Attachments: Meaningless popup when selecting an entry in "People" panel

Description spam-receiver 2020-08-07 09:07:04 UTC
Created attachment 130703 [details]
Meaningless popup when selecting an entry in "People" panel

SUMMARY
I have a collection of more than 60,000 photos. Many photos hae face tags created by Picasa, and some have face tags created by other programs.
I have a freshly installed Digikam 7.0.0 (on Windows), and scanned the photos to a new (emplty) database.
The "People" panel of Digikam is populated with the names of the face tags. Next to the tags, the number of associated photos is displayed in brackets.

When I click on a name in "People" panel, no photos will be displayed in the preview area.
Instead a small, meaningless popup appears in the lower right corner, see attachment.

STEPS TO REPRODUCE
1. Freshly install Digikam 7.0.0 on Windows
2. Create a new, empty database
3. Scan photo collection with Picasa faces and other faces
4. Click on an item in "People" panel

OBSERVED RESULT
"People" panel is populated as expected.
No photos are displayed in the main view of Digikam.
Instead, a smll popup appears in the lower right corner.

EXPECTED RESULT
"People" panel is populated as expected.
Photos containing the selected faces are displayed in the main view of Digikam.

SOFTWARE/OS VERSIONS
Windows: Win10, latest patch level
KDE Frameworks 5.70.0
Qt 5.14.2 (kompiliert gegen 5.14.2)
Das windows Fenstersystem

ADDITIONAL INFORMATION
In an earlier version of Digikam, I had only the faces displayed, not the full photos when I selected an entry of the "People" panel. This has changes at some point in time. I don't know how Digikam 7 is supposed to behave (Picasa shows only the faces, not the full photo).
Comment 1 Maik Qualmann 2020-08-07 09:35:13 UTC
Database ist MySQL?

Maik
Comment 2 spam-receiver 2020-08-07 09:47:03 UTC
(In reply to Maik Qualmann from comment #1)
> Database ist MySQL?

Yes, it's MariaDB on a different machine.
Comment 3 Maik Qualmann 2020-08-07 09:58:34 UTC
As a workaround until a new pre-release digiKam-7.1.0 is available:
Please deactivate View-> Include Tag Sub-Tree

Maik

*** This bug has been marked as a duplicate of bug 424691 ***
Comment 4 spam-receiver 2020-08-07 11:43:51 UTC
(In reply to Maik Qualmann from comment #3)
> As a workaround until a new pre-release digiKam-7.1.0 is available:
> Please deactivate View-> Include Tag Sub-Tree
> 

Thank you very much. The workaround works for me.
Looking forward to 7.1.0.
Comment 5 Maik Qualmann 2020-08-09 10:17:32 UTC
The "TagsTree" table is a VIEW table under MySQL. The main cause of this problem is that the user of the database probably does not have the SHOW VIEW and CREATE VIEW privileges. If you have not assigned all the privileges, these must be added separately. Since this problem also affects other SQL queries, the privileges must be set correctly.

Maik