https://bugs.kde.org/show_bug.cgi?id=497151
--- Comment #3 from Petr Schonmann <pschonm...@gmail.com> --- Tried mysql> select * from FaceSettings; +-----------------------+-------+ | keyword | value | +-----------------------+-------+ | DBFaceVersion | 4 | | DBFaceVersionRequired | 4 | +-----------------------+-------+ 2 rows in set (0.00 sec) mysql> update FaceSettings value=2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=2' at line 1 mysql> update FaceSettings set value=2; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> select * from FaceSettings; +-----------------------+-------+ | keyword | value | +-----------------------+-------+ | DBFaceVersion | 2 | | DBFaceVersionRequired | 2 | +-----------------------+-------+ but this give me another error :) and nothing is reindexed 2024-12-07 11:25:24.150794 Digikam::FaceDb::setting: FaceDB SelectFaceSetting val ret = 0 2024-12-07 11:25:24.152026 Digikam::FaceDb::setting: FaceDB SelectFaceSetting val ret = 0 2024-12-07 11:25:24.152078 Digikam::FaceDbSchemaUpdater::startUpdates: Face database: have a structure version "2" 2024-12-07 11:25:24.245016 Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing query: 2024-12-07 11:25:24.245231 "" 2024-12-07 11:25:24.245266 Error messages: "QMYSQL: Unable to execute query" "BLOB/TEXT column 'removeHash' used in key specification without a key length" "1170" 2 2024-12-07 11:25:24.245302 Bound values: QList() 2024-12-07 11:25:24.254798 Digikam::BdEngineBackend::execDBAction: Error while executing DBAction [ "IndexFaceDBFaceMatrices_removeHash_V5" ] Statement [ "CREATE INDEX idx_FaceMatricesHash \n ON FaceMatrices(removeHash);\n " ] 2024-12-07 11:25:24.255402 Digikam::FaceDbSchemaUpdater::updateV2ToV5: fail to create FaceMatrices index 2024-12-07 11:25:24.257156 Digikam::FacialRecognitionWrapper::Private::Private: Face database ready for use Is it posible to send me db query to execute if previous was wrong ? -- You are receiving this mail because: You are watching all bug changes.
