Re: [Koha] Public list issue after recent upgrade
This may be a no-brainer, but did you clear your cache on your browser? ___________________________ Christopher Brannon IT Coordinator 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon@cdalibrary.org www.cdalibrary.org Keep tabs on us at: ------------------------------ Message: 8 Date: Mon, 24 Oct 2022 17:49:21 -0400 From: "Steve Nickerson" <stevenanickerson@gmail.com> To: "'koha'" <koha@lists.katipo.co.nz> Subject: [Koha] Public list issue after recent upgrade Message-ID: <00c301d8e7f2$79e25e90$6da71bb0$@gmail.com> Content-Type: text/plain; charset="us-ascii" 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 ("stnick" is my userid 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://koha.harrison.lib.me.us/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 "stnick" (perhaps you forgot to load "stnick"?) at /usr/share/koha/lib/Koha/Object.pm line 858.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer: http://koha.harrison.lib.me.us/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://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list <http://koha.harrison.lib.me.us/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. Anyone have any suggestions? Thanks! Steve ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 204, Issue 21 *************************************
Yes I do clean everymonth On Tue, Oct 25, 2022 at 10:10 PM BRANNON, CHRISTOPHER < CBRANNON@cdalibrary.org> wrote:
This may be a no-brainer, but did you clear your cache on your browser?
___________________________ Christopher Brannon IT Coordinator
702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon@cdalibrary.org www.cdalibrary.org Keep tabs on us at:
------------------------------
Message: 8 Date: Mon, 24 Oct 2022 17:49:21 -0400 From: "Steve Nickerson" <stevenanickerson@gmail.com> To: "'koha'" <koha@lists.katipo.co.nz> Subject: [Koha] Public list issue after recent upgrade Message-ID: <00c301d8e7f2$79e25e90$6da71bb0$@gmail.com> Content-Type: text/plain; charset="us-ascii"
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 ("stnick" is my userid 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://koha.harrison.lib.me.us/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 "stnick" (perhaps you forgot to load "stnick"?) at /usr/share/koha/lib/Koha/Object.pm line 858.: /usr/share/koha/opac/cgi-bin/opac/opac-shelves.pl, referer:
http://koha.harrison.lib.me.us/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://koha.harrison.lib.me.us/cgi-bin/koha/opac-shelves.pl?op=list < http://koha.harrison.lib.me.us/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.
Anyone have any suggestions?
Thanks!
Steve
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 204, Issue 21 ************************************* _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)
participants (2)
-
BRANNON, CHRISTOPHER -
Himanshu Aggarwal