<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebApp v7.2.4-28">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Database conversion error starting digikam 5.1 trying to convert 4.14 database (MySQL external)</title>
</head>
<body>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">Hi, <br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;"><br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">I just wanted to use Digikam 5.1 with my external MySQL database from digikam version 4.14. While trying to convert the database from version 7 to 8 digikam 5.1 produces the following error:<br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;"><br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">digikam.dbengine: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"<br />digikam.dbengine: Checking XML version ID => expected: 3 found: 3<br />digikam.coredb: Core database: running schema update<br />digikam.coredb: Core database: have a structure version 7<br />digikam.coredb: Core database: makeUpdates 7 to 8<br />digikam.dbengine: Failure executing query:<br /> "" <br />Error messages: "QMYSQL: Die Abfrage konnte nicht ausgeführt werden" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`#sql-47e_f03`, CONSTRAINT `Images_Albums` FOREIGN KEY (`album`) REFERENCES `Albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" 1452 2 <br />Bound values: ()<br />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;" ]<br />digikam.coredb: Core database: schema update to V 8 failed!<br />digikam.coredb: Core database: cannot process schema initialization<br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;"><br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">Has anyone a clue what I can do to get the database converted?<br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;"><br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">Thanks<br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;">Marco<br /></span></p>
<p style="padding: 0; margin: 0;"><span style="font-size: 10pt; font-family: courier new;"><br /></span></p>
</body>
</html>