July 2020 - Koha-bugs - lists.koha-community.org

[Bug 21974] New: cxn_pool must be configurable
by bugzilla-daemon＠bugs.koha-community.org 03 Sep '20

03 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21974 Bug ID: 21974 Summary: cxn_pool must be configurable Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org On Koha::SearchEngine::Elasticsearch:92 Search::Elasticsearch is instantiate with cxn_pool => 'Sniff' The doc says: """ The Sniff connection pool should be used when you do have direct access to the Elasticsearch cluster, eg when your web servers and Elasticsearch servers are on the same network. """ https://metacpan.org/pod/Search::Elasticsearch#cxn_pool We must make this option configurable to allow elastic cluster running on a different network. Original issue reporter on bug 21675 comment 8, they are connecting to the Amazon Elastic cluster. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 19

[Bug 25712] New: Add plugin hooks to transform patron and item barcodes
by bugzilla-daemon＠bugs.koha-community.org 03 Sep '20

03 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25712 Bug ID: 25712 Summary: Add plugin hooks to transform patron and item barcodes Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Plugin architecture Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Some of our partners have unusual barcode requirements that have required us to transform scanned barcodes using javascript. This is not the most reliable method. It would make more sense to have Koha transform the barcodes on the backend using a plugin. We should add hooks to transform and generate new item and patron barcodes. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 20

[Bug 21852] New: Add more columns and column configuration to overdues report
by bugzilla-daemon＠bugs.koha-community.org 03 Sep '20

03 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21852 Bug ID: 21852 Summary: Add more columns and column configuration to overdues report Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/circ/overdue.pl OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org I propose to add more available columns to the overdues report and column configuration to hide the new columns by default. -- You are receiving this mail because: You are watching all bug changes.

1 56

[Bug 16466] New: Patron discharge page should show pending requests
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16466 Bug ID: 16466 Summary: Patron discharge page should show pending requests Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/members/discharge.pl OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If a patron has requested a discharge via the OPAC, that request does not show up on their discharge page in the staff client. I think it should. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 6

[Bug 24466] New: AllowHoldsOnPatronsPossessions and the REST API
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24466 Bug ID: 24466 Summary: AllowHoldsOnPatronsPossessions and the REST API Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com A library in Sweden has reported the following problem: AllowHoldsOnPatronsPossessions = Do not allow. A patron borroes a book. A hold on the same book is then placed, for the same patron, through the REST API: curl --location --request POST 'https://{baseurl}/api/v1/holds/' \ --header 'Content-Type: text/plain' \ --header 'Authorization: Basic {base64-encoded user pwd}' \ --data-raw '{ "patron_id": {patronid}, "pickup_library_id": "{library}", "biblio_id": {biblioid} }' And voila, the patron has a hold on a record from which they already have an item on loan, contrary to the setting of the AllowHoldsOnPatronsPossessions syspref. (I have not tested this, but do trust that the report from the library is accurate.) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5

[Bug 19967] New: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19967 Bug ID: 19967 Summary: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: ulrich.kleiber(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In this particular case you get the mysql error message: Illegal mix of collations for operation 'like' You can prevent this error by removing dateofbirth from DefaultPatronSearchFields or by the following patch: diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index 2446703..ba32a12 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -117,7 +117,12 @@ sub search { my @where_strs_or; for my $searchfield ( split /,/, $searchfields->{$searchfieldstype} ) { - push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + if ( $searchfield eq 'dateofbirth' ) { + push @where_strs_or, "DATE_FORMAT(borrowers." . $dbh->quote_identifier($searchfield) . ", '%Y-%m-%d') LIKE ?"; + } else { + push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + } + push @where_args, $term; } -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 25803] New: Internet Explorer: unable to save patron edits or view patron checkouts
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25803 Bug ID: 25803 Summary: Internet Explorer: unable to save patron edits or view patron checkouts Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Browser compatibility Assignee: oleonard(a)myacpl.org Reporter: janet.mcgowan(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org This is on the staff interface. On 19.11 sites using Internet Explorer 11 we have found 2 issues: - /members/memberentry.pl make an edit to a patron record and click Save. The page does not save. - If a user has checkouts, on /members/moremember.pl in the issues table no issues are displayed. Click on Always show checkouts immediately and no issues are displayed. I marked this as Major as we still have customers with organisations restricted to using IE. Thanks. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 26091] New: Add column configuration and export options to catalog statistics report
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26091 Bug ID: 26091 Summary: Add column configuration and export options to catalog statistics report Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: caroline.cyr-la-rose(a)inlibro.com, katrin.fischer(a)bsz-bw.de, koha-bugs(a)lists.koha-community.org, testopia(a)bugs.koha-community.org Blocks: 19282 The catalog statistics report can return results in a table with an arbitrary set of columns, so it's not possible to define a global table settings configuration, but it is possible to add on-the-fly columns settings and export options to the page. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19282 [Bug 19282] Add the copy, print and export DataTables buttons on all koha tables -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug.

1 13

[Bug 23066] New: Add foreign key for issues tables to branches table for branchcodes
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23066 Bug ID: 23066 Summary: Add foreign key for issues tables to branches table for branchcodes Change sponsored?: --- Product: Koha Version: unspecified 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: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- We should really have foreign key constrains between the branches table and the issues and old_issues tables. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14

[Bug 15985] New: Include transacting library in fines
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15985 Bug ID: 15985 Summary: Include transacting library in fines Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Work to be done: 1) Add column issue_id to accountlines table 2) Modify fines generation to set issue_id for fine upon generation 3) Modify updatedatabase.pl to insert issue_id in accountlines for currently accruing fines 4) On the pay fines page, use this data to display the library where the item was checked out from -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 86