| Summary: | Face Recognition does not produce any results | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Brian Werner <bwerner0919> |
| Component: | Faces-Recognition | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | bwerner0919, caulier.gilles, metzpinguin |
| Priority: | NOR | ||
| Version First Reported In: | 8.8.0 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed/Implemented In: | 8.8.0 | |
| Sentry Crash Report: | |||
| Attachments: | debug-output | ||
|
Description
Brian Werner
2025-08-11 17:38:13 UTC
I suspect a corrupted face database. We only test with current MariaDB versions, which is why MySQL and an older MariaDB version crashed in digKam-8.7.0 due to unsupported SQL syntax and an unhandled exception. Please create a DebugView log from startup to face recognition, as described here for Windows: https://www.digikam.org/contribute/#windows-host Maik Created attachment 183962 [details]
debug-output
Yes, your face database is broken. I suspect you removed the MySQL configuration from the log. You need to delete the face database; it will be recreated the next time you restart. If you only created a shared database, I'll write the tables you need to delete. There's nothing we can do here. [35504] digikam.facedb: DBFaceVersion not available! Giving up schema upgrading. [35504] digikam.facesengine: IdentityProvider::initialize() failed! Maik I removed the faces DB, however it did not recreate anything. Same results. I have removed all MySQL DB's, removed the application completely, and cleaned up. Removed mySQL, Deployed MariaDB, and re-installed 8.7 stable release. I am now able to execute the face scanning, and face recognition as expected. The 8.7 documentation calls out mySQL works, however it definitely does not, and MariaDB is the solution. MySQL should still work for an external database, a DebugView log would be good so we can adapt the problem for MySQL. Maik Git commit a14dc4373a664e406cc4dc3d5732826ffb1abbc6 by Maik Qualmann. Committed on 15/08/2025 at 10:36. Pushed by mqualmann into branch 'master'. fix creating FaceMatrices table with MySQL M +6 -3 core/data/database/dbconfig.xml.cmake.in https://invent.kde.org/graphics/digikam/-/commit/a14dc4373a664e406cc4dc3d5732826ffb1abbc6 @Brian, The digiKam 8.8.0 pre-release Windows installer will be updated from Qt framework 6.8.3 to 6.9.0 in one hour. The file will be available soon at this place: https://files.kde.org/digikam/ Please test give us a feedback to see if the dysfunction still reproducible. Thanks in advance Gilles Caulier Git commit 377c0cc6b2d2bcbec459f9929f9d0bc9644e3e12 by Maik Qualmann. Committed on 18/08/2025 at 10:30. Pushed by mqualmann into branch 'master'. fix creating FaceMatrices table with MySQL #2 M +3 -5 core/data/database/dbconfig.xml.cmake.in https://invent.kde.org/graphics/digikam/-/commit/377c0cc6b2d2bcbec459f9929f9d0bc9644e3e12 digiKam now works again with an external Oracle MySQL database. Maik |