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.
