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

[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

[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 Arthur Suzuki <arthur.suzuki(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |arthur.suzuki(a)biblibre.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 Jonathan Druart <jonathan.druart+koha(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=27527 -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 #153 from Jonathan Druart <jonathan.druart+koha(a)gmail.com> --- 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? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 29656] New: [DOCS] Version number in HTML output is hard to read
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '21

08 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29656 Bug ID: 29656 Summary: [DOCS] Version number in HTML output is hard to read Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Documentation Assignee: david(a)davidnind.com Reporter: david(a)davidnind.com QA Contact: testopia(a)bugs.koha-community.org In the the HTML output for the manual the version number in the navigation heading is very dim and hard to read. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 15326] Add CMS feature
by bugzilla-daemon＠bugs.koha-community.org 07 Dec '21

07 Dec '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15326 --- Comment #152 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 128357 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128357&action=e… Bug 15326: Schema updates -- You are receiving this mail because: You are watching all bug changes.

1 0