https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13535
--- Comment #2 from Katrin Fischer <[email protected]> --- Created attachment 103039 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=103039&action=edit 32# Attachment to Bug 13535 - Table alert is missing FK and not deleted with the patron Bug 13535: Add FK constraint on borrowrnumber to alert table When a patron is deleted, we should clean up the data connected to the patron. This includes subscriptions to 'new issue arrived' arrive messages from the serials module. To test: Part1: - Apply patch - Run updatedatabase - verify no error message - Run updatedatabase again - verify still no error message - Add a subscription and select a notice template for patron notification - Log in as any patron (not yourself) and subscribe to the email alert in the OPAC - Veriy on the subscription detail page, that the patron is subscribed in staff - Note borrowernumber and delete patron - SELECT * from alert; in a report - There should no longer be an entry with the borrowernumber Part 2: - Start fresh with the web installer, verify there are no errors on creating the database tables -- 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/
