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

[Bug 30852] New: article_requests missing index on debit_id
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30852 Bug ID: 30852 Summary: article_requests missing index on debit_id Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Bug 27946 added foreign key in article_requests on debit_id. This column needs a performance index. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 27619] New: Remove de-DE installer data
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27619 Bug ID: 27619 Summary: Remove de-DE installer data Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: bgkriegel(a)gmail.com, gmcharlt(a)gmail.com, jonathan.druart(a)bugs.koha-community.org, katrin.fischer(a)bsz-bw.de, lucas(a)bywatersolutions.com, martin.renvoize(a)ptfs-europe.com, testopia(a)bugs.koha-community.org, victor(a)tuxayo.net Depends on: 24972, 24973, 24871 +++ This bug was initially created as a clone of Bug #24897 +++ Now we can translate all installer data, then the fr-FR directory is no longer needed. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24871 [Bug 24871] Add new *-installer-*.po translation files https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24972 [Bug 24972] Remove de-DE installer data https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24973 [Bug 24973] Allow to localize and translate system preferences with new yaml based installer -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 37

[Bug 16520] New: Per-virtualhost SetEnvs don't work with Plack
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16520 Bug ID: 16520 Summary: Per-virtualhost SetEnvs don't work with Plack Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jweaver(a)bywatersolutions.com Reporter: jweaver(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The various SetEnvs that can be used in Koha to configure memcached, change search limits, override sysprefs and add custom stylesheets don't work in Plack. It is likely impossible to fix this with the current HTTP proxy setup, so we need a workaround. -- You are receiving this mail because: You are watching all bug changes.

1 46

[Bug 23263] New: RecordedBooks shows 'Check out' button for unavailable items
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23263 Bug ID: 23263 Summary: RecordedBooks shows 'Check out' button for unavailable items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The recorded books code checks if the current patron has a specific item checked out, if not it shows a checkout button. We should instead check the availability of the item and only show a button if it is available. Currently RB digital results don't have this information: https://gitlab.com/srdjan-catalyst/webservice-ils/merge_requests/1 -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 22028] New: RecordedBooks integration with audio and magazine titles
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22028 Bug ID: 22028 Summary: RecordedBooks integration with audio and magazine titles Change sponsored?: --- Product: Koha Version: 18.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: jzairo(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Currently, the Recorded Books integration from [17602] Integrates support for RecordedBooks (formerly OneClickDigital) API integrates ebook titles. Audiobooks and magazines would be a good enhancement to be searched and circulated with this integration. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 30449] New: Missing FK constraint on borrower_attribute_types
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30449 Bug ID: 30449 Summary: Missing FK constraint on borrower_attribute_types Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Not in kohastructure, but present for a long time already in updatedatabase: $DBversion = "3.07.00.034"; $dbh->do("ALTER TABLE borrower_attribute_types ADD CONSTRAINT category_code_fk FOREIGN KEY (category_code) REFERENCES categories(categorycode)"); -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 30

[Bug 21586] New: Add generic OpenIDConnect client implementation
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '22

24 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21586 Bug ID: 21586 Summary: Add generic OpenIDConnect client implementation Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Authentication Assignee: koha-bugs(a)lists.koha-community.org Reporter: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org CC: dpavlin(a)rot13.org It would be great to have a generic OpenIDConnect client that anyone could point at any OpenIDConnect server for authentication. Years ago, I wrote this software client for a client that needed to connect to 2 different upstream servers. More recently, I've re-used the code for a different client with a different upstream server. The first third-party server wasn't compliant to the standard, so there are some hacks in my code, but the second latest third-party server does seem compliant, so you should be able to use this code legitimately without compromising as well. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 23

[Bug 28696] New: Point of sale: attempting to pay with the "Enter" key cause an overcharge in the database
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '22

23 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28696 Bug ID: 28696 Summary: Point of sale: attempting to pay with the "Enter" key cause an overcharge in the database Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: marie-luce.laflamme(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org This problem occurs if you forget to fill in the collect payment fields, then press on the “Enter” key. When a message Required field shows up, the payment will not be saved correctly in the database. Instead, Koha secretly charges the failed payment in the database before confirming the real payment on the web interface. E.g . If the item cost = $1 and you press 3 times «Enter» with missing payment fields, the web interface and receipt confirm a $1 payment, while the database register a $3 payment (3 X $1 ) for the same transaction id. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 9

[Bug 30478] New: Unexpected behavior in patrons' accounts when un-losing items via batch item modification
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '22

23 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30478 Bug ID: 30478 Summary: Unexpected behavior in patrons' accounts when un-losing items via batch item modification Change sponsored?: --- Product: Koha Version: 21.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: sbrown(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org If circulation rules allow refunds on returns and MarkLostItemsAsReturned is set to return from batch mod, an item that is charged as Lost to a patron's account will have the replacement fee removed if that item is un-lost through batch item modification. Additionally, if the item is still checked out, it will be returned/removed from their account. Scenario 1: -Set 'Lost item fee refund on return policy' to 'Refund lost item charge' -Set MarkLostItemsAsReturned to 'from the batch item modification tool' -Check item out to patron -Lose item from Items tab (items are *not* returned when marked lost on Items tab per MarkLostItemsAsReturned) -In patron's account, verify that item is still checked out to patron with lost status applied, and that replacement fee is charged to their account -In bib, verify that item shows as Lost and checked out -In Batch Item Modification, delete lost status (no other changes made) -In patron's account, note that item is no longer checked out and the replacement fee has been removed. The Accounts tab indicates that the item was returned. -In bib, item status is Lost but the item is no longer marked as checked out. Scenario 2: -Set 'Lost item fee refund on return policy' to 'Refund lost item charge' -Set MarkLostItemsAsReturned to 'from the batch item modification tool' and 'from the items tab of the catalog module' -Check item out to patron -Lose item from Items tab -In patron's account, verify that item is no longer checked out, and that replacement fee is charged to their account -In bib, verify that item shows as Lost but not checked out -In Batch Item Modification, delete lost status (no other changes made) -In patron's account, note that the replacement fee has been removed. The Accounts tab indicates that the item was returned. -In bib, item status is Available -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 30620] New: Add a warning close to /*!VERSION lines in kohastructure.sql
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '22

23 Jun '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30620 Bug ID: 30620 Summary: Add a warning close to /*!VERSION lines in kohastructure.sql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org These first lines in kohastructure are just ignored by DBIx::RunSQL. They could serve a purpose however when running the file directly on the sql command line. So we should at least add a comment to warn people. On bug 26947 some of these settings are taken over in C4::Installer::load_db_schema. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 15