[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-25 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #6 from Maik Qualmann --- Can you run SQL commands? here is an example of what is needed: mysql -u USERNAME -h 192.168.xxx.xxx -p (Enter password) USE digikam;(or your digiKam core database name) SELECT * FROM Images WHERE id = 0;

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread bugzilla_noreply
https://bugs.kde.org/show_bug.cgi?id=467766 caulier.gil...@gmail.com changed: What|Removed |Added Component|Database-Engine |Database-Mysql

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #5 from Petr Schonmann --- No, ive mysql db from begins. -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #4 from Maik Qualmann --- mysqlcheck cannot detect such an error. An attempt is made to use an imageid with 0 (QVariant(qlonglong, 0)), this can never happen in the worst case. Have you performed a migration from SQLite to MySQL? Maik --

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #3 from Petr Schonmann --- Created attachment 157557 --> https://bugs.kde.org/attachment.cgi?id=157557=edit error log -- You are receiving this mail because: You are watching all bug changes.

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread Petr Schonmann
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #2 from Petr Schonmann --- Nope, DB seems to be fine. -- root@nas:/usr/local/mariadb10/bin# ./mysqlcheck -A digikam.AlbumRoots OK digikam.Albums OK

[digikam] [Bug 467766] QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT `ImageTagProperties_Images` F

2023-03-24 Thread Maik Qualmann
https://bugs.kde.org/show_bug.cgi?id=467766 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #1 from Maik