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

[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 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 19269] New: Advanced Editor - Rancor - Add ability to search batches by lccn and pubdate
by bugzilla-daemon＠bugs.koha-community.org 10 Sep '20

10 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19269 Bug ID: 19269 Summary: Advanced Editor - Rancor - Add ability to search batches by lccn and pubdate Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl This patchset add two columns to import biblios to allow for searching on these values, it should allow for future use in matching and expanded display to give more record feedback -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14

[Bug 17762] New: Ability to translate notices
by bugzilla-daemon＠bugs.koha-community.org 09 Sep '20

09 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17762 Bug ID: 17762 Summary: Ability to translate notices Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Notices Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org If a library has students/patrons from different countries, they will all receive the same notices. At the moment they are not translatable. An improvement would be to let the library translate the notices in different languages. This bug will get patches to achieve this goal. -- You are receiving this mail because: You are watching all bug changes.

1 79

[Bug 17492] New: Show warning if patron's age is out of category limits
by bugzilla-daemon＠bugs.koha-community.org 09 Sep '20

09 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17492 Bug ID: 17492 Summary: Show warning if patron's age is out of category limits Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: rbit(a)rbit.cz QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If a patron's age is out of limits if an assigned category, there should be a warning similar to outstanding fees. Add a button allowing to change the category as well. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 107

[Bug 20469] New: Add item status to staff article requests form
by bugzilla-daemon＠bugs.koha-community.org 04 Sep '20

04 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20469 Bug ID: 20469 Summary: Add item status to staff article requests form Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The Article Requests feature does not look at item status. When you want to process a request, it is useful to show a few fundamental item statuses like Checked out, On hold or Available. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 62

[Bug 16466] New: Patron discharge page should show pending requests
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16466 Bug ID: 16466 Summary: Patron discharge page should show pending requests Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/members/discharge.pl OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If a patron has requested a discharge via the OPAC, that request does not show up on their discharge page in the staff client. I think it should. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 6

[Bug 19967] New: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19967 Bug ID: 19967 Summary: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: ulrich.kleiber(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In this particular case you get the mysql error message: Illegal mix of collations for operation 'like' You can prevent this error by removing dateofbirth from DefaultPatronSearchFields or by the following patch: diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index 2446703..ba32a12 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -117,7 +117,12 @@ sub search { my @where_strs_or; for my $searchfield ( split /,/, $searchfields->{$searchfieldstype} ) { - push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + if ( $searchfield eq 'dateofbirth' ) { + push @where_strs_or, "DATE_FORMAT(borrowers." . $dbh->quote_identifier($searchfield) . ", '%Y-%m-%d') LIKE ?"; + } else { + push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + } + push @where_args, $term; } -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10