https://bugs.kde.org/show_bug.cgi?id=520394
--- Comment #12 from Robin <[email protected]> --- (In reply to Maik Qualmann from comment #10) > Based on the log, it is clear why the tag is not disappearing: it is due to > an SQL error message. > However, we never created tables named "imagetagproperties" and "tags" with > this specific case sensitivity. > Have you modified this internal MySQL database in any way? > > digikam.dbengine: Failure executing query: > "DELETE FROM Tags WHERE id=?;" > Error messages: "QMYSQL: Unable to execute statement" "Cannot delete or > update a parent row: a foreign key constraint fails > (`digikam`.`imagetagproperties`, CONSTRAINT `ImageTagProperties_Tags` > FOREIGN KEY (`tagid`) REFERENCES `tags` (`id`) ON DELETE CASCADE ON UPDATE > CASCADE)" "1451" 2 > > Maik Hi again! If I create a new tag, it survives the digikam restart. If I delete it, then it survives the digikam restart. I have been trying to connect to mariadb, but I am using Windows, so the documentation https://docs.digikam.org/en/setup_application/database_settings.html does not help and I can't connect or perform a mysqldump --no-data to see what the database looks like. Do you know how to do this? I am hoping that if I compare it to what is in https://invent.kde.org/graphics/digikam/-/blob/master/core/data/database/dbconfig.xml.cmake.in?ref_type=heads that maybe I can find something. I have no idea how this was changed but I would really like to try to fix it! -- You are receiving this mail because: You are watching all bug changes.
