June 2021 - Koha-bugs - lists.koha-community.org

[Bug 27077] New: Searching for patrons with guarantor_id criteria results in 500 error
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '22

28 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27077 Bug ID: 27077 Summary: Searching for patrons with guarantor_id criteria results in 500 error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: arthur.suzuki(a)biblibre.com Tried to fetch all patrons who's guarantor is "someone", got 500 error. Due to changes in the borrower table to permit multiple guarantor. Curl command : <pre> curl http://localhost:8080/api/v1/patrons?guarantor_id=42 \ -H 'Authorization: Basic a29oYTprb2hh' </pre> Plack error log : <pre> [2020/11/23 10:20:33] [WARN] Use of uninitialized value $column_type in string eq at /kohadevbox/koha/Koha/Object.pm line 447. [2020/11/23 10:20:33] [WARN] DBD::mysql::st execute failed: Unknown column 'guarantorid' in 'where clause' [for Statement "SELECT `me`.`borrowernumber`, `me`.`cardnumber`, `me`.`surname`, `me`.`firstname`, `me`.`title`, `me`.`othernames`, `me`.`initials`, `me`.`streetnumber`, `me`.`streettype`, `me`.`address`, `me`.`address2`, `me`.`city`, `me`.`state`, `me`.`zipcode`, `me`.`country`, `me`.`email`, `me`.`phone`, `me`.`mobile`, `me`.`fax`, `me`.`emailpro`, `me`.`phonepro`, `me`.`B_streetnumber`, `me`.`B_streettype`, `me`.`B_address`, `me`.`B_address2`, `me`.`B_city`, `me`.`B_state`, `me`.`B_zipcode`, `me`.`B_country`, `me`.`B_email`, `me`.`B_phone`, `me`.`dateofbirth`, `me`.`branchcode`, `me`.`categorycode`, `me`.`dateenrolled`, `me`.`dateexpiry`, `me`.`date_renewed`, `me`.`gonenoaddress`, `me`.`lost`, `me`.`debarred`, `me`.`debarredcomment`, `me`.`contactname`, `me`.`contactfirstname`, `me`.`contacttitle`, `me`.`borrowernotes`, `me`.`relationship`, `me`.`sex`, `me`.`password`, `me`.`flags`, `me`.`userid`, `me`.`opacnote`, `me`.`contactnote`, `me`.`sort1`, `me`.`sort2`, `me`.`altcontactfirstname`, `me`.`altcontactsurname`, `me`.`altcontactaddress1`, `me`.`altcontactaddress2`, `me`.`altcontactaddress3`, `me`.`altcontactstate`, `me`.`altcontactzipcode`, `me`.`altcontactcountry`, `me`.`altcontactphone`, `me`.`smsalertnumber`, `me`.`sms_provider_id`, `me`.`privacy`, `me`.`privacy_guarantor_fines`, `me`.`privacy_guarantor_checkouts`, `me`.`checkprevcheckout`, `me`.`updated_on`, `me`.`lastseen`, `me`.`lang`, `me`.`login_attempts`, `me`.`overdrive_auth_token`, `me`.`anonymized`, `me`.`autorenew_checkouts` FROM `borrowers` `me` WHERE ( `guarantorid` LIKE ? )" with ParamValues: 0="%42%"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. </pre> -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 22204] New: Leading spaces in barcode should not allowed in cataloguing
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '22

28 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22204 Bug ID: 22204 Summary: Leading spaces in barcode should not allowed in cataloguing Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Target Milestone: --- When creating a new item, it is not allowed to add trailing spaces, it shows 'Barcode must be unique'. But it is allowed to use leading spaces :( In this case since circulation does a trim on barcode this item can not be checked-out. It also allows duplicates even with UNIQUE KEY constraint. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 29

[Bug 23070] New: Use Koha::Hold in C4::Reserves::RevertWaitingStatus
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '22

27 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23070 Bug ID: 23070 Summary: Use Koha::Hold in C4::Reserves::RevertWaitingStatus 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(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 9834 Target Milestone: --- We are using raw SQL statements, we should use Koha::Hold instead. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9834 [Bug 9834] Reverting a waiting hold should lead to the former hold type (item or biblio level) -- You are receiving this mail because: You are watching all bug changes.

1 51

[Bug 25703] New: AllowItemsOnHoldCheckoutSCO behavior.
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '22

27 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25703 Bug ID: 25703 Summary: AllowItemsOnHoldCheckoutSCO behavior. Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Self checkout Assignee: koha-bugs(a)lists.koha-community.org Reporter: eveal(a)mckinneytexas.org QA Contact: testopia(a)bugs.koha-community.org The AllowItemsOnHoldCheckoutSCO syspref allows all items on hold to be checkout within the selfcheck module. It seems to me that the preference would be more useful if it only allowed items with "Pending" holds not "confirmed and waiting" holds. Ed -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 28014] New: Add table settings to batch patron modification
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '22

27 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28014 Bug ID: 28014 Summary: Add table settings to batch patron modification Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Tools Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org It would be useful to be able to configure table settings for the preview and results of batch patron modification -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 24561] New: Add embedded column filter feature to datatables api wrapper
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '22

27 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24561 Bug ID: 24561 Summary: Add embedded column filter feature to datatables api wrapper Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: agustinmoyano(a)theke.io Reporter: agustinmoyano(a)theke.io QA Contact: testopia(a)bugs.koha-community.org CC: tomascohen(a)gmail.com Depends on: 20212, 24502 Blocks: 20936 Bug 24502 introduced filtering by embedded columns. It would be great if datatables wrapper for the API in bug 20212 could use this feature. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20212 [Bug 20212] Slowness in Receiving in Acquisitions https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20936 [Bug 20936] Holds History for patrons in OPAC https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24502 [Bug 24502] Add a query language and param (q=) to the API -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 22279] New: Unify patron name display
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '22

27 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22279 Bug ID: 22279 Summary: Unify patron name display Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: pasi.kallinen(a)koha-suomi.fi QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- The way patron's name is displayed should be unified into a single place. There's template code in patron-title.inc for it, but it's not used in enough places. Using that would make the patron name display consistent, and if change is needed (eg. for GDPR), it would be easy to change. For example: koha-tmpl/intranet-tmpl/prog/en/includes/cat-toolbar.inc: <li><a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% biblionumber | uri %]&findborrower=[% holdfor_cardnumber | uri %]">Place hold for [% holdfor_firstname | html %] [% holdfor_surname | html %] ([% holdfor_cardnumber | html %])</a></li> koha-tmpl/intranet-tmpl/prog/en/includes/js_includes.inc: .append( "<a>" + item.surname + ", " + item.firstname + " (" + item.cardnumber + ") <small>" + item.dateofbirth + " " + item.address + " " + item.city + " " + item.zipcode + " " + item.country + "</small></a>" ) koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc: <td><a href="[% data_url | url %]">[% borrower.surname | html %], [% borrower.firstname | html %]</a></td> koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember-print.tt: <title>Summary for [% patron.firstname | html %] [% patron.surname | html %] ([% patron.cardnumber | html %])</title> koha-tmpl/intranet-tmpl/prog/en/modules/members/paycollect.tt: <a href="/cgi-bin/koha/members/pay.pl?borrowernumber=[% patron.borrowernumber | uri %]">Pay fines for [% patron.firstname | html %] [% patron.surname | html %]</a> &rsaquo; and many, many more. -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 19470] New: Add information about item being in rotating collection on detail page
by bugzilla-daemon＠bugs.koha-community.org 26 Apr '22

26 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19470 Bug ID: 19470 Summary: Add information about item being in rotating collection on detail page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 18606] New: Move rotating collections code to Koha::Object
by bugzilla-daemon＠bugs.koha-community.org 26 Apr '22

26 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18606 Bug ID: 18606 Summary: Move rotating collections code to Koha::Object Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 182

[Bug 23049] New: Replace MANUAL_INV authorised value with a dedicated table
by bugzilla-daemon＠bugs.koha-community.org 26 Apr '22

26 Apr '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23049 Bug ID: 23049 Summary: Replace MANUAL_INV authorised value with a dedicated table Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Account debits types should be properly recorded in their own table with a purpose-built interface for working upon them. This would pave the way for extensions to the cash management side of Koha, allowing for more granular definitions of charges for a point of sale system and giving an obvious location to add features like recording tax rates on different charges. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 343