Starting ~> ./digikam-5.8.0-20171217T160920-x86-64.appimage tries to update mariadb database schema from version 8 to version 9. I am running this on OpenSUSE Thumbleweed. Error message below. -- digiKam AppImage Bundle -- Use 'help' as CLI argument to know all available options digikam.widgets: Breeze icons ressource file found digikam.general: AlbumWatch use QFileSystemWatcher digikam.general: Database Parameters: Type: "QMYSQL" DB Core Name: "digikam" DB Thumbs Name: "digikam" DB Face Name: "digikam" Connect Options: "UNIX_SOCKET=/run/mysql/mysql.sock" Host Name: "localhost" Host port: 3306 Internal Server: false Internal Server Path: "" Internal Server Serv Cmd: "" Internal Server Init Cmd: "" Username: "digikam" Password: "XXXXXXXXXXXXXXXXXXXX" digikam.dbengine: Loading SQL code from config file "/tmp/.mount_69FrTt/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" "Cannot delete rows from table which is parent in a foreign key constraint 'Images_Albums' of table 'Images'" 1834 2 Bound values: () digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV8ToV9" ] Statement [ "ALTER TABLE Albums CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;" ] digikam.coredb: Core database: schema update to V 9 failed! digikam.coredb: Core database: cannot process schema initialization KMemoryInfo: Platform identified : "LINUX" KMemoryInfo: TotalRam: 16765005824 digikam.general: Allowing a cache size of 200 MB QThreadStorage: Thread 0x7f20ce1efb80 exited after QThreadStorage 11 destroyed
Git commit 2809d4c44f82e6bebbf1ed6eba3d23df571549d1 by Maik Qualmann. Committed on 21/12/2017 at 21:14. Pushed by mqualmann into branch 'master'. disable for update v8 to v9 temporarily the foreign key check FIXED-IN: 5.8.0 M +2 -1 NEWS M +2 -0 data/database/dbconfig.xml.cmake.in https://commits.kde.org/digikam/2809d4c44f82e6bebbf1ed6eba3d23df571549d1
Notes: Your database is probably not consistent. After the update, it is best to use the migration tool to copy your old database into a newly created database. Maik