After upgrading the digikam rpm package from OpenSuse Leap 42.3 to OpenSuse Leap 15.0 with digikam-5.9.0-lp150.1.3.x86_64 rpm package, digikam tries to convert the MySQL dackend database from schema version 8 to schema version 9 and fails. The error messages are: digikam.general: AlbumWatch use QFileSystemWatcher digikam.general: Database Parameters: Type: "QMYSQL" DB Core Name: "digikam_metadata" DB Thumbs Name: "digikam_thumbnails" DB Face Name: "" Connect Options: "" Host Name: "localhost" Host port: 3306 Internal Server: false Internal Server Path: "" Internal Server Serv Cmd: "" Internal Server Init Cmd: "" Username: "digikam_user" Password: "XXXXXXXXXXXXXX" 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: Unable to execute query" "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='" 1267 2 Bound values: () digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ] Statement [ "CALL drop_index_if_exists('AlbumRoots', 'identifier');" ] digikam.coredb: Core database: schema update to V 9 failed! digikam.coredb: Core database: cannot process schema initialization
Tomorrow I will upload a customized dbconfig.xml with the patch for digiKam-5.9.0 from bug 393855 here. Maik *** This bug has been marked as a duplicate of bug 393855 ***
Created attachment 114082 [details] dbconfig.xml Replace the dbconfig.xml under /usr/share/digikam/database/ with this one. Maik
Thanks a lot, it works with the attached dbconfig.xml. Sorry for the inconvenience-
Not reproducible with 7.0.0 beta1.