May 2021 - Koha-bugs - lists.koha-community.org

[Bug 27403] New: Enable fixedHeader for Datatables
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '21

17 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27403 Bug ID: 27403 Summary: Enable fixedHeader for Datatables Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org This is a nice Datatables plugin that we should enable on our tables. -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 28377] New: Use the API to suspend/resume holds
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '21

17 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28377 Bug ID: 28377 Summary: Use the API to suspend/resume holds 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: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com We have routes for suspending and resuming holds. We can deprecate the svc/holds/* scripts. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 53

[Bug 27266] New: Move C4::Biblio::GetMarcAuthors to Koha namespace
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '21

17 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27266 Bug ID: 27266 Summary: Move C4::Biblio::GetMarcAuthors to Koha namespace 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: aleisha(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 87

[Bug 25951] New: Koha::Objects using the DBIx::Class relationships in Koha::Hold and Koha::Item
by bugzilla-daemon＠bugs.koha-community.org 15 Dec '21

15 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25951 Bug ID: 25951 Summary: Koha::Objects using the DBIx::Class relationships in Koha::Hold and Koha::Item 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: nicolas.legrand(a)bulac.fr QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Blocks: 22407 Those changes focus on intranet pages /reserve/request.pl, circ/waitingreserves.pl and opac page koha/opac-user.pl. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22407 [Bug 22407] OMNIBUS: Use DBIC relations to fetch related object rather than searching for the object -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 13

[Bug 27481] New: Use Modern::Perl in cataloguing unimarc plugins
by bugzilla-daemon＠bugs.koha-community.org 15 Dec '21

15 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27481 Bug ID: 27481 Summary: Use Modern::Perl in cataloguing unimarc plugins 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: aleisha(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org use Modern::Perl in the place of use strict; use warnings; cataloguing/value_builder/unimarc_field_105.pl cataloguing/value_builder/unimarc_field_110.pl cataloguing/value_builder/unimarc_field_120.pl cataloguing/value_builder/unimarc_field_130.pl cataloguing/value_builder/unimarc_field_140.pl cataloguing/value_builder/unimarc_field_225a.pl cataloguing/value_builder/unimarc_field_4XX.pl -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 20074] New: Auth_subfield_structure changes hidden attribute
by bugzilla-daemon＠bugs.koha-community.org 13 Dec '21

13 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20074 Bug ID: 20074 Summary: Auth_subfield_structure changes hidden attribute Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: MARC Authority data support Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org >From bug 18811 comment40: It sounds like there is something else to fix: On a new DB: MariaDB [koha_kohadev]> select tagfield, tagsubfield, hidden from auth_subfield_structure where tagfield=551 and tagsubfield=9 and authtypecode="GEOGR_NAME"\G *************************** 1. row *************************** tagfield: 551 tagsubfield: 9 hidden: 1 Edit the subfields for GEOGR_NAME /admin/auth_subfields_structure.pl?op=add_form&tagfield=551&authtypecode=GEOGR_NAME Possible value for "Select to display or not"/hidden are -5 and 0, so "Show all" is displayed. Save without modifying anything: hidden is now '0'. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 27

[Bug 25216] New: XSLT can only use HTTP not HTTPS URL.
by bugzilla-daemon＠bugs.koha-community.org 12 Dec '21

12 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25216 Bug ID: 25216 Summary: XSLT can only use HTTP not HTTPS URL. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: Linux Status: NEW Severity: minor Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: didier.gautheron(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Hi, At least on Debian libxml doesn't understand https, but only http or local files. It's an issue with more and more systems silently redirecting http to https. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 27708] New: Cannot create EDI order if AcqCreateItem value is not "placing an order"
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '21

09 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27708 Bug ID: 27708 Summary: Cannot create EDI order if AcqCreateItem value is not "placing an order" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: joonas.kylmala(a)helsinki.fi QA Contact: testopia(a)bugs.koha-community.org CC: nugged(a)gmail.com Depends on: 23926 There was a regression in bug 23926 which causes EDI orders to give internal server error if AcqCreateItem syspref is set to something other than "placing an order." The code from patch "Bug 23926: Limit GIR segment to 5 pieces of info" (f9efa7a9) assumes in the line > branchcode => $item->homebranch->branchcode, that we have an Koha object but that is not true when AcqCreateItem is set to not create an item while placing the order. In that case we manually create hash representing item which has the key "branch" that contains the branchcode so the code "$item->homebranch->branchcode" doesn't work because it should be $item{branch}. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23926 [Bug 23926] In EDI Order limit GIR segment to five pieces of information -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 36

[Bug 28057] New: Confusion of biblionumber and biblioitemnumber in request.pl
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28057 Bug ID: 28057 Summary: Confusion of biblionumber and biblioitemnumber in request.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal 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 We have seen issues on sites where biblionumber and biblioitemnumbers are not the same - we hit an ISE for missing itemypes for items on record B when placing a hold on record A biblionumber and biblioitemnumber are not guaranteed to be the same I don't understand what is happening around this code, but I am certain this is not right: 447 $items_any_available = ItemsAnyAvailableAndNotRestricted( { biblionumber => $biblioitemnumber, patron => $ patron }) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 40

[Bug 26457] New: DB DeadLock when renewing checkout items
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26457 Bug ID: 26457 Summary: DB DeadLock when renewing checkout items Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: didier.gautheron(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Hi, Since it's in a transaction ( https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20086 ) we are seeing deadlock when renewing checkout and items aren't renewed randomly. plack error DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "UPDATE issues SET date_due = ?, renewals = ?, lastreneweddate = ? WHERE borrowernumber=? AND itemnumber=?" with P SHOW ENGINE INNODB STATUS; ----------------------- LATEST DETECTED DEADLOCK ------------------------ 2020-09-14 11:09:55 0x7f69b85c0700 *** (1) TRANSACTION: TRANSACTION 19363996, ACTIVE 1 sec fetching rows mysql tables in use 4, locked 4 LOCK WAIT 7 lock struct(s), heap size 1128, 8 row lock(s) MySQL thread id 22449, OS thread handle 140092040718080, query id 38767706 localhost kohaadmin Updating UPDATE issues SET date_due = '2020-09-18 23:59', renewals = '1', lastreneweddate = '2020-09-14T11:09:54' WHERE borrowernumber='93697' AND itemnumber='999735' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 476 page no 87 n bits 248 index PRIMARY of table `koha`.`issues` trx id 19363996 lock_mode X locks rec but not gap waiting Record lock, heap no 109 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 0: len 4; hex 802713f6; asc ' ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80016e01; asc n ;; 4: len 4; hex 8008e784; asc ;; 5: len 5; hex 99a7397ec0; asc 9~ ;; 6: len 6; hex 43454e545245; asc CENTRE;; 7: SQL NULL; 8: SQL NULL; 9: len 1; hex 80; asc ;; 10: len 1; hex 80; asc ;; 11: SQL NULL; 12: len 4; hex 5f326b5e; asc _2k^;; 13: len 5; hex 99a6e20000; asc ;; 14: len 4; hex 80000000; asc ;; 15: SQL NULL; 16: SQL NULL; 17: SQL NULL; *** (2) TRANSACTION: TRANSACTION 19363999, ACTIVE 1 sec starting index read mysql tables in use 4, locked 4 4 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 22450, OS thread handle 140092041332480, query id 38767702 localhost kohaadmin Updating UPDATE issues SET date_due = '2020-09-18 23:59', renewals = '1', lastreneweddate = '2020-09-14T11:09:54' WHERE borrowernumber='93697' AND itemnumber='583556' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 476 page no 87 n bits 248 index PRIMARY of table `koha`.`issues` trx id 19363999 lock_mode X locks rec but not gap Record lock, heap no 109 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 0: len 4; hex 802713f6; asc ' ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80016e01; asc n ;; 4: len 4; hex 8008e784; asc ;; 5: len 5; hex 99a7397ec0; asc 9~ ;; 6: len 6; hex 43454e545245; asc CENTRE;; 7: SQL NULL; 8: SQL NULL; 9: len 1; hex 80; asc ;; 10: len 1; hex 80; asc ;; 11: SQL NULL; 12: len 4; hex 5f326b5e; asc _2k^;; 13: len 5; hex 99a6e20000; asc ;; 14: len 4; hex 80000000; asc ;; 15: SQL NULL; 16: SQL NULL; 17: SQL NULL; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 476 page no 425 n bits 1168 index issuesborridx of table `koha`.`issues` trx id 19363999 lock_mode X waiting Record lock, heap no 52 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80016e01; asc n ;; 1: len 4; hex 8026df40; asc & @;; *** WE ROLL BACK TRANSACTION (2) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 58