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

[Bug 32242] New: The job has not been sent to the message broker: (Wide character in syswrite ... )
by bugzilla-daemon＠bugs.koha-community.org 22 Dec '22

22 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32242 Bug ID: 32242 Summary: The job has not been sent to the message broker: (Wide character in syswrite ... ) Change sponsored?: --- Product: Koha Version: master 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: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org The full version: [2022/11/17 08:51:39] [WARN] The job has not been sent to the message broker: (Wide character in syswrite at /usr/lib/x86_64-linux-gnu/perl-base/IO/Handle.pm line 200.) at /usr/share/koha/Koha/BackgroundJob.pm line 147. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 40

[Bug 31061] New: OPACSuppress does not work properly with Elasticsearch
by bugzilla-daemon＠bugs.koha-community.org 22 Dec '22

22 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31061 Bug ID: 31061 Summary: OPACSuppress does not work properly with Elasticsearch Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com OPACSuppress is system preference to hide records in OPAC search by adding a limit in search query. With Zebra, this limit is : not Suppress=1 https://git.koha-community.org/Koha-community/Koha/src/commit/244b847a08bf6… With Elasticsearch this limit is currently quite different : suppress:false https://git.koha-community.org/Koha-community/Koha/src/commit/244b847a08bf6… Main problem is that in default framework we define Suppress search field on 942$n with authorized values YES_NO. This generates records with 1 for YES and 0 for NO. But a boolean for Elasticsearch is not a perl boolean. So only missing subfield means false : https://www.elastic.co/guide/en/elasticsearch/reference/6.8/boolean.html Records with 0 are hidden ! Another side-effect : We whould like to have several MARC fields with 'suppress' search field. To distinguish several causes of hidden at OPAC. Any of those fields having 1 must hide at OPAC. So syntax 'NOT(suppress:1)' is more correct. I propose we change to have the same behavior as Zebra. Change 'suppress' search field to not remove boolean type. Change QueryBuilder to use 'NOT(suppress:1)'. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 14

[Bug 32080] New: Public lists not available after recent upgrade
by bugzilla-daemon＠bugs.koha-community.org 21 Dec '22

21 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32080 Bug ID: 32080 Summary: Public lists not available after recent upgrade Change sponsored?: --- Product: Koha Version: 22.05 Hardware: All OS: Linux Status: NEW Severity: major Priority: P5 - low Component: Lists Assignee: koha-bugs(a)lists.koha-community.org Reporter: snicker1(a)maine.rr.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl I recently upgraded the Debian package version from 19.11.03.000 to the latest 22.05.04.000 (including the underlying OS upgrades as well) and now no one is able to view any of the "Public Lists" and get a 500 error when trying. Opac-error.log shows this ("USERID" is my userid and "WEBSITE" is the hostname in the messages below): Mon Oct 24 17:44:32.268569 2022] [cgi:error] [pid 22000] [client x.x.x.x:5322] AH01215: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 96: /usr/share/koha/opac/cgi-bin/opac/opac-suggestions.pl [Mon Oct 24 17:44:39.651936 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Use of inherited AUTOLOAD for non-method Koha::Virtualshelf::haspermission() is deprecated at /usr/share/koha/lib/Koha/Virtualshelf.pm line 247.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://WEBSITE/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.652426 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] AH01215: Template process failed: undef error - Can't locate object method "_columns" via package "USERID" (perhaps you forgot to load "USERID"?) at /usr/share/koha/lib/Koha/Object.pm line 858.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://WEBSITE/cgi-bin/koha/opac-shelves.pl?op=list&public=1 [Mon Oct 24 17:44:39.695408 2022] [cgi:error] [pid 21984] [client x.x.x.x:56417] End of script output before headers: opac-shelves.pl, referer: http://WEBSITE/cgi-bin/koha/opac-shelves.pl?op=list <http://WEBSITE/cgi-bin/koha/opac-shelves.pl?op=list&public= 1> &public=1 I did look in the database itself and do find a count of 93 items in the 'virtualshelves' table. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 12029] Patrons should be able to delete their patron messages
by bugzilla-daemon＠bugs.koha-community.org 21 Dec '22

21 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12029 Lucas Gass <lucas(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas(a)bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13976] Sorting search results by popularity is alphabetical
by bugzilla-daemon＠bugs.koha-community.org 21 Dec '22

21 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13976 --- Comment #13 from Fridolin Somers <fridolin.somers(a)biblibre.com> --- Hi, Why does patch impact koha-tmpl/intranet-tmpl/prog/en/xslt/MARC21slim2intranetDetail.xsl ? For the records here is the Zebra doc in attribute 4 : https://software.indexdata.com/zebra/doc/querymodel-rpn.html#querymodel-bib… -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 32497] New: Updating Database Structure fails with table "specified twice"
by bugzilla-daemon＠bugs.koha-community.org 19 Dec '22

19 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32497 Bug ID: 32497 Summary: Updating Database Structure fails with table "specified twice" Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: hannah.co(a)northwestu.edu QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Upgrading from 22.05 to 22.11, the web installer is failing at "Updating database structure" with the following error: Upgrade to 22.06.00.064 [11:24:08]: Bug 14783 - Allow patrons to change pickup location for non-waiting holds ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table 'systempreferences' is specified twice, both as a target for 'UPDATE' and as a separate source for data at /usr/share/koha/lib/C4/Installer.pm line 739 Added new system preference 'OPACAllowUserToChangeBranch' ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table 'systempreferences' is specified twice, both as a target for 'UPDATE' and as a separate source for data at /usr/share/koha/lib/C4/Installer.pm line 739 I am looking for a solution to this one, and not finding much that's helpful. Does installer.pm need modification, or does the database need some changes. Prior to the error I followed steps to resolve errors related to bug 32399, with errors on the issues table and a couple foreign keys. I don't see how the systempreferences table is related, though. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 3249] LOST is not triggering replacement charge on checked out items
by bugzilla-daemon＠bugs.koha-community.org 19 Dec '22

19 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3249 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|21996 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21996 [Bug 21996] SPAM -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 21996] SPAM
by bugzilla-daemon＠bugs.koha-community.org 19 Dec '22

19 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21996 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|3249 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3249 [Bug 3249] LOST is not triggering replacement charge on checked out items -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 3249] LOST is not triggering replacement charge on checked out items
by bugzilla-daemon＠bugs.koha-community.org 19 Dec '22

19 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3249 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21996 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21996 [Bug 21996] SPAM -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 21996] SPAM
by bugzilla-daemon＠bugs.koha-community.org 19 Dec '22

19 Dec '22

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21996 Owen Leonard <oleonard(a)myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|32496 |3249 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3249 [Bug 3249] LOST is not triggering replacement charge on checked out items https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32496 [Bug 32496] Reduce unnecessary unblessings of objects in Circulation.pm -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0