[digikam] [Bug 373605] New: Failed to update database schema from version 7 to version 8

[anttia]

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-devel at kde.org
          Reporter: aahonen at 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 the assignee for the bug.