Bug 396765 - schema update to V 9 failed
Summary: schema update to V 9 failed
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Schema (show other bugs)
Version: 5.9.0
Platform: openSUSE Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-22 19:05 UTC by Stephan Schöttl
Modified: 2020-01-01 21:46 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.0.0


Attachments
dbconfig.xml (144.73 KB, application/xml)
2018-07-23 09:36 UTC, Maik Qualmann
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stephan Schöttl 2018-07-22 19:05:41 UTC
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
Comment 1 Maik Qualmann 2018-07-22 20:02:22 UTC
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 ***
Comment 2 Maik Qualmann 2018-07-23 09:36:49 UTC
Created attachment 114082 [details]
dbconfig.xml

Replace the dbconfig.xml under /usr/share/digikam/database/ with this one.

Maik
Comment 3 Stephan Schöttl 2018-07-25 20:06:17 UTC
Thanks a lot, it works with the attached dbconfig.xml. Sorry for the inconvenience-
Comment 4 caulier.gilles 2020-01-01 21:46:15 UTC
Not reproducible with 7.0.0 beta1.