[Koha-bugs] [Bug 13191] Null borrowernumber in reserves table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13191

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |katrin.fischer at bsz-bw.de
         Resolution|---                         |WONTFIX

--- Comment #2 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
This was reported against a very old and now unmaintained version of Koha -
3.16. I am closing WONTFIX - please reopen if you can still see this happening
in a more current version.

NULL borrowernumbers in old_reserves can happen when deleting a patron:
CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES
`borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,

In reserves the line should be deleted:
 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.