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

[Bug 24030] New: GetItemsForInventory failing with "ORDER BY clause is not in SELECT list"
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24030 Bug ID: 24030 Summary: GetItemsForInventory failing with "ORDER BY clause is not in SELECT list" Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 24002 t/db_dependent/Items/GetItemsForInventory.t .. 1/9 DBD::mysql::st execute failed: Expression #1 of ORDER BY clause is not in SELECT list, references column 'koha_kohadev.items.cn_sort' which is not in SELECT list; this is incompatible with DISTINCT [for Statement " SELECT DISTINCT(items.itemnumber), barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber FROM items LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber LEFT JOIN biblioitems on items.biblionumber = biblioitems.biblionumber ORDER BY items.cn_sort, itemcallnumber, title"] at /kohadevbox/koha/C4/Items.pm line 838. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24002 [Bug 24002] Test suite is failing on MySQL 8 -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 23993] New: Can't call method "notforloan" on an undefined value at C4/Reserves.pm line 1177.
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23993 Bug ID: 23993 Summary: Can't call method "notforloan" on an undefined value at C4/Reserves.pm line 1177. Change sponsored?: --- Product: Koha Version: master 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: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Imported an unknown item type. Tried to place a hold. Can't call method "notforloan" on an undefined value at /usr/share/koha/C4/Reserves.pm line 1177. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

[Bug 24032] New: Creating a new serial in french version
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24032 Bug ID: 24032 Summary: Creating a new serial in french version Change sponsored?: --- Product: Koha Version: 19.05 Hardware: PC OS: Windows Status: NEW Severity: blocker Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: library(a)iram.fr QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com I have a bug in the french version of Koha 19.05.04. In the serials module, when I click on "recherche d'un fournisseur" (Search for a vendor) or on "Créer une notice" (create record), nothing happens: the pop-up doesn't appear. It's impossible to create a new serial. There is no problem when I work in the english interface. The bug appears only in the french one. Steps to reproduce: 1. Work in the french version 2. Try to create a new serial Version Koha : 19.05.04.000 Version de l'OS ('uname -a) : Linux library 4.9.0-11-amd64 #1 SMP Debian 4.9.189-3+deb9u1 (2019-09-20) x86_64 My PC runs on Windows 10 pro. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 19740] New: Self checks calculating wrong due dates / configuration changes go unnoticed
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19740 Bug ID: 19740 Summary: Self checks calculating wrong due dates / configuration changes go unnoticed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com When using a self check via SIP2 a calendar change will take no effect resulting in due dates being calculated differently for self checks than on the circulation desk. The calculation will remain false until the SIP server is restarted. This also seems to apply to system preference changes, which happen less often. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 23932] New: Typo on 'aqinvoice_adjustments.encumber_open' description in Koha Schema
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23932 Bug ID: 23932 Summary: Typo on 'aqinvoice_adjustments.encumber_open' description in Koha Schema Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: severine.queune(a)bulac.fr QA Contact: testopia(a)bugs.koha-community.org Description for encumber_open in Koha Schema should be "funds" instead of "finds". See http://schema.koha-community.org/master/tables/aqinvoice_adjustments.html -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 24026] New: Wrong parameters in Koha/Templates/Plugin/CirculationRules.pm and smart-rules.tt
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24026 Bug ID: 24026 Summary: Wrong parameters in Koha/Templates/Plugin/CirculationRules.pm and smart-rules.tt Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: System Administration 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 The searches in the module use $branchcode for all three parameters, looks like a copy/paste issue 29 $branchcode = undef if $branchcode eq q{} or $branchcode eq q{*}; 30 $categorycode = undef if $categorycode eq q{} or $branchcode eq q{*}; 31 $itemtype = undef if $itemtype eq q{} or $branchcode eq q{*}; The admin page uses 'Get' instead of 'Search' for maxisseqty/maxonsiteissueqty - this returns the 'effective' rule and so may return the wrong rule if things are not set 139 <td> 140 [% SET rule_value = CirculationRules.Get( rule.branchcode, rule.categorycode, rule.itemtype, 'maxissueqty' ) %] 141 [% IF rule_value || rule_value == "0" %] 142 [% rule_value | html %] 143 [% ELSE %] 144 <span>Unlimited</span> 145 [% END %] 146 </td> We discovered this from upgrade issues resulting from bug 23813 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 24029] New: marcrecord2csv.t displays a SQL error "Truncated incorrect DOUBLE value: '01e'"
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24029 Bug ID: 24029 Summary: marcrecord2csv.t displays a SQL error "Truncated incorrect DOUBLE value: '01e'" Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Blocks: 24002 t/db_dependent/Record/marcrecord2csv.t .. 1/12 DBD::mysql::db do failed: Truncated incorrect DOUBLE value: '01e' [for Statement "DELETE FROM marc_subfield_structure WHERE tagfield=998 and ( tagsubfield='8' or tagsubfield='9')"] at t/db_dependent/Record/marcrecord2csv.t line 104. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24002 [Bug 24002] Test suite is failing on MySQL 8 -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 15654] Integrating a cash register system into Koha: An Example
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15654 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #2 from Martin Renvoize <martin.renvoize(a)ptfs-europe.com> --- With bug 23321 having now been pushed, we should probably resurrect this bug as the exposure of that feature via API's? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 19770] New: Add cardnumber to holds awaiting pickup screen and add classes to borrower info
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '19

12 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19770 Bug ID: 19770 Summary: Add cardnumber to holds awaiting pickup screen and add classes to borrower info Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests 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 Some libraries use a combination of borrowers surname and cardnumber on hold slips, this seems to be a fairly common occurence. To facilitate this it would be nice to have the cardnumber available on the waiting holds report. Additionally it would be nice to have classes add to the borrower information so that they can be accessed via javascript for constructing the special code used. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21

[Bug 8132] Batch delete tool deletes items with holds on them
by bugzilla-daemon＠bugs.koha-community.org 12 Nov '19

12 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8132 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |major -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0