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

[Bug 22760] New: cataloging search yields no results if queryparser is on
by bugzilla-daemon＠bugs.koha-community.org 17 Oct '22

17 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22760 Bug ID: 22760 Summary: cataloging search yields no results if queryparser is on Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: mikael.olangcay-brisebois(a)inLibro.com QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- If QueryParser is on and defaultsortorder is set to relevance,dsc, when you do a cataloging search, first page yields results but other pages don't return any results half the time. It also seems to break the sort by popularity, but that is not adressed by this patch. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14

[Bug 30854] New: Missing description for 'import_record_matches' in swagger.yaml
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30854 Bug ID: 30854 Summary: Missing description for 'import_record_matches' in swagger.yaml Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com CC: tomascohen(a)gmail.com If you look at https://api.koha-community.org/22.05.html you will notice on the left list that 'import_record_matches' doesn't display as the rest of the entries. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 30971] New: Recalls - log viewer error
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30971 Bug ID: 30971 Summary: Recalls - log viewer error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: david(a)davidnind.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com There is an error in the log viewer when displaying the recalls logs on the screen (exporting to a file works though): Template process failed: undef error - The method Koha::Recall->biblionumber is not covered by tests! Trace begun at /kohadevbox/koha/Koha/Object.pm line 875 Koha::Object::AUTOLOAD('Koha::Recall=HASH(0x55da45a77358)') called at /kohadevbox/koha/koha-tmpl/intranet-tmpl/prog/en/modules/tools/viewlog.tt line 385 eval {...} at /kohadevbox/koha/koha-tmpl/intranet-tmpl/prog/en/modules/tools/viewlog.tt line 385 eval {...} at /kohadevbox/koha/koha-tmpl/intranet-tmpl/prog/en/modules/tools/viewlog.tt line 409 eval {...} at /kohadevbox/koha/koha-tmpl/intranet-tmpl/prog/en/modules/tools/viewlog.tt line 18 Template::Provider::__ANON__('Template::Context=HASH(0x55da45d16528)') called at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 163 eval {...} at /usr/lib/x86_64-linux-gnu/perl5/5.32/Template/Document.pm line 161 Templ ..... To replicate: 1. Enable recalls: set UseRecalls system preference to 'Use'. 2. Ensure the RecallsLog system preference is set to 'Log'. 3. Setup recalls circulation and fines rules: . Recalls allowed (total) = 5 . Recalls per record (count) = 2 . On shelf recalls allowed = 'If any unavailable' . Recall due date interval (day) = 3 . Recall overdue fine amount = 5 . Recall pickup period (day) = 2 4. Checkout an item to a patron: - Patron used: Mary Burton (Midway) - Record used: Programming Perl (biblionumber = 262, one item = 39999000011418, home library = Centerville) 5. Change username/password for a patron and login to the OPAC and place a recall for the item in step 4. - Patron used: Henry Acevedo (Midway) 6. View the checkout and details tab for patron used in step 4: . List of checkouts should display correctly . Message in the title column for the item with a recall: This item has been recalled and the due date updated. 7. Go to Tools > Log viewer and press submit (can limit the module to just Recalls if you wish). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 25

[Bug 30912] New: Database update fails for 21.12.00.016 Bug 30060
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30912 Bug ID: 30912 Summary: Database update fails for 21.12.00.016 Bug 30060 Change sponsored?: --- Product: Koha Version: 22.05 Hardware: PC OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: rcooper(a)inceptlabs.com.au QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com This is my first time bug reporting, so please let me know if I'm missing details. Upgrading to 22.05 from 21.12.00.015. OS - Ubuntu v 20.04.4 LTS MySQL Server v 8.0 The koha-common package update installed through Ubuntu apt-get During the Web installer phase, the following error message is generated: Upgrade to 21.12.00.016 [09:03:01]: Bug 30060 - Update user_permissions to add primary key and remove null option from code column ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `PRIMARY`' at line 1 at /usr/share/koha/lib/C4/Installer.pm line 739 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 30

[Bug 30904] New: (bug 24387 follow-up) Modifying library in news (additional contents) causes inconsistencies
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30904 Bug ID: 30904 Summary: (bug 24387 follow-up) Modifying library in news (additional contents) causes inconsistencies Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: januszop(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Modifying an existing element of additional content (News) by changing the library causes a duplication of the entry on the Additional contents (News) list. A subsequent attempt of deleting one of the entries results in deleting both of them. This is due to the fact that after the unwanted duplication all the entries share the same additional_contents.code. A patch will follow. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 23

[Bug 30974] New: Job size not correct for indexing jobs
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30974 Bug ID: 30974 Summary: Job size not correct for indexing jobs Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart+koha(a)gmail.com Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Depends on: 22417 job's size is the number of records to index, but when finished the progress is always set to 1. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22417 [Bug 22417] Add a task queue -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 30677] New: Unknown column 'biblioitem.title' in 'where clause' 500 error in API /api/v1/acquisitions/orders
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30677 Bug ID: 30677 Summary: Unknown column 'biblioitem.title' in 'where clause' 500 error in API /api/v1/acquisitions/orders Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: nugged(a)gmail.com CC: tomascohen(a)gmail.com Depends on: 30165 The exception: [ERROR] GET /api/v1/acquisitions/orders: unhandled exception (DBIx::Class::Exception)<<DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'biblioitem.title' in 'where clause' at /usr/share/perl5/Data/Page.pm line 49 Because here is the experimental dump of what sub table_name_fixer replaces: in: 'q' => '{"-and":[{"basket.vendor_id":2},[[{"basket.name":{"like":"%f%"}}],[{"basket.basket_group.name":{"like":"%f%"}}],[{"me.order_id":{"like":"%f%"}}],[{"biblio.title":{"like":"%f%"}},{"biblio.author":{"like":"%f%"}},{"biblio.isbn":{"like":"%f%"}},{"biblio.publisher":{"like":"%f%"}},{"me.internal_note":{"like":"%f%"}},{"me.vendor_note":{"like":"%f%"}}],[{"me.replacement_price":{"like":"%f%"}}],[{"me.quantity":{"like":"%f%"}}],[{"me.ecost":{"like":"%f%"}}],[{"fund.name":{"like":"%f%"}}]]]}' }; out: 'q' => '{"-and":[{"basket.vendor_id":2},[[{"basket.name":{"like":"%f%"}}],[{"basket.basket_group.name":{"like":"%f%"}}],[{"me.order_id":{"like":"%f%"}}],[{"biblio.biblioitem.title":{"like":"%f%"}},{"biblio.biblioitem.author":{"like":"%f%"}},{"biblio.biblioitem.isbn":{"like":"%f%"}},{"biblio.biblioitem.publisher":{"like":"%f%"}},{"me.internal_note":{"like":"%f%"}},{"me.vendor_note":{"like":"%f%"}}],[{"me.replacement_price":{"like":"%f%"}}],[{"me.quantity":{"like":"%f%"}}],[{"me.ecost":{"like":"%f%"}}],[{"fund.name":{"like":"%f%"}}]]]}' }; That because this: $q =~ s|biblio\.|biblio\.biblioitem\.|g if $q =~ m/.*(isbn|ean|publisher).*/; should be with lookahead to exclude false matches: $q =~ s{biblio\.(?=isbn|ean|publisher)}{biblio\.biblioitem\.}g; Making a fix. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30165 [Bug 30165] Several q parameters break the filters -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 42

[Bug 30848] New: Introduce Koha::Filter::AuthorizedValues
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30848 Bug ID: 30848 Summary: Introduce Koha::Filter::AuthorizedValues Change sponsored?: --- Product: Koha Version: unspecified 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: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org I think we should introduce a Koha::Filter for replacing AV codes with AV values in the MARC::Record.. we already do this using C4::XSLT::transformMARCXML4XSLT but I believe a RecordProcessor makes more sense than to hide the function away in the defunct XSLT module. We can then use this anywhere we have a RecordProcessor instantiated and get the goodness of filtered MARC::Records. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 91

[Bug 31246] New: <span> displayed in 'Additional fields' section
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31246 Bug ID: 31246 Summary: <span> displayed in 'Additional fields' section Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Introduced by bug 30733. -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 31247] New: Staff interface 2FA blocks logging into the OPAC
by bugzilla-daemon＠bugs.koha-community.org 15 Oct '22

15 Oct '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31247 Bug ID: 31247 Summary: Staff interface 2FA blocks logging into the OPAC Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Authentication Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: dpavlin(a)rot13.org I noticed when I turned on the 2FA for my staff account, I'm no longer able to log into the OPAC with that same account. I usually use the same account for both, so I find this a major drawback in using 2FA. To test: 1) With 2FA turned off, log into the staff interface with your staff account --> login is normal 2) With 2FA turned off, log into the OPAC with the same account --> login is normal 3) Turn on 2FA 3.1) In System preferences, enable TwoFactorAuthentication 3.2) Go to 'My account' (click your username in the top right and choose 'My account) 3.3) Click More > Manage two-factor authentication 3.4) Click Enable two-factor authentication 3.5) With an authenticator app (I used FreeOTP) scan the QR code 3.6) Enter the PIN provided by the app in the PIN code field 3.7) Click Register with two-factor app 4) Log out of the staff interface 5) Log into the staff interface --> Username, password and two-factor code is needed 6) Log out of the OPAC 7) Log into the OPAC (I used the login box on the right) --> It cycles back to the login page, you can never log in 8) In the staff interface, disable 2FA 8.1) In 'My account', click More > Manage two-factor authentication 8.2) Click Disable two-factor authentication 9) Log into the OPAC --> login is normal -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21