January 2023 - Koha-bugs - lists.koha-community.org

[Bug 7812] Add markup to staff interface templates to increase customization options
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7812 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add markup to staff client |Add markup to staff |templates to increase |interface templates to |customization options |increase customization | |options -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 7811] borrowers.borrowernumber should be a foreign key for 8 tables
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7811 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |MOVED --- Comment #5 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- >alert.borrowernumber (with ON DELETE CASCADE) CONSTRAINT `alert_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE >statistics.borrowernumber (with ON DELETE SET NULL) I think this could be debatable. I am pretty sure libraries look-up in deletedborrowers for statistical reports regularly and this is a statistics table. I consider it WONTFIX. >messages.borrowernumber (with ON DELETE SET NULL) CONSTRAINT `messages_borrowernumber` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, I believe the ON DELETE CASCADE is correct, you don't want to keep those messages without the patrons as they might contain sensitive information. >reserveconstraints.borrowernumber (with ON DELETE CASCADE) Table no longer exists. >reviews.borrowernumber (with ON DELETE CASCADE) CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, I believe the ON DELETE SET NULL is what most libraries would want. >saved_sql.borrowernumber (with ON DELETE SET NULL) NOT FIXED, but already filed separately and stuck in discussion: Bug 13668 - Creator of an SQL report shoudl be NULL when the staff patron is deleted >search_history.borrowernumber (with ON DELETE CASCADE) -the borrowernumber field is called userid atm, see below- NOT FIXED Now filed separately: Bug 32590 - Add FK constraint for search_history.userid >suggestions.suggestedby, suggestion.managedby, acceptedby, rejectedby (with ON DELETE SET NULL) CONSTRAINT `suggestions_ibfk_managedby` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `suggestions_ibfk_rejectedby` FOREIGN KEY (`rejectedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `suggestions_ibfk_suggestedby` FOREIGN KEY (`suggestedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE CONSTRAINT `suggestions_ibfk_acceptedby` FOREIGN KEY (`acceptedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 5334] Omnibus: Add explicit foreign key constraints
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5334 Bug 5334 depends on bug 7811, which changed state. Bug 7811 Summary: borrowers.borrowernumber should be a foreign key for 8 tables https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7811 What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |MOVED -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 32590] New: Add FK constraint for search_history.userid
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32590 Bug ID: 32590 Summary: Add FK constraint for search_history.userid Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Make sure that when the patron is deleted, the userid (borrowernumber) is either set to NULL or the entries be deleted in search_history. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 7754] Displaying the number of days an item is late on checkin
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7754 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |Academy --- Comment #4 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- This would still be quite nice :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 7680] Create a PatronDefaultView preference to control whether patron links go to circ or patron details
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7680 --- Comment #22 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- We just recently had a request to change the link targets - so this is still valid. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 7655] Runtime parameters: Allow for making free text and date fields optional without the need for users to enter %
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7655 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Runtime parameters: Allow |Runtime parameters: Allow |for an "optional" field |for making free text and |tag, versus the need for % |date fields optional | |without the need for users | |to enter % -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 7655] Runtime parameters: Allow for an "optional" field tag, versus the need for %
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7655 --- Comment #2 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- We also have :all now, that works on drop down lists and adds an entry with % that is pre-selected. Having a % for date or free text is probably not as easy to resolve. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 7654] Add location at opac subscription view
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7654 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |RESOLVED Resolution|--- |DUPLICATE --- Comment #25 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- I believe this was fixed by bug 12318 now. *** This bug has been marked as a duplicate of bug 12318 *** -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12318] Show subscription shelving location on subscription tabs
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '23

08 Jan '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12318 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |koha(a)univ-lyon3.fr --- Comment #10 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- *** Bug 7654 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.

1 0