April 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 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 29986] New: Descriptions of system internal debit types and credit types should be editable
by bugzilla-daemon＠bugs.koha-community.org 22 Nov '22

22 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 22 Nov '22

22 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 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 29658] New: Crash on cancelling cancelled order
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '22

20 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29658 Bug ID: 29658 Summary: Crash on cancelling cancelled order Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org See bug 29823. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 32

[Bug 26626] New: When checking in a hold that is not found the X option is 'ignore' and when hold is found it is 'cancel'
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '22

20 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26626 Bug ID: 26626 Summary: When checking in a hold that is not found the X option is 'ignore' and when hold is found it is 'cancel' Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com This can lead to accidental cancellation if one is simply trying to dismiss the modal and has learned that the X option is often 'ignore' I would suggest replacing 'Ignore/Cancel' with 'Dismiss' and moving the 'Cancel' option to the left of 'Confirm hold' To recreate: 1 - Place a hold for pickup at library A 2 - Checkin the item at Library A 3 - Note the modal has 'Ignore' option 4 - Click it, nothing happens 5 - Check in the item again, same modal 6 - Click 'Confirm' 7 - Check in the item again 8 - Now 'Ignore' is replaced by 'Cancel' 9 - Click 'cancel', but pretend you thought it was 'Ignore' 10 - The book comes up on the holds queue, but no one can find it, because it is on the holds shelf 11 - Then staff do find it, but they hold it for the next patron 12 - The original patron comes in to library, but you won't give them the book, because someone else has the hold now 13 - Drama ensues... -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 33

[Bug 28290] New: Record matching rules with no subfields cause ISE
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '22

20 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28290 Bug ID: 28290 Summary: Record matching rules with no subfields cause ISE 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 - Define a new matching rule with no subfields Match-threshold: 1000 Record type: bibliographic record Search-index: Other-control-number Score: 1000 Tag: 035 Subfields: Offset: Length: 2 - Attempt to stage a record with an 035 using this rule (i will attach example to bug) 3 - Staging fails 4 - Stage again with no matching rule 5 - Manage the staged record, try to apply the matching rule 6 - It fails, 500 error -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 27

[Bug 27761] New: Koha is reporting deleted items when a pickup is done by OAI
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '22

19 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27761 Bug ID: 27761 Summary: Koha is reporting deleted items when a pickup is done by OAI Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: jcautomatizacion(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Hello, We have a problem, our Koha is reporting deleted items when a collection is done by OAI, can this be solved? Can you remove the deleted products so that it only shows the current ones? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5

[Bug 16723] New: Add additional subscription fields to serial claim notices
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '22

19 Nov '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16723 Bug ID: 16723 Summary: Add additional subscription fields to serial claim notices Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org It would be nice if it was possible to output the additional subscription fields in the serial related notices - especially the late issue / claim notice. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5