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

[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 29667] New: Gmail>>Compose>>Clicking on send button application throws server error
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '21

09 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29667 Bug ID: 29667 Summary: Gmail>>Compose>>Clicking on send button application throws server error Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: PC OS: All Status: NEW Severity: critical Priority: P2 Component: Bugzilla Assignee: jonathan.druart+koha(a)gmail.com Reporter: madangowda046(a)gmail.com steps to reproduce defect: 1. Login to gmail application - username:test@gmail.com - password:test$1234 2. Click on compose 3. In compose enter the following To Subject Email body Expected Result: Email should be sent Actual Result: Email sending failed -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 29657] New: OpacNavRight is only added to one language for OPACs with multiple active languages
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '21

09 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29657 Bug ID: 29657 Summary: OpacNavRight is only added to one language for OPACs with multiple active languages Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org We are just starting our updates and in all updated instances the OpacNavRight entry hasn't been migrated correctly. The entry in the news is only added for one language, instead of all languages (default doesn't exist in 20.11 yet). So this requires a lot of manual work after the updates. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 15067] Add additional languages to advanced search language search
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15067 Manos PETRIDIS <egpetridis(a)yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |egpetridis(a)yahoo.com --- Comment #35 from Manos PETRIDIS <egpetridis(a)yahoo.com> --- Has anyone noticed bugs 29631 and 29641? They seem to be caused by the unique keys introduced here. Shouldn't this bug revert to QA needed status? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15594] Sequence of MARC 260 subfields different on XSLT result list and detail page
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15594 --- Comment #3 from Blou <philippe.blouin(a)inlibro.com> --- Created attachment 128369 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128369&action=e… Bug 15594: preserve sequence of 260 subfields in (staff) detail page When ordered $a$b$a$b$c in the MARC object, 260 subfields are displayed $a$a$b$b$c. This goes against the standard. This patch preserves the order. 0) create a notice with $a$b$a subfields. In that (mixed) order. 1) Go to staff detail page and see the fields displayed as "aab" 2) apply the patch 3) validate the aba display. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 10195] Records hidden with OpacSuppression can still be accessed
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10195 Fridolin Somers <fridolin.somers(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |28478 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28478 [Bug 28478] MARC detail and ISBD pages still show suppressed records -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 15326] Add CMS feature
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15326 --- Comment #154 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- (In reply to Jonathan Druart from comment #153) > Aleisha, with the recent "additional contents" changes we could have a new > type of content "page". They would be stored in the same DB table and would > profit from the other possibilities (translation, etc.) > > Is it something that could work for you? Yes, I was thinking the same. Actually I am already using the news database as a simple cms for some local pages. Perhaps some of the additional features(?) here could be incorporated. -- You are receiving this mail because: You are watching all bug changes.

1 0

[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

[Bug 29650] New: False update
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29650 Bug ID: 29650 Summary: False update Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: vvishnuaejith(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Created attachment 128310 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128310&action=e… patron id :1028 book TB9218 on 22-11-2021 i renewed 3 books .The transaction log on that day shows the three books renewed successfully. But on the Patron page only 2 books renewed remaining one books on the same due date.due date not updated.There is no auto increment problem in the server. book:TB9218 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7