https://bugs.kde.org/show_bug.cgi?id=384492
Marcel Derioss <mader...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mader...@gmail.com
--- Comment #2 from Marcel Derioss <mader...@gmail.com> ---
(In reply to Mattia from comment #0)
> I'm trying to migrate my Digikam DB from SQLite to an external MySQL server
> (MariaDB 5.5.44 running on Qnap NAS).
>
> The process fails at 91% of "Copy ImageInformation" step with the error
> "Cannot add or update a child row: a foreign key constraint fails
> (`digikam`.`ImageInformation`, CONSTRAINT `ImageInformation_Images` FOREIGN
> KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE
> CASCADE)"
I got today same fail message with database migration tool sqlite -> mysql
external server:
'Details: Cannot add or update a child row: a foreign key constraint fails
(`mydk`.`ImageInformation`, CONSTRAINT `ImageInformation_Images` FOREIGN KEY
(`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)'
Conditions: DK-5.7 Archlinux x86_64 Mariadb-10.1.28-1
DK works fine with sqlite.
--
You are receiving this mail because:
You are watching all bug changes.
