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

[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 26320] New: Crash when click search button with empty key word
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26320 Bug ID: 26320 Summary: Crash when click search button with empty key word Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: PC OS: Windows Status: NEW Severity: major Priority: P5 - low Component: Bugzilla Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: yuan.wan(a)sjsu.edu Go to the Buzilla main page and click search button with empty key word. Then it will crash(testing). -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 23634] Privilege escalation vulnerability for staff users with 'edit_borrowers' permission and 'OpacResetPassword' enabled
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23634 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=26170 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 24663] OPACPublic must be tested for all opac scripts
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24663 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook(a)prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 24663] OPACPublic must be tested for all opac scripts
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

1 0

[Bug 23634] Privilege escalation vulnerability for staff users with 'edit_borrowers' permission and 'OpacResetPassword' enabled
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

1 0

[Bug 14825] Accounts Rewrite Omnibus
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14825 Tomás Cohen Arazi <tomascohen(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |26327 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26327 [Bug 26327] Include transacting library in fines -- You are receiving this mail because: You are watching all bug changes.

1 0