[Koha-bugs] [Bug 41246] Deleting patron categories or libraries can leave orphaned rules in the overduerules table

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41246 --- Comment #10 from Lucas Gass (lukeg) <lucas@bywatersolutions.com> --- Created attachment 200030 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200030&action=edit Bug 41246: Add foreign key constraints to overduerules table and cascade on delete To test: 0. APPLY PATCH, updatedatabase, restart_all 1. Add or have a patron category. 2. Go to Tools > Overdue notice/status triggers 3. Set some rules for that category. 4. Delete the patron category 5. Now do "select distinct categorycode from overduerules;" 6. All rules should be gone. -- You are receiving this mail because: You are watching all bug changes.