October 2017 - Koha-bugs - lists.koha-community.org

[Bug 17676] New: Default COLLATE for marc_subfield_structure is not set
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '17

21 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17676 Bug ID: 17676 Summary: Default COLLATE for marc_subfield_structure is not set Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: critical 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: 17216, 11944 (This issue has been raised on bug 17216 comments 93-103) On bug 11944 (3.19.00.006) we updated the default COLLATE for all our tables to utf8_unicode_ci but not the marc_subfield_structure table. Indeed we want to keep tagsubfield a utf8_bin (to allow lowercase and uppercase of the same letter for subfields). We should have set the default collate to utf8_unicode_ci for further changes. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11944 [Bug 11944] Cleanup Koha UTF-8 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216 [Bug 17216] Add a new table to store authorized value categories -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 18884] New: Advanced search on staff client, Availability limit not properly limiting
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18884 Bug ID: 18884 Summary: Advanced search on staff client, Availability limit not properly limiting Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: michael(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 64741 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64741&action=ed… limit here is limit=BN, not limit=holdingbranch%3ABN, which causes an item not from this library (Bison) showing in search results On the advanced search area, when you limit to a specific library in the availability limits, the resultant search string is: /cgi-bin/koha/catalogue/search.pl?idx=au&q=janet&op=and&idx=kw&op=and&idx=kw&limit=E&sort_by=relevance where the limit is: limit=E for holding branch...the limit should be /cgi-bin/koha/catalogue/search.pl?idx=au&q=evanovich+janet&op=and&idx=kw&op=and&idx=kw&limit=holdingbranch%3ABN&sort_by=relevance limit=holdingbranch%3ABN This means that currently a limit for a specific library will return books not in that library. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 18

[Bug 19495] New: Automatic report conversion needs to do global replace on 'biblioitems' and 'marcxml'
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19495 Bug ID: 19495 Summary: Automatic report conversion needs to do global replace on 'biblioitems' and 'marcxml' Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Bug 17898 provides a way of converting reports that use biblioitems.marcxml so that they will use biblio_metadata.metadata instead. This only works with reports that do not refer to other columns in the biblioitems table. This is a known limitation. It means that we should be able to do a substitution of every occurrence of biblioitems with biblio_metadata, and every occurrence of marcxml with metadata. Unfortunately, we're not doing a global replace, we're only replacing the first occurrence. Here's the original: SELECT biblio.title, biblio.biblionumber, A.barcode,ExtractValue(biblioitems.marcxml,'//controlfield[@tag="001"]') AS "field_001", A.itemcallnumber, A.itype FROM items A JOIN biblio on (A.biblionumber = biblio.biblionumber) JOIN biblioitems on (A.biblionumber = biblioitems.biblionumber) WHERE withdrawn = 1 AND A.biblionumber NOT in ( SELECT biblionumber FROM items B WHERE B.itemnumber != A.itemnumber ) And here's the converted: SELECT biblio.title, biblio.biblionumber, A.barcode,ExtractValue(biblio_metadata.metadata,'//controlfield[@tag="001"]') AS "field_001", A.itemcallnumber, A.itype FROM items A JOIN biblio on (A.biblionumber = biblio.biblionumber) JOIN biblioitems on (A.biblionumber = biblioitems.biblionumber) WHERE withdrawn = 1 AND A.biblionumber NOT in ( SELECT biblionumber FROM items B WHERE B.itemnumber != A.itemnumber ) Note that there are three occurrences of 'biblioitems' in the first query, but only the first has been substituted in the second. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 19539] New: Editing rules that contain 'Unlimited' values produces invalid data
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19539 Bug ID: 19539 Summary: Editing rules that contain 'Unlimited' values produces invalid data Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Steps to reproduce: - On the Circulation and fine rules page - Empty the value of 'Current on-site checkouts allowed' and save - Notice 'Unlimited' shows on the saved rule. - Click edit => FAIL: the 'Unlimited' string displays intead of the empty string. This was introduced by bug 18857 -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 19431] New: Error when trying to checkout an unknown barcode
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19431 Bug ID: 19431 Summary: Error when trying to checkout an unknown barcode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When trying to checkout an unknown barcode, I receive an internal server error: Can't call method "materials" on an undefined value at /home/vagrant/kohaclone/circ/circulation.pl line 387. It should ask me to do a fast add instead. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 28

[Bug 19513] New: More changes to MarkIssueReturned.t (after bug 19487)
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19513 Bug ID: 19513 Summary: More changes to MarkIssueReturned.t (after bug 19487) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Following bug 19487. QA follow-up moved to its own report. -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 19544] New: Add manual contributors to the release notes
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '17

19 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19544 Bug ID: 19544 Summary: Add manual contributors to the release notes Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Release tools Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de CC: chris(a)bigballofwax.co.nz It would be neat if we could add manual contributors to the release notes automatically. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 19485] New: Limiting by title-series (se) broken on ES
by bugzilla-daemon＠bugs.koha-community.org 17 Nov '17

17 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19485 Bug ID: 19485 Summary: Limiting by title-series (se) broken on ES Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Searching - Elasticsearch Assignee: david.bourgault(a)inlibro.com Reporter: david.bourgault(a)inlibro.com When filtering/limiting search results by Series title, the limit field name passed to ES is 'title-series' but it expects 'se', causing no results to be found. This is particularly confusing as the page URL clearly says limit=se:XYZ. -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 19420] New: Improve display of errors from failure of uploading file during stage import
by bugzilla-daemon＠bugs.koha-community.org 16 Nov '17

16 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19420 Bug ID: 19420 Summary: Improve display of errors from failure of uploading file during stage import Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Currently error is always: Upload status: Failed Though there are four reasons it could fail, they are codes buried in Koha/Uploader.pm -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 33

[Bug 19180] New: Vendor name is missing from breadcrumbs when closing an order
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '17

15 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19180 Bug ID: 19180 Summary: Vendor name is missing from breadcrumbs when closing an order Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org When an open basket/order is closed, the breadcrumbs on the page asking about adding the order to a basket group is missing the vendor name in the breadcrumbs in 2 spots: Home › Acquisitions › › Basket Test bug 15347 (1) for -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 25