https://bugs.kde.org/show_bug.cgi?id=396944
Bug ID: 396944 Summary: Integrity constraint violation on Albums.icons when migrating from sqlite to mysql Product: digikam Version: 5.9.0 Platform: Other OS: Linux Status: UNCONFIRMED Severity: normal Priority: NOR Component: Database-Migration Assignee: digikam-bugs-n...@kde.org Reporter: erme...@gmail.com Target Milestone: --- Dear all, When migrating from sqlite to mysql, I got an unexpected error during the migration process: Error while converting the database. Details: Cannot add or update a child row: a foreign key constraint fails (`digikam`.`Albums`, CONSTRAINT `Albums_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET NULL ON UPDATE CASCADE) I've been able to fix it when editing my sqlite database (setting null on each album image id) but it seems that there is a workaround on the image used as album cover. Regards -- You are receiving this mail because: You are watching all bug changes.