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

[Bug 23086] New: Search for collection is broken
by bugzilla-daemon＠bugs.koha-community.org 18 Sep '20

18 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23086 Bug ID: 23086 Summary: Search for collection is broken Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Searching - Zebra Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de Target Milestone: --- We have seen this issue in a 17.11 installation, but not in a newer 18.11. I believe that Zebra version and using/not using ICU might play a role here. When looking into it, we were able to fix the issue removing the lines adding quotes to the search in Search.pm: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=C4/Search.pm;h=41… The quotes appear to be the issue, as a simple search using mc-ccode: without quotes works. This problem has also been reported on the mailing list: https://lists.katipo.co.nz/pipermail/koha/2019-June/053081.html Setting to major as this effects a major feature in the OPAC. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 33

[Bug 18924] New: De-activating a course reserve does not update zebraqueue.
by bugzilla-daemon＠bugs.koha-community.org 18 Sep '20

18 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18924 Bug ID: 18924 Summary: De-activating a course reserve does not update zebraqueue. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Course reserves Assignee: koha-bugs(a)lists.koha-community.org Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Changes made to an item on course reserve are not reflected in zebra when the course is made inactive. Steps to reproduce: 1) Set up a course in course reserves 2) Add items to the course reserve 3) Make the course active. 4) Change values at the item level that will show up in the search results -- e.g. shelving location, notforloan. These values will remain until the course is made inactive. 5) Set the course as inactive. The changed values will revert back to their original settings, but search results will still show the values of the active reserves. 6) Note that zebraqueue is not updated for the associated bib. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 6

[Bug 16686] New: Fix "Item in transit from since" in Holds tab
by bugzilla-daemon＠bugs.koha-community.org 17 Sep '20

17 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16686 Bug ID: 16686 Summary: Fix "Item in transit from since" in Holds tab Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org "From branch" and date do not show up in patron's "Holds" tab: "Item in transit from since" OPAC log: opac-user.pl: No method frombranch! at /usr/share/kohaclone/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-user.tt line 607 This is related to Bug 13918 (see comment #3 in Bug 16680) -- You are receiving this mail because: You are watching all bug changes.

1 47

[Bug 17247] New: ILS-DI HoldTitle and HoldItem should check if patron is debarred
by bugzilla-daemon＠bugs.koha-community.org 15 Sep '20

15 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17247 Bug ID: 17247 Summary: ILS-DI HoldTitle and HoldItem should check if patron is debarred Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Web services Assignee: julian.maurice(a)biblibre.com Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 40

[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 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 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