September 2022 - Koha-bugs - lists.koha-community.org

[Bug 23982] New: Count/pagination broken for reports with duplicated column names
by bugzilla-daemon＠bugs.koha-community.org 22 Nov '22

22 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23982 Bug ID: 23982 Summary: Count/pagination broken for reports with duplicated column names Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org bug 23624 simplified how we get the count of rows in a report, however, it breaks under certain circumstances. A report like: SELECT * FROM issues JOIN borrowers USING (borrowernumber) will have two borrowernumber columns - SQL will give us there rsults, but if we try to wrap them in a SELECT COUNT(*) FROM (report) it throws a duplicated column error. I don't know an easy fix except to state that one must name the columns they want to avoid duplication -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 23

[Bug 31220] New: Error when attempting to export selected labels as PDF
by bugzilla-daemon＠bugs.koha-community.org 22 Nov '22

22 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31220 Bug ID: 31220 Summary: Error when attempting to export selected labels as PDF Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org To recreate: 1 - Create a new label batch with some items 2 - Select 1 or more 3 - Export selected labels 4 - Download as PDF 5 - BOOM Can't locate object method "get_attr" via package "-2" (perhaps you forgot to load "-2"?) at /usr/share/koha/intranet/cgi-bin/labels/label-create-pdf.pl line 126. It looks like bug 26340 accidentally touched the selected label export and removed batch number and label ids -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 27

[Bug 24372] New: Elasticsearch - cannot search for titles containing a colon next to a search term using the colon
by bugzilla-daemon＠bugs.koha-community.org 22 Nov '22

22 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24372 Bug ID: 24372 Summary: Elasticsearch - cannot search for titles containing a colon next to a search term using the colon Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com Using an example record in the testing DB, try searching for: Pictura murală din nordul Moldovei: modificari estetice si restarare = Mural painting in the north of Moldavia: aesthetic modification and restoration In ES the search fails. If you look at the query we end up with terms like: Moldoveimodificari AND Moldaviaaesthetic This is because of this line in Koha/SearchEngine/Elasticsearch/QueryBuilder.pm 935 # Remove unquoted colons that have whitespace on either side of them 936 $term =~ s/(\:[:\s]+|[:\s]+:)$lookahead//g; Removing colons with a space on either side, we must be careful to put that space back: 936 $term =~ s/(\:[:\s]+|[:\s]+:)$lookahead/ /g; -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 30794] New: Default checkout, hold and return policy overrides Unlimited holds in 'Default checkout, hold policy by patron category'
by bugzilla-daemon＠bugs.koha-community.org 22 Nov '22

22 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30794 Bug ID: 30794 Summary: Default checkout, hold and return policy overrides Unlimited holds in 'Default checkout, hold policy by patron category' Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: sbrown(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com If holds for a patron category are set to Unlimited in 'Default checkout, hold policy by patron category' but a holds limit exists in 'Default checkout, hold and return policy', the latter will apply. To recreate: -Set max holds at 5 for Patron Category A in 'Default checkout, hold policy by patron category' -Set max holds at 2 in 'Default checkout, hold and return policy' -Attempt to place multiple holds for a patron in category A - you will be stopped on the 6th hold. -Change max holds to Unlimited for Patron Category A in 'Default checkout, hold policy by patron category' -Keep 'Default checkout, hold and return policy' at 2 max holds -Attempt to place multiple holds for that patron - you'll be stopped after the 2nd hold (In the test above, the circulation matrix has an Patron Category A/All item types max of 10 holds.) This appears to apply in 21.05 and 21.11. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 28

[Bug 29986] New: Descriptions of system internal debit types and credit types should be editable
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '22

21 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29986 Bug ID: 29986 Summary: Descriptions of system internal debit types and credit types should be editable Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, martin.renvoize(a)ptfs-europe.com The descriptions of system internal debit types and credit types are not translatable from the GUI. We should make that work, as the descriptions are used for display for example on the cashup summary print outs (see bug 27779) As this leaves no way for people to fix translations for their use but SQL, I'd consider this is in a grey area to be a little more bug than enhancement. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 29695] New: Centralize columns' descriptions
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '22

21 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29695 Bug ID: 29695 Summary: Centralize columns' descriptions Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart+koha(a)gmail.com Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org We have columns.def that contains the descriptions for DB columns and some json files that are used for syspref's values selection. 1. We duplicate them 2. columns.def is translatable but json files are not 3. columns.def is a XML file we are parsing with regexs We should have a single and better way to deal with those descriptions. -- You are receiving this mail because: You are watching all bug changes.

1 69

[Bug 31364] New: Saving preferences with a dropdown with check boxes doesn't save in the case where all the checks are removed.
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '22

21 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31364 Bug ID: 31364 Summary: Saving preferences with a dropdown with check boxes doesn't save in the case where all the checks are removed. Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: rkuiper(a)roundrocktexas.gov QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com When updating a system preference with a dropdown that contains checkboxes, the changes are not saved in the case where there were items checked and then you try to remove all checks. An example of this is OPACHoldsIfAvailableAtPickupExceptions. Set a couple patron categories as exceptions. Save. Remove all the categories from the exception list. Save. You get a message that says 'Nothing to Save' and the changes are not made. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[Bug 31421] New: Library limitation on patron category breaks patron search
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '22

21 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31421 Bug ID: 31421 Summary: Library limitation on patron category breaks patron search Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com To test: * Log in under library A (Fairfield) * Limit one patron category (Patrons PT) to library B (Centerville) * Search for all patrons (empty search) * No results and there is an error in the console: Uncaught TypeError: categories_map[data] is undefined -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 25

[Bug 29409] New: Update for bug 25334 can fail due to bad data or constraints
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '22

20 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29409 Bug ID: 29409 Summary: Update for bug 25334 can fail due to bad data or constraints Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The update does not check for the existence of the foreign key before deleting it Additionally we have seen many sites with problematic data that stops the update, will offer a check for what we have seen here -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 31516] New: Missing error handling for accessing deleted/non-existent club enrollment
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '22

20 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31516 Bug ID: 31516 Summary: Missing error handling for accessing deleted/non-existent club enrollment Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: joonas.kylmala(a)iki.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If you visit in staff interface club enrollment page for a non-existent club you get a somewhat broken page, e.g. http://localhost:8081/cgi-bin/koha/clubs/club-enrollments.pl?id=10101010010… We should provide a clear error message that the club the user tried to view doesn't exists. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14