[Koha-bugs] [Bug 13535] Table alert is missing FK and not deleted with the patron
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Apr 16 00:07:21 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13535
--- Comment #2 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
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.
More information about the Koha-bugs
mailing list