Bug 397425

Summary:	bug when trying find duplicates
Product:	[Applications] digikam	Reporter:	maderios <leoutation>
Component:	Maintenance-Similarities	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	metzpinguin
Priority:	NOR
Version First Reported In:	6.0.0
Target Milestone:	---
Platform:	Arch Linux
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:	6.0.0
Sentry Crash Report:

Description maderios 2018-08-13 16:15:47 UTC

Hi
Conditions:
DK 6 beta git rev d3dc7d3b8d482f3fd60c9797957dcca940b90f7f
Arch Aur system, Mysql db
Some bugs:
1) Each time  I want to find duplicates, DK ask updating fingerprints, even if nothing changes.
2) Normally, DK has to scan 2 main directories/collections, 1 and 2.
After updating fingerprints it doesnt find in subfolders  in directory 2 they are not displayed.
Same bug after using "maintenance" tool to update fingerprints
digikam.dbengine: Failure executing query:
 "SELECT M.imageid, M.matrix FROM ImageHaarMatrix AS M;"
Error messages: "QMYSQL: Unable to execute query" "No database selected" 1046 2

Comment 1 maderios 2018-08-13 18:08:20 UTC

-I activated "whole album collections
-I successfully unfolded directory 2 by clicking on it but then, nothing happens when I try to find duplicates
Message Example:
digikam.dbengine: Failure executing query:
 "SELECT matrix FROM ImageHaarMatrix WHERE imageid=6156"
Error messages: "QMYSQL: Unable to execute query" "No database selected" 1046 2
Bound values:  (QVariant(qlonglong, 6156))
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT matrix FROM ImageHaarMatrix WHERE imageid=?"
Error messages: "QMYSQL3: Unable to prepare statement" "No database selected" 1046 2
Bound values:  ()
digikam.dbengine: Failure executing query:
 "SELECT matrix FROM ImageHaarMatrix WHERE imageid=6159"
Error messages: "QMYSQL: Unable to execute query" "No database selected" 1046 2
Bound values:  (QVariant(qlonglong, 6159))
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT matrix FROM ImageHaarMatrix WHERE imageid=?"
Error messages: "QMYSQL3: Unable to prepare statement" "No database selected" 1046 2
Bound values:  ()
digikam.dbengine: Failure executing query:
 "SELECT matrix FROM ImageHaarMatrix WHERE imageid=6158"
Error messages: "QMYSQL: Unable to execute query" "No database selected" 1046 2
Bound values:  (QVariant(qlonglong, 6158))
digikam.general: Event is dispatched to desktop notifier through DBUS
digikam.general: One job is done
digikam.general: Cancel Main Thread
"No carrier"
"No carrier"

Comment 2 Maik Qualmann 2018-08-13 19:55:51 UTC

> Error messages: "QMYSQL: Unable to execute query" "No database selected"

The Similarity database is now independent. Check the default settings in the digiKam settings under Databases. The Similarity database can be created within the core database (like all other thumbnail or face databases).

Maik

Comment 3 maderios 2018-08-13 21:27:08 UTC

(In reply to Maik Qualmann from comment #2)
> > Error messages: "QMYSQL: Unable to execute query" "No database selected"
> 
> The Similarity database is now independent. Check the default settings in
> the digiKam settings under Databases. The Similarity database can be created
> within the core database (like all other thumbnail or face databases).
> 
> Maik

I remember now I add this database, sometimes ago, for other user.
Thanks, sorry for the noise...........................