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

[Bug 12310] Accept different monetary formats as input
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '17

21 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12310 Koha Team Lyon 3 <koha(a)univ-lyon3.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=19251 -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 21 Nov '17

21 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 21 Nov '17

21 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 14759] Replacement for Text::Unaccent
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14759 --- Comment #27 from Colin Campbell <colin.campbell(a)ptfs-europe.com> --- (In reply to David Cook from comment #26) > (In reply to Colin Campbell from comment #25) > > Text::Unaccent does not build on 64bit systems, the tests fail because of > > errors in the ccode. There has been a patch for that for four years but it > > looks like the upstream code is moribund. If you look at the test results it > > now fails on all linux test builds. The module has not been kept up to date > > to handle modern perl strings. I think the debian version may be patched to > > fix the bug in 64bit tests but it is buggy and should not be relied on. > > Suggest moving to Text::Unaccent::PurPerl be prioritized > > Where are we using Text::Unaccent? Is it still just in userid strings? I think that is the only location -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14697] Extend and enhance "Claims returned" lost status
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14697 Jessie Zairo <jzairo(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jzairo(a)bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15486] Restrict number of holds placed by day
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '17

20 Nov '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15486 Bug 15486 depends on bug 19539, which changed state. Bug 19539 Summary: Editing rules that contain 'Unlimited' values produces invalid data https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19539 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.

1 0

[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