June 2020 - 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 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 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 25877] New: Error libraryNotPickupLocation when placing a hold if logged in branchcode is not a pickup location
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '20

31 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25877 Bug ID: 25877 Summary: Error libraryNotPickupLocation when placing a hold if logged in branchcode is not a pickup location Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation 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 On the staff side, if the librarian is logged in as a branch that is not a hold pickup location, that branch is still used as the default pickup location for the rules, resulting in the item not holdable reason libraryNotPickupLocation, while the pulldown shows the first branch that can actually be used as a pickup location. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21

[Bug 25411] New: Plugin routes cannot have annonymous access
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '20

31 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25411 Bug ID: 25411 Summary: Plugin routes cannot have annonymous access Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com This is a consequence of a big change introduced by bug 25045 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 35

[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 25569] New: decreaseLoanHighHolds will decrease loan too often
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '20

31 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25569 Bug ID: 25569 Summary: decreaseLoanHighHolds will decrease loan too often 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 The routine checkHighHolds uses CanItemBeReserved to count the number of available items, however, since we must pass the current borrower and check their ability to hold the items, many of the checks in that routine are not necessarily applicable. Additionally the count of holds on the record may be inaccurate: 1 - The borrowers own holds shouldn't be counted - if I am getting several books for a book group or a number of dvds in a set I shouldn't shorten my own loan period 2 - My hold limits may prevent me from placing more holds, but are not relevant in determining if the item is in high demand 3 - My fines may prevent me from placing holds, but shouldn't shorten my loan period 4 - If 6 patrons from another library who can't hold my libraries items have holds on their libraries item, my loan period shouldn't be decreased as they can't get my item anyways 5 - etc. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 24134] New: improve 008 framework flexibility (autogenerate date)
by bugzilla-daemon＠bugs.koha-community.org 30 Aug '20

30 Aug '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24134 Bug ID: 24134 Summary: improve 008 framework flexibility (autogenerate date) Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: philip.bertling(a)rbg.vic.gov.au QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl When creating a framework for a form type other than book, it does not seem possible to autogenerate the date correctly. The 00-05 ‘date entered on file’ in the 008 field, can almost be auto-filled by using the code <<YYYY>><<MM>><<DD>>. However it doesn’t quite work because the 008 field expects a 6 digit date [YYMMDD] – this code inserts an 8 digit date [YYYYMMDD]. e.g. <<YY>><<MM>><<DD>> b at |||p |||||00| eng d = entered on the date <<29>><<11>><<25>> This creates the following data in a record: <<YY>>1125 b at |||p |||||00| eng d Is it possible to make this date code work to insert a date comprising 6 digits? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[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