[Digikam-devel] [digikam] [Bug 355831] MySQL Schema Improvements

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=355831

--- Comment #27 from caulier.gilles at gmail.com ---
Richard,

I start to test step by step all pending patches.

> For patch : Remove trigger dependency for MySQL.
==> the patch do not touch the dbsettingswidget.cpp code where SQL requirements
is given to previously create the databases in remote Mysql server by the
system admin.
==> This give a lots of error on the console when i use Mysql internal server
(i don't yet tested Mysql remote server yet). Note that Mysql Internal server
use "digikam" database name for all database (Core, Thumbs, Face). Look errors
below :

digikam.dbengine: Failure executing query:
 "UPDATE Tags SET icon=? WHERE id=?;" 
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`Tags`, CONSTRAINT
`Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)" 1452 2 
Bound values:  (QVariant(qlonglong, 0), QVariant(int, 1))
digikam.dbengine: Failure executing query:
 "UPDATE Tags SET icon=? WHERE id=?;" 
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`Tags`, CONSTRAINT
`Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)" 1452 2 
Bound values:  (QVariant(qlonglong, 0), QVariant(int, 2))
digikam.dbengine: Failure executing query:
 "UPDATE Tags SET icon=? WHERE id=?;" 
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`Tags`, CONSTRAINT
`Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)" 1452 2 
Bound values:  (QVariant(qlonglong, 0), QVariant(int, 3))
digikam.dbengine: Failure executing query:
 "UPDATE Tags SET icon=? WHERE id=?;" 
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`Tags`, CONSTRAINT
`Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)" 1452 2 
Bound values:  (QVariant(qlonglong, 0), QVariant(int, 4))
digikam.dbengine: Failure executing query:
 "UPDATE Tags SET icon=? WHERE id=?;" 
Error messages: "QMYSQL3: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`Tags`, CONSTRAINT
`Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET
NULL ON UPDATE CASCADE)" 1452 2 
Bound values:  (QVariant(qlonglong, 0), QVariant(int, 5))
...

and more...

> For patch : Defer migration of Albums.icon until after the Images table has been migrated

==> sound like it need the previous patch to be applied. the patch is rejected.
Did you confirm ?

> For patch : Move Thumbnail database Settings to ThumbSettings for MySQL

==> We need the same solution for Face database which also create a Settings
table.
==> sound like it need the previous patch to be applied. the patch is rejected.
Did you confirm ?
==> After renaming Thumb and Face DB Settings tables, this will fix bug #331628
? At least, as you specify InnoDB database engine, TokuDB engine will be not
possible to use instead. Right ?

Gilles

-- 
You are receiving this mail because:
You are the assignee for the bug.