[digikam] [Bug 397425] New: bug with finding duplicates

[maderios]

https://bugs.kde.org/show_bug.cgi?id=397425

Bug ID: 397425
Summary: bug with finding duplicates
Product: digikam
Version: 6.0.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Maintenance-Similarities
Assignee: digikam-bugs-***@kde.org
Reporter: ***@gmx.fr
Target Milestone: ---

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

[maderios]

https://bugs.kde.org/show_bug.cgi?id=397425

--- Comment #1 from maderios <***@gmx.fr> ---
-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"

[maderios]

https://bugs.kde.org/show_bug.cgi?id=397425

maderios <***@gmx.fr> changed:

What |Removed |Added
----------------------------------------------------------------------------
Platform|Other |Archlinux Packages

[maderios]

https://bugs.kde.org/show_bug.cgi?id=397425

maderios <***@gmx.fr> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|bug with finding duplicates |bug when trying find
| |duplicates

[Maik Qualmann]

https://bugs.kde.org/show_bug.cgi?id=397425

Maik Qualmann <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------

Post by maderios
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

[maderios]

https://bugs.kde.org/show_bug.cgi?id=397425

--- Comment #3 from maderios <***@gmx.fr> ---
(In reply to Maik Qualmann from comment #2)

Post by Maik Qualmann

Post by maderios
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...........................

[Maik Qualmann]

https://bugs.kde.org/show_bug.cgi?id=397425

Maik Qualmann <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Version Fixed In| |6.0.0
Resolution|--- |FIXED