https://bugs.kde.org/show_bug.cgi?id=373605
Bug ID: 373605 Summary: Failed to update database schema from version 7 to version 8 Product: digikam Version: 5.3.0 Platform: Kubuntu Packages OS: Linux Status: UNCONFIRMED Severity: critical Priority: NOR Component: Database-Mysql Assignee: digikam-de...@kde.org Reporter: aaho...@gmail.com Target Milestone: --- Hi. I tried to install Digikam 5.3. I started it,configured to use the mysql database I have on my network drive and after some time it gave me this error: Error messages: "QMYSQL: Unable to execute query" "Cannot add or update a child row: a foreign key constraint fails (`digikamfi/#sql-12a1_bff8`, CONSTRAINT `Images_Albums` FOREIGN KEY (`album`) REFERENCES `Albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" 1452 2 Bound values: () digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ] Statement [ "ALTER TABLE Images\n ADD CONSTRAINT Images_Albums FOREIGN KEY (album) REFERENCES Albums (id) ON DELETE CASCADE ON UPDATE CASCADE,\n ADD UNIQUE (album, name(255)),\n ENGINE InnoDB;" ] digikam.coredb: Core database: schema update to V 8 failed! digikam.coredb: Core database: cannot process schema initialization -- You are receiving this mail because: You are watching all bug changes.