Bug 397425 - bug when trying find duplicates
Summary: bug when trying find duplicates
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Maintenance-Similarities (show other bugs)
Version: 6.0.0
Platform: Arch Linux Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-13 16:15 UTC by maderios
Modified: 2018-08-27 19:30 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 6.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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...........................