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

[Bug 19819] New: C4::Context->dbh is unreasonably slow
by bugzilla-daemon＠bugs.koha-community.org 27 Nov '19

27 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19819 Bug ID: 19819 Summary: C4::Context->dbh is unreasonably slow Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: glasklas(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org I have been profiling Koha the last day or so to try to fix some bottlenecks increasing performance of bulk-processing of data. Discovered that C4::Context->dbh was unexpectedly slow (Koha::Database->schema->storage->dbh is the culprit). If it is safe to do so, performance can be greatly improved by locally caching $dbh in a state variable. Patch will be provided shortly. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 19121] New: Prevent XSS in the Staff Client and the OPAC - bis
by bugzilla-daemon＠bugs.koha-community.org 27 Nov '19

27 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19121 Bug ID: 19121 Summary: Prevent XSS in the Staff Client and the OPAC - bis Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org On bug 13618 we tried to escape variables at template level: all variables were escaped using Template::Stash::AutoEscaping::Escaped::HTML::escape It works well, but unfortunately it leads to performance issues (see bug 15715). Indeed in some scripts, 70k variables are displayed Another approach would be to escape variables when they are sent to the scripts. We will get only 1 call per variable passed to the script and we will not escape unnecessarily variables several times, or variables coming from the DB (maybe we will need a script to clean the data?) -- You are receiving this mail because: You are watching all bug changes.

1 15

[Bug 19016] New: Add a script to fix corrupted data
by bugzilla-daemon＠bugs.koha-community.org 27 Nov '19

27 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19016 Bug ID: 19016 Summary: Add a script to fix corrupted data Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Depends on: 18966 We must provide a fix to deal with corrupted data. For more information, see bug 18966 and https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 [Bug 18966] Move of checkouts - Deal with duplicate IDs at DBMS level -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 28

[Bug 17851] New: Add elasticsearch config to koha-conf.xml
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17851 Bug ID: 17851 Summary: Add elasticsearch config to koha-conf.xml Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt(a)gmail.com Reporter: olli-antti.kivilahti(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org Following the Elasticsearch installation instructions from: https://wiki.koha-community.org/wiki/Elasticsearch the <elasticsearch> config seems to be missing. This patch adds interactive Elasticsearch-questions to the Makefile.PL to configure ES. -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 18930] New: Move lost item refund rules to circulation_rules table
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18930 Bug ID: 18930 Summary: Move lost item refund rules to circulation_rules table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org This patch will move the list item refund rules from a dedicated table to the circulation_rules table. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 89

[Bug 15689] New: Label editor: Fix issues with wrong batch_id parameter
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '19

21 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15689 Bug ID: 15689 Summary: Label editor: Fix issues with wrong batch_id parameter Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Label/patron card printing Assignee: cnighswonger(a)foundations.edu Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org There are issues with the label editor, related to the batch_id: 1/ You can select all the items and click on "remove selected" without any warning 2/ You can delete the last item clicking on the "Delete" button ("actions" column) In these 2 cases, the batch_id parameter is passed but is wrong. If you add a new batch on the resulting screen, the batch_id of the deleted batch will be displayed, but a new one will be used. Copied from the comment by Jonathan Druart on Bug 15663 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15663#c7 -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 18765] New: Bad cardnumber causes 'Borrower' search to fail
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '19

21 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18765 Bug ID: 18765 Summary: Bad cardnumber causes 'Borrower' search to fail Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: mtj(a)kohaaloha.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 64122 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=64122&action=ed… pic to test bug.. 1/ add a leading TAB character to a borrower's cardnumber 2/ attempt to search for that user 3/ observe that no results are displayed (see pic) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 18868] New: Pay Selected doesn
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '19

21 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18868 Bug ID: 18868 Summary: Pay Selected doesn Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: edischer(a)cityoffargo.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 6

[Bug 16102] New: Import batch into catalog very slow
by bugzilla-daemon＠bugs.koha-community.org 21 Nov '19

21 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16102 Bug ID: 16102 Summary: Import batch into catalog very slow Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic record staging/import Assignee: gmcharlt(a)gmail.com Reporter: tejoskumar(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Dear team, The batch import into catalog is very slow when compared to 3.20 version in 3.22.4. I used the same machine for the same number of records in koha 3.22 and it takes almost 8 hours to import the data for 30000 records. In 3.20 it was taking only 30 minutes to 1 hour for this activity to be completed. Using Ubuntu 14.04 and 4GB ram machine for importing the data and this is a fresh installation of ubuntu and koha. Iam not sure if this is a issue with KOHA or issue with my koha settings. I already reported in the koha mailing list for any solution to overcome the issue, but not received any response, hence posting it here. Thanks & regards Suresh Kumar -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 17422] New: Holds amount per record produce error
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17422 Bug ID: 17422 Summary: Holds amount per record produce error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: jesse(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 56127 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=56127&action=ed… Screen shot of settings In the circulation and fines rules module, If you set Holds allowed count & Holds per record count for a circulation rule to each 999, koha will produce a template error. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2