https://bugs.kde.org/show_bug.cgi?id=467766
Bug ID: 467766
Summary: QMYSQL3: Unable to execute statement" "Cannot add or
update a child row: a foreign key constraint fails
(`digikam`.`ImageTagProperties`, CONSTRAINT
`ImageTagProperties_Images` FOREIGN KEY (`imageid`)
REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE
Classification: Applications
Product: digikam
Version: 8.0.0
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Engine
Assignee: digikam-bugs-n...@kde.org
Reporter: pschonm...@gmail.com
Target Milestone: ---
SUMMARY
***
Ive got error in UPDATE/DELETE to DB when tagging people.
QMYSQL3: Unable to execute statement" "Cannot add or update a child row: a
foreign key constraint fails (`digikam`.`ImageTagProperties`, CONSTRAINT
`ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`)
ON DELETE CASCADE ON UPDATE CASCADE)" "1452" 2
***
STEPS TO REPRODUCE
1. Go to people
2. Choose some person. Look at unconfirmed section. When you see somebody thats
not belong face to this selected person write name into small input field to
tag face to right person
3. In debuglog see some complaints about INSERT/DELETE
4. But person has right tags in picture
EXPECTED RESULT
Logs without complaints about failure :)
SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Mint 21.1
(available in About System)
KDE Frameworks Version: 5.92.0
Qt Version: 5.15.3
ADDITIONAL INFORMATION
MySQL is on Synology, some MariaDB 10.x - probably latest mariadb package from
synology
--
You are receiving this mail because:
You are watching all bug changes.
