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

[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 23066] New: Add foreign key for issues tables to branches table for branchcodes
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '20

31 Aug '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 31 Aug '20

31 Aug '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

[Bug 21733] New: Loanperiod shortened when there are hold, even if Library transfer limits prevents prebents the item from fulfilling a hold
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '20

31 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21733 Bug ID: 21733 Summary: Loanperiod shortened when there are hold, even if Library transfer limits prevents prebents the item from fulfilling a hold 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: klas.blomberg(a)skovde.se QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Another bug related to Library transfer limits Scenario: There is an item at library A There is another item at library B, and several holds for that title for pickup at library B. UseBranchTransferLimits is set to enfarce, so items should not be transferred from library A to library B. decreaseLoanHighHolds is set to enable, so loan periods are shortened when there are several holds. In this case it seems reasonable that the loanperiod at library A should not be shortened, irrespective of the hold, as that item is not supposed to be transfered and fill the hold -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 21504] New: enumchron shows as 0 in pdf
by bugzilla-daemon＠bugs.koha-community.org 30 Aug '20

30 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21504 Bug ID: 21504 Summary: enumchron shows as 0 in pdf Change sponsored?: --- Product: Koha Version: 17.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Label/patron card printing Assignee: cnighswonger(a)foundations.edu Reporter: bwsdonna(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 80141 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=80141&action=ed… bibrecord for testing enumchron issue When printing a spine label with itemcallnumber and enumchron, the pdf shows the one or two digit enumchron value as 0, but the CSV and XML formats show the correct enumchron value. Have replicated in 18.05. Changing item type, bib record, enumchron value, etc all result in same scenario. To replicate, create a template and layout: Template: US inches Page height 11 Page width 8.5 Label width 1.625 Label height 1 Top page margin .5 Left page margin .25 Top text margin .3 Left text margin 1.25 Number of columns 5 Number of rows 10 Gap col 0 Gap row 0 No profile Layout: Biblio 1 itemcallnumber 2 enumchron Split call numbers Text: center Font: Times-Bold Font size 12 Create a label batch with an enumchron, marc file for the record I was using is attached. View the pdf and see the enumchron shows 0. View the CSV and XML and see the correct enumchron shows. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 22939] New: Hard due date should block renewals when it wouldn't extend the due date
by bugzilla-daemon＠bugs.koha-community.org 28 Aug '20

28 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22939 Bug ID: 22939 Summary: Hard due date should block renewals when it wouldn't extend the due date Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: lisetteslatah(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Target Milestone: --- It seems like it would make sense for renewals to be blocked if there is a hard due date set equal to or before the time the renewal would normally allow it would block renewing. aka: School branch (branch a) is closing for the summer. They set their hard due date to be 5/17/19. Their checkout period is 14 days, they allow 1 renewal, and the renewal is 14 days. Patron at branch b (not closing for the summer) gets a book from branch a on hold and checks it out 5/3/19. Due date is 5/17/19 and it says they have 1 renewal on the item. There is no warning about a hard due date and it looks like they should be able to renew it. On 5/16/19 they come in and want to renew the item, as their account says there is a renewal available. When the item is renewed it only gains 1 day. The patron has no indication why it is renewing differently than before. If the renewal was blocked (box grayed out or changed to zero) staff could preserve the previous renewal information without as much confusion for patrons. Lisette -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 22269] New: Pay amount - modal confirmation of amount to return to patron should be suppressed if attempting to pay (not collect) more than owed
by bugzilla-daemon＠bugs.koha-community.org 28 Aug '20

28 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22269 Bug ID: 22269 Summary: Pay amount - modal confirmation of amount to return to patron should be suppressed if attempting to pay (not collect) more than owed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- To recreate: 1 - Add a fine or find a patron owing money 2 - Go to pay fines, pay amount 3 - Set amount to be paid higher than amount owed 4 - Set amount collected higher than amount paid 5 - Note you get a confirmation modal, confirm 6 - payment fails Expected action would be that modal is prevented or notifies user that they are trying to pay more than owed. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 10

[Bug 18251] New: SCO alerts - need a trigger for successful checkouts
by bugzilla-daemon＠bugs.koha-community.org 26 Aug '20

26 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18251 Bug ID: 18251 Summary: SCO alerts - need a trigger for successful checkouts Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Self checkout Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Failed checkouts on the sco can be triggered by presence of alert, however, we have no feedback for a successful checkout. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 63

[Bug 19287] New: Add ability to mark an item ‘Lost’ from ‘Holds awaiting pickup’ list
by bugzilla-daemon＠bugs.koha-community.org 25 Aug '20

25 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19287 Bug ID: 19287 Summary: Add ability to mark an item ‘Lost’ from ‘Holds awaiting pickup’ list Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: severine.queune(a)bulac.fr QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com The BULAC (http://www.bulac.fr/) would like to mark items not found on shelves after patrons’ holds as ‘Lost’ directly from the “Circulation > Holds awaiting pickup” list. We could have a new button on the “Action” columns of the 2 tabs, producing 3 automatic actions : - cancel the hold - notify the patron if the hold was supposed to be available (the notice should be set on the “Tools > Notices and Slips” menu) - set the field “items.notforloan” or “items.itemlost” (define in a system preference) from “0” to a value from the same ‘authorized values list’ and set in another system preference As long as “Change sponsored?” is set on “Seeking developer”, anyone wanting to quote us for the development of such a feature or just ask for more information is welcome to write to us: <sigb(a)bulac.fr>. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 108

[Bug 22594] New: Validate SMS messaging numbers using the E.164 format
by bugzilla-daemon＠bugs.koha-community.org 24 Aug '20

24 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22594 Bug ID: 22594 Summary: Validate SMS messaging numbers using the E.164 format Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Target Milestone: --- Many SMS messaging services reject numbers that do not conform to the E.164 international public telecommunication numbering plan. On the OPAC we already We already tell patrons on the OPAC "Please enter numbers only. (123) 456-7890 would be entered as 1234567890." but we do not enforce this. We should be validating the patron's SMS number on both the staff side and the patron self-service for updating the SMS number. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 21