July 2020 - Koha-bugs - lists.koha-community.org

[Bug 20086] New: AddRenewal is not executed as a transaction and can results in partial success and doubled fines
by bugzilla-daemon＠bugs.koha-community.org 15 Sep '20

15 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20086 Bug ID: 20086 Summary: AddRenewal is not executed as a transaction and can results in partial success and doubled fines 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: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com I can't recreate on demand, however, I can confirm several reports in the wild. On a large/busy system, grep for "Deadlock" in the plack error logs. On several sites we are seeing occasional: 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 ParamValues: 0='2099-01-01 23:59', 1=2, 2='2099-01-01', 3="#####", 4="#####"] at /usr/share/koha/lib/C4/Circulation.pm line 2895. (dates and numbers altered for privacy) In this case the fines are closed, but when the issue update fails the librarian repeats the renewal and fines are then recreated (koha finds no open fine, so calculates a new one) Ideally the whole sub would be a transaction -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 28

[Bug 25566] New: Change in DecreaseLoanHighHolds behaviour
by bugzilla-daemon＠bugs.koha-community.org 14 Sep '20

14 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25566 Bug ID: 25566 Summary: Change in DecreaseLoanHighHolds behaviour Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation 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, kyle.m.hall(a)gmail.com bug 25067 made current waiting holds count when determining holdability of an item, this has an effect on decreaseLoanHighHolds. Now when checking out to a patron with a waiting hold we count the loan we are currently issuing and decrease the loan period To recreate: 1 - Find or create a record with 10 items 2 - Set sysprefs: decreaseLoanHighHolds - enable decreaseLoanHighHoldsDuration - 2 decreaseLoanHighHoldsValue - 2 decreaseLoanHighHoldsControl - 'over the number of holdable items'/dynamic 3 - Set circ rules to allow 1 hold per record on the relevant record 4 - Place 3 holds on the record 5 - Check one item in and confirm hold to set to waiting 6 - Issue to the patron with the waiting hold 7 - Get a notice that loan period is decreased -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14

[Bug 23213] New: OPAC check mimimum payment threshold from payment plugin
by bugzilla-daemon＠bugs.koha-community.org 14 Sep '20

14 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23213 Bug ID: 23213 Summary: OPAC check mimimum payment threshold from payment plugin Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: agustinmoyano(a)theke.io QA Contact: testopia(a)bugs.koha-community.org CC: tomascohen(a)gmail.com Blocks: 20211 Target Milestone: --- Add the ability in OPAC to check if the plugin has a minimum payment threshold. If the amount that the patron is lower than the threshold declared by the plugin then payment is not allowed. For example, if PayPal is going to charge $2 for every transaction, don't allow payments through that plugin to be less than $3. The logic to determine the minimum threshold is hold in the plugin itself. Plugins that defines a threshold should declare a new hook named Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20211 [Bug 20211] Guarantor/Guarantee and payments ideas [OMNIBUS] -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 27

[Bug 21872] New: Elasticsearch indexing faster by making it multi-threaded
by bugzilla-daemon＠bugs.koha-community.org 14 Sep '20

14 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21872 Bug ID: 21872 Summary: Elasticsearch indexing faster by making it multi-threaded Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: joonas.kylmala(a)helsinki.fi CC: ere.maijala(a)helsinki.fi, glasklas(a)gmail.com The record prosessing in misc/search_tools/rebuild_elastic_search.pl happens currently single threadeadly, it could be made multithreaded to take full advantage of multicore systems. <ere> says on IRC following about this: "[..] a simple way would be to add start offset and skip count to the indexing script so you could run multiple in parallel" So in the line "while ( my $record = $next->() ) {" the next->() function gets called and that should be possible to multithread. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 83

[Bug 18719] New: Manage staged MARC records, the Job progress bar stuck at 0%
by bugzilla-daemon＠bugs.koha-community.org 13 Sep '20

13 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18719 Bug ID: 18719 Summary: Manage staged MARC records, the Job progress bar stuck at 0% Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: joseanjos(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Following: http://koha.1045719.n5.nabble.com/Problem-on-Staged-MARC-management-td59352… I can upload the Unimarc file, then "Stage for import", but then when I import this batch into the catalog on "Manage staged MARC records", the Job progress bar will keep 0% forever. If I refresh page it shows that the record was staged ok. The problem is related with the Items because when I choose NO on "Check for embedded item record data?" it works, the Job progress bar will go to 100% I've tried other files and with mysql 5.7 or mariDB On /var/log/koha/koha/intranet-error.log [cgi:error] [pid 1580] [client xx.xx.xx.xx:35538] AH01215: [Tue May 30 14:34:16 2017] stage-marc-import.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/MARC/File/XML.pm line 397, <__ANONIO__> chunk 2.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: <a href="http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl">http://yy.yy.yy.yy::8080/cgi-bin/koha/tools/stage-marc-import.pl Trying with bulkmarcimport.pl I have this message: bib-64150.marcxml deleting biblios DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for Statement "truncate biblio"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems` (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`koha_koha`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`)) [for Statement "truncate items"] at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152. Characteristic MARC flavour: UNIMARC . 1 MARC records done in 0.147950887680054 seconds -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 17415] New: Search for parent bib record fails when link clicked in child
by bugzilla-daemon＠bugs.koha-community.org 13 Sep '20

13 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17415 Bug ID: 17415 Summary: Search for parent bib record fails when link clicked in child Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org When a child bib record is linked to a parent bib record, a link to the parent record shows below the child title, such as: Test Fiction Title for Kindle [Coeur d'Alene] [eBook] In: High demand fiction [Coeur d'Alene] Amazon.com, Inc The link below the title to the parent record, such as above in the "In" line is incorrect. When you click on the link, it does a title phrase search, but it is including the 101a field (author), which makes the search fail. Either the 101a field needs to be omitted in a title phrase search, or the search needs to be changed to either a keyword search or a combo search. Seems like this link should go right to the bib record number rather than doing a search of any kind, since it is already linked. Current workaround is to edit the child record and delete the author in the field. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 24694] New: Installing the sample data produces some errors
by bugzilla-daemon＠bugs.koha-community.org 13 Sep '20

13 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24694 Bug ID: 24694 Summary: Installing the sample data produces some errors Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: pasi.kallinen(a)koha-suomi.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Getting the following errors when installing the default sample data: sample_holidays.sql [Thu Feb 20 08:26:09 2020] install.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`repeatable_holidays`, CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE) message_transport_types.sql [Thu Feb 20 08:26:07 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry 'email' for key 'PRIMARY' sample_notices_message_attributes.sql [Thu Feb 20 08:26:10 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry '1' for key 'PRIMARY' sample_notices_message_transports.sql [Thu Feb 20 08:26:10 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry '1-email-0' for key 'PRIMARY' -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 23430] New: News not inserted with SQL strict modes
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '20

10 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23430 Bug ID: 23430 Summary: News not inserted with SQL strict modes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org DBD::mysql::st execute failed: Incorrect integer value: '' for column 'number' at row 1 [for Statement "INSERT INTO opac_news ( title,timestamp,lang,branchcode,content,borrowernumber,number,expirationdate ) VALU ES ( ?,?,?,?,?,?,?,? )" with ParamValues: 0="OpacNavRight", 1='2019-08-05', 2="OpacNavRight_en", 3=undef, 4="<p>this is the opac nav right</p>", 5="51", 6="", 7=undef] at /home/vagrant/kohaclone/C4/NewsChannels. pm line 68. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 25924] New: Broken link on Coce image in staff interface bibliographic detail page
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '20

10 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25924 Bug ID: 25924 Summary: Broken link on Coce image in staff interface bibliographic detail page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 18421 When viewing the bibliographic detail page in the staff interface with Coce images enabled, the Coce cover image is wrapped in a link: <a class="p1" href="/cgi-bin/koha/catalogue/[% DetailPage | html %]?biblionumber=[% biblionumber | url %]"> The "DetailPage" variable hasn't been defined so the link is broken. Rather than fix the variable I suggest we remove the link, since linking to the detail page from the detail page doesn't make any sense. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18421 [Bug 18421] Make Coce cover images available for staff search -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 22582] New: Authority plugin link broken by Bug 22045
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '20

10 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22582 Bug ID: 22582 Summary: Authority plugin link broken by Bug 22045 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: major Priority: P5 - low Component: Cataloging Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Depends on: 22045 Target Milestone: --- The plugin link in the basic MARC editor has an onclick attribute which an element-relative selector to correctly run. The change in HTML structure made by Bug 22045 broke this selection. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22045 [Bug 22045] Cataloging UX enhancement - Improve access to tabs -- You are receiving this mail because: You are watching all bug changes.

1 6