[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 eberhard.morgenr...@eawag.ch changed: What|Removed |Added CC||eberhard.morgenroth@eawag.c ||h -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 Maik Qualmann changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |FIXED Version Fixed In||7.3.0 --- Comment #13 from Maik Qualmann --- Thanks for the feedback. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #12 from spam-recei...@web.de --- Thank you very much again for your immediate help! >From my point of view this issue can be closed. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #11 from Maik Qualmann --- No, we do not automatically start the rebuilding of the training database. However, this must be carried out. In the maintenance tool in the section for face recognition, activate the option for rebuilding the training database and start the maintenance tool. All confirmed faces are used automatically, a special album selection is not necessary. Do not forget to restart digiKam after successfully downloading the face model data. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #10 from spam-recei...@web.de --- Not related to this issue, but maybe you can tell me: Will the new face recognition function train itself from the faces which are already in the photos? Is there a maintenance funtion to generate training data from the existing faces? -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #9 from spam-recei...@web.de --- (In reply to Maik Qualmann from comment #8) > On MySQL Server PC: > > mysql -u USERNAME -p > > set global log_bin_trust_function_creators=1; > > Maik Hello Maik! Thank you very much for your immediate response. I checked this page if there are any security issues when the setting is changed: https://mariadb.com/docs/reference/mdb/system-variables/log_bin_trust_function_creators/ It says: Note that if ALL connections to this server ALWAYS use row-based binary logging, the security issues do not exist and the binary logging cannot break, so you can safely set this to TRUE Hence, I checked the server settings and confirmed that binlog runs in ROW mode. Now I changed the setting as you recommended and the schema upgrade passed, digikam started and requested the download of the face recognition data. GREAT! -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #8 from Maik Qualmann --- On MySQL Server PC: mysql -u USERNAME -p set global log_bin_trust_function_creators=1; Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #7 from spam-recei...@web.de --- (In reply to Maik Qualmann from comment #5) > A little more log file would not be bad. The problem is on the MySQL server > side and has to be fixed there. You don't have rights, probably to CREATE > and DROP TABLE VIEW. You don't always have these rights automatically. > > Maik I hope this helps: [10352] digikam.general: Loading DrMinGw run-time... [10352] digikam.general: DrMinGw run-time loaded. [10352] digikam.general: DrMinGw crash-file will be located at: "C:\\Users\\XXX\\AppData\\Local\\digikam_crash.log" [10352] digikam.widgets: Breeze icons resource file found [10352] digikam.widgets: Breeze-dark icons resource file found [10352] QCommandLineParser: already having an option named "?" [10352] QCommandLineParser: already having an option named "help-all" [10352] QCommandLineParser: already having an option named "v" [10352] digikam.general: Switch to widget style: "Fusion" [10352] digikam.general: AlbumWatch is disabled [10352] digikam.general: Database Parameters: [10352]Type: "QMYSQL" [10352]DB Core Name: "digikam" [10352]DB Thumbs Name: "digikam" [10352]DB Face Name: "digikam" [10352]DB Similarity Name: "digikam" [10352]Connect Options: "" [10352]Host Name:"XXX" [10352]Host port:3306 [10352]Internal Server: false [10352]Internal Server Path: "" [10352]Internal Server Serv Cmd: "" [10352]Internal Server Init Cmd: "" [10352]Username: "digikam" [10352]Password: "XXX" [10352] [10352] digikam.dbengine: Loading SQL code from config file "C:/Program Files/digiKam/data/digikam/database/dbconfig.xml" [10352] digikam.dbengine: Checking XML version ID => expected: 3 found: 3 [10352] digikam.coredb: Core database: running schema update [10352] digikam.coredb: Core database: have a structure version 10 [10352] digikam.coredb: Core database: makeUpdates 10 to 12 [10352] digikam.dbengine: Failure executing query: [10352] "" [10352] Error messages: "QMYSQL: Unable to execute query" "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" "1419" 2 [10352] Bound values: () [10352] digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV10ToV11" ] Statement [ "DROP TRIGGER IF EXISTS temp_insert_tagstree;" ] [10352] digikam.coredb: Core database: schema update to V 11 failed! [10352] digikam.coredb: Core database: cannot process schema initialization Do you need even more? -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #6 from Maik Qualmann --- http://www.mysqlab.net/knowledge/kb/detail/topic/error+messages/id/5746 Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #5 from Maik Qualmann --- A little more log file would not be bad. The problem is on the MySQL server side and has to be fixed there. You don't have rights, probably to CREATE and DROP TABLE VIEW. You don't always have these rights automatically. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #4 from spam-recei...@web.de --- (In reply to spam-receiver from comment #3) > (In reply to Maik Qualmann from comment #2) > > We need the DebugView Log at startup as described here: > > > > https://www.digikam.org/contribute/ > > > > Don't forget to set the debug variable. > > > > Maik > > The relevant line from th estartup log is this one: > [10352] Error messages: "QMYSQL: Unable to execute query" "You do not have > the SUPER privilege and binary logging is enabled (you *might* want to use > the less safe log_bin_trust_function_creators variable)" "1419" 2 The database user "digikam" has all privileges on the "digikam" database (except GRANT, of course), but globally only usage rights. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #3 from spam-recei...@web.de --- (In reply to Maik Qualmann from comment #2) > We need the DebugView Log at startup as described here: > > https://www.digikam.org/contribute/ > > Don't forget to set the debug variable. > > Maik The relevant line from th estartup log is this one: [10352] Error messages: "QMYSQL: Unable to execute query" "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" "1419" 2 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 caulier.gil...@gmail.com changed: What|Removed |Added Component|general |Database-Schema CC||caulier.gil...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 Maik Qualmann changed: What|Removed |Added Severity|critical|grave -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #2 from Maik Qualmann --- We need the DebugView Log at startup as described here: https://www.digikam.org/contribute/ Don't forget to set the debug variable. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 435065] After upgrade from digikam 7.1 to 7.2, digikam won't start
https://bugs.kde.org/show_bug.cgi?id=435065 --- Comment #1 from spam-recei...@web.de --- Created attachment 137134 --> https://bugs.kde.org/attachment.cgi?id=137134=edit Window in the background of the error message -- You are receiving this mail because: You are watching all bug changes.
