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

[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

[Bug 11299] Add a button to automatically link authority records in cataloguing (AJAX)
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11299 --- Comment #190 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- I've opened bug 27337 for the existing calls. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 1807] search () give odd results with Zebra and ICU
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1807 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 1807] search () give odd results with Zebra and ICU
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1807 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook(a)prosentient.com.au --- Comment #23 from David Cook <dcook(a)prosentient.com.au> --- I can't reproduce this problem in Zebra 2.0.59 when using ICU using the following queries: http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=cd http://localhost:8081/cgi-bin/koha/catalogue/search.pl?q=%28cd%29 If someone can provide me with the steps to reproduce the problem, I could look into this more. -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |27299 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27299 [Bug 27299] Zebra phrase register is incorrectly tokenized when using ICU -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11158] Authorities 'starts with' search returns the same as 'contains' when using ICU
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11158 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #22517|0 |1 is obsolete| | --- Comment #11 from David Cook <dcook(a)prosentient.com.au> --- Created attachment 114829 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114829&action=e… Bug 11158: Add complete field to authority "starts with" search This patch adds "complete field" to the authority "starts with" search so that it uses the untokenized "p" register. Test plan: 1. Apply the patch 2. koha-plack --restart kohadev 3. Go to http://localhost:8081/cgi-bin/koha/authorities/authorities-home.pl 4. Type in "Espen" into the search box and hit "Submit" 5. Note that there are 3 results 6. Change "contains" to "starts with" and hit "Submit" 7. Note that no results are returned 8. Change the search from "Espen" to "Sandberg" and hit "Submit" 9. Note that 3 results are returned 10. Experiment to your heart's content and rejoice at your new found power -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11158] Authorities 'starts with' search returns the same as 'contains' when using ICU
by bugzilla-daemon＠bugs.koha-community.org 05 Jan '21

05 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11158 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0