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

[Bug 15342] Performance 3.22 - Omnibus
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15342 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=27341 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 7923] Performance omnibus
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7923 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=27341 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 17819] New: Performance 16.11 - Omnibus
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17819 Bug ID: 17819 Summary: Performance 16.11 - Omnibus Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement 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 https://wiki.koha-community.org/wiki/Benchmark_for_16.11 -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 25896] New: Missing closing </td> tag in smart-rules.tt
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25896 Bug ID: 25896 Summary: Missing closing </td> tag in smart-rules.tt Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: trivial Priority: P5 - low Component: Templates Assignee: slavashishkin(a)gmail.com Reporter: nugged(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: jonathan.druart(a)bugs.koha-community.org, julian.maurice(a)biblibre.com, martin.renvoize(a)ptfs-europe.com, stalkernoid(a)gmail.com Depends on: 21395 File: koha-tmpl/intranet-tmpl/prog/en/modules/admin/smart-rules.tt with adding of "daysmode" block just have one lost closing </td> tag: <td> [% SWITCH daysmode %] ... <td> all other <td> tags we have there are closed, yet modern browsers even "fixes" this on the fly so nothing to check visually or to spot any changes, so fix is even have no "browser" test procedure: just go wget/curl and compare generated htmls :)... heh :). Longer describe than fix :) Slava, please just post a quick fix commit. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21395 [Bug 21395] Make perlcritic happy -- You are receiving this mail because: You are watching all bug changes.

1 15

[Bug 13751] "Begins with" search not possible with ICU indexing
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13751 --- Comment #18 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- (In reply to David Cook from comment #17) > (In reply to Katrin Fischer from comment #0) > > With ICU activated, a "begins with" search like ti,ext= will return the same > > results as a ti= search. > > > > This is a problem for libraries with big collections where a title you look > > for can be pretty unspecific and you need a way to do more exact searches. > > Are you referring to manual/free-hand searches and not searches > automatically generated by Koha? > > If so, then this bug should be resolved by Bug 27299. That's good to know and I am actually very happy to see it and some other old glitches resolved! Shoudl we close this MOVED or duplicate? When I commented last night I didn't realize that I was the original bug author - it's been a while :) -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 27103] New: Adding a hold cancellation reason should not always send a notice
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27103 Bug ID: 27103 Summary: Adding a hold cancellation reason should not always send a notice Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Bug 25534 adds the option to record the reason a hold was cancelled. It also always triggers the HOLD_CANCELLATION notice to be sent if a reason is defined. Say the patron called and will not be able to pick up numerous holds for some time. You cancel them all with "patron requested cancellation" but don't want to send multiple notices. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 22

[Bug 26622] New: Unique Constraint on Authorised Values conflicts with use of Report Subgroup category
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26622 Bug ID: 26622 Summary: Unique Constraint on Authorised Values conflicts with use of Report Subgroup category Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: joy(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Bug 22887 introduced a unique constraint on authorised values category/code. However, this causes problems for the existing use of Report Subgroups. There are many sites that use the same code in Report Subgroups that relate to different Report Groups (tied via reports_subgroup lib opac value). Example: category, code, description, lib_opac Report Group, TECH, technical services, Report Group, CIRC, Circulation department, Report Subgroup, RENEWALS, Renewal stats, TECH Report Subgroup, RENEWALS, Renewal circ stats, CIRC It is entirely possible to have two Report Subgroups with the same code that relate to different Report Groups as seen in the above example. Report Group and Subgroup functionality needs to be removed from the authorised values module and a new module/database created for it. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 7047] Renewing serials note not visible
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7047 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |27332 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27332 [Bug 27332] When renewing a serial subscription library from subscripton is not used -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 27302] New: couldn't view biblio.author on reports
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27302 Bug ID: 27302 Summary: couldn't view biblio.author on reports Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: nishathahmed(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 114662 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114662&action=e… Koha-report hi There, I just want to take report of item bar code and author of book. I can get barcode and failed to fetch author by executing following SQL SELECT items.barcode, biblio.author FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) GROUP BY items.barcode,biblio.author. I get empty column on author when I execute this SQL statement. I entered my catalogue entry on fast add framework with statement of responsibility as author. But still no luck. You can refer attachments of output. Correct me if I am wrong or raise as bug. Thanks! Nishath -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 27303] New: Behaviour depends on DB user permissions
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27303 Bug ID: 27303 Summary: Behaviour depends on DB user permissions Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org I was writing a helper method to check if a table is a view, for the merger of 'reserves' and 'old_reserves' into 'holds', and found that running things like [1]: my $sth = $dbh->prepare(" SELECT COUNT( * ) AS count FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'reserve_id' AND ( TABLE_NAME LIKE 'reserves' OR TABLE_NAME LIKE 'old_reserves' ) "); Will give different results depending on the user permissions. So if (for some reason) the sysadmin sets two Koha instances on the same DB server, and the user has more privileges than expected, it will count things from databases other than those of the running instance. In the case of the views this was easy to spot: root@kohadevbox:misc4dev(master)$ mysql -hdb -ppassword Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 232 Server version: 10.3.27-MariaDB-1:10.3.27+maria~focal mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.tables WHERE TABLE_NAME='reserves'; +--------------+------------+ | TABLE_SCHEMA | TABLE_NAME | +--------------+------------+ | koha_test | reserves | | koha_kohadev | reserves | +--------------+------------+ 2 rows in set (0.02 sec) What we need to do, is adding the database name on the WHERE condition, like: my $db_name = C4::Context->config('database'); ... WHERE TABLE_SCHEMA=$db_name; [1] taken from updatedatabase.pl:5573~5582 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2