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@lists.koha-community.org Reporter: snicker1@maine.rr.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@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.