https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42068
Paul Derscheid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #195132|0 |1 is obsolete| | --- Comment #8 from Paul Derscheid <[email protected]> --- Created attachment 195136 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=195136&action=edit Bug 42068: Bug 26993 (follow-up) Don't use FOREIGN_KEY_CHECKS To test: 1 - Checkout 25.11.x - reset_all 2 - Enable StoreLastBorrower 3 - Issue an item 4 - Ensure item has a row in items_last_borrower SELECT * FROM items_last_borrower 5 - Checkout main 6 - updatedatabase 7 - Try to delete any item, doesn't have to be the one you issued DELETE FROM items WHERE itemnumber=93; 8 - ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`koha_kohadev`.`items_last_borrower`, CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE) 9 - repeat 1-5 10 - APPLY PATCH 11 - updatedatabase 12 - Try to delete any item 13 - Success! 14 - Delete the item you issued previously (in the staff interface on via mysql) 15 - Confirm no rows in items_last_borrower Signed-off-by: Lucas Gass <[email protected]> Signed-off-by: Paul Derscheid <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
