https://bugs.kde.org/show_bug.cgi?id=379987
--- Comment #15 from Quincy <bbc.qui...@gmx.de> --- Current AppImage Version (including your fixes) happily upgrade DB Version 8->9. Upgrade of a restored V7 DB to 8 (and then 9) first fails with: digikam.dbengine: Failure executing query: Error messages: "QMYSQL: Unable to execute query" "Cannot add or update a child row: a foreign key constraint fails (`digikam-appimage-core`.`#sql-948_247`, CONSTRAINT `ImageMetadata_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" 1452 2 Bound values: () digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ] Statement [ "ALTER TABLE ImageMetadata ADD CONSTRAINT ImageMetadata_Images FOREIGN KEY (imageid) REFERENCES Images (id) ON DELETE CASCADE ON UPDATE CASCADE, ENGINE InnoDB;" ] digikam.coredb: Core database: schema update to V 8 failed! This is the issue I mentioned earlier with orphaned entries in (my) ImageMetadata which I could solve by hand (just included here for reference of the error message). After removal of these entries, there are some complaints after the update process about thumbnails.ThumbSettings not being present: digikam.dbengine: Loading SQL code from config file "/run/firejail/appimage/.appimage-5447/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 7 digikam.coredb: Core database: makeUpdates 7 to 9 digikam.coredb: Core database: success updating to version 8 digikam.coredb: Core database: success updating to version 8 digikam.coredb: Core database: success updating to version 9 digikam.coredb: Core database: success updating to version 9 ..snip.. digikam.dbengine: Prepare failed! digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword=?;" Error messages: "QMYSQL3: Unable to prepare statement" "Table 'digikam-appimage-thumbnails.ThumbSettings' doesn't exist" 1146 2 Bound values: () digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersion';" Error messages: "QMYSQL: Unable to execute query" "Table 'digikam-appimage-thumbnails.ThumbSettings' doesn't exist" 1146 2 Bound values: (QVariant(QString, "DBThumbnailsVersion")) digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ] Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret = 1 digikam.dbengine: Prepare failed! digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword=?;" Error messages: "QMYSQL3: Unable to prepare statement" "Table 'digikam-appimage-thumbnails.ThumbSettings' doesn't exist" 1146 2 Bound values: () digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersionRequired';" Error messages: "QMYSQL: Unable to execute query" "Table 'digikam-appimage-thumbnails.ThumbSettings' doesn't exist" 1146 2 Bound values: (QVariant(QString, "DBThumbnailsVersionRequired")) digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ] Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret = 1 digikam.thumbsdb: Thumbs database: have a structure version "" digikam.thumbsdb: ThumbDB SelectThumbnailLegacySetting val ret = 0 digikam.thumbsdb: ThumbDB SelectThumbnailLegacySetting val ret = 0 digikam.general: Thumbnails database ready for use This was true in the original ThumbsDB before the update (V2: named "Settings" there), but it is renamed during the update process V2->V3 (visible in the table and dbconfig.xml, but not on console). Therefore these errors do not show up on a second start of digikam, but I was wondering why they show up right after the update run. So just a minor glitch, which I would not even have recognized when not watching console output... Many thanks for your efforts resolving this! -- You are receiving this mail because: You are watching all bug changes.
