Bug 396734 - Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ] Statement [ "DROP TRIGGER IF EXISTS delete_image;" ]
Summary: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ] Statement [ "DROP...
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: unspecified
Platform: openSUSE Linux
: NOR crash
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-21 16:08 UTC by phil.tdm
Modified: 2020-01-01 21:37 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description phil.tdm 2018-07-21 16:08:15 UTC
########:~> digikam 
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
   Type:                     "QMYSQL"
   DB Core Name:             "digikam"
   DB Thumbs Name:           "thumbnails_digikam"
   DB Face Name:             "face_digikam"
   Connect Options:          ""
   Host Name:                "192.168.0.24"
   Host port:                3306
   Internal Server:          false
   Internal Server Path:     ""
   Internal Server Serv Cmd: ""
   Internal Server Init Cmd: ""
   Username:                 "digikam"
   Password:                 "XXXXXXXXX"

digikam.dbengine: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected:  3  found:  3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: have a structure version  8
digikam.coredb: Core database: makeUpdates  8  to  9
digikam.dbengine: Failure executing query:
 "" 
Error messages: "QMYSQL: Impossible d'exécuter la requête" "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 
Bound values:  ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ] Statement [ "DROP TRIGGER IF EXISTS delete_image;" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
Comment 1 phil.tdm 2018-07-21 16:22:27 UTC
Version base :
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Comment 2 Maik Qualmann 2018-07-22 07:33:27 UTC

*** This bug has been marked as a duplicate of bug 388867 ***
Comment 3 caulier.gilles 2020-01-01 21:37:49 UTC
Not reproducible with 7.0.0 beta1.