[Digikam-devel] [digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam

[via KDE Bugzilla]

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

--- Comment #14 from uwe.haider at gmx.net ---
That's it: max-allowed-packet was 4096. I set it to 16.777.216 ->
facerecognition works first time ever :-))

But some error messages are still on:

digikam.general: Allowing a cache size of 200 MB
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT value FROM ThumbSettings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.ThumbSettings' doesn't exist" 1146 2 
Bound values:  ()
digikam.dbengine: Failure executing query:
 "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersion';" 
Error messages: "QMYSQL: Unable to execute query" "Table
'digikam.ThumbSettings' doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBThumbnailsVersion"))
digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ]
Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ]
digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret =  1
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT value FROM ThumbSettings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.ThumbSettings' doesn't exist" 1146 2 
Bound values:  ()
digikam.dbengine: Failure executing query:
 "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersionRequired';" 
Error messages: "QMYSQL: Unable to execute query" "Table
'digikam.ThumbSettings' doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBThumbnailsVersionRequired"))
digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ]
Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ]

How can I fix this? Can I set up the tables via phpmyadmin? Is there a doku for
the db-structure? And how can I fill this hand made tables?

I will test the other functions of maintenance separatly an give feedback....

uhai

-- 
You are receiving this mail because:
You are the assignee for the bug.