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

[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 19618] New: Automatic/standing holds
by bugzilla-daemon＠bugs.koha-community.org 04 Jan '21

04 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19618 Bug ID: 19618 Summary: Automatic/standing holds Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jesse(a)bywatersolutions.com Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org 1) Add a pulldown and button labeled "Add randomized holds" to the holds page for each bib -- You are receiving this mail because: You are watching all bug changes.

1 67

[Bug 24061] New: Print List (opac-shelves.pl) broken in Chrome
by bugzilla-daemon＠bugs.koha-community.org 04 Jan '21

04 Jan '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24061 Bug ID: 24061 Summary: Print List (opac-shelves.pl) broken in Chrome Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: lucas(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org In Chrome if you try to print a public list from the OPAC the new tab is immediately closed by Chrome. TO TEST: -set up a new public list with a few items -go to the OPAC and view that list. -Click 'Print List' in Chrome. -The tab opens but immediately closes itself. -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 13985] Cash Management - Koha as 'Point of Sale'
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|26161 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26161 [Bug 26161] Confirm and cancel buttons should be underneath the right hand form on the POS page -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 26161] New: Confirm and cancel buttons should be underneath the right hand form on the POS page
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26161 Bug ID: 26161 Summary: Confirm and cancel buttons should be underneath the right hand form on the POS page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org Depends on: 23354 Blocks: 13985 Currently the final submit buttons for the Point of Sale screen are left-aligned beneath the 'Items for purchase' part of the form.. they should be right-aligned and placed beneath the 'This sale' and 'Collect payment' form fieldsets instead. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 [Bug 13985] Cash Management - Koha as 'Point of Sale' https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23354 [Bug 23354] Add a 'Point of sale' screen to allow anonymous payments -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15

[Bug 13985] Cash Management - Koha as 'Point of Sale'
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|27289 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27289 [Bug 27289] Template tweaks for point of sale page -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13985] Cash Management - Koha as 'Point of Sale'
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|27256 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27256 [Bug 27256] "Add" button on point of sale page fails on table paging -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13985] Cash Management - Koha as 'Point of Sale'
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |27290 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27290 [Bug 27290] Cash register allows for 'amount tendered' less than amount being paid -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13985] Cash Management - Koha as 'Point of Sale'
by bugzilla-daemon＠bugs.koha-community.org 31 Dec '20

31 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |27289 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27289 [Bug 27289] Template tweaks for point of sale page -- You are receiving this mail because: You are watching all bug changes.

1 0