[Koha] Error 500 search not working

[Vimal Kumar V.]

Dear Friends,
Koha version 21.05.5.
Xubuntu 20.04 LTS

I got the following error when searching for the barcode in Advanced search.
The same problem when searching barcoded in the search bar.

An error has occurred!
Error 500
This message may have been caused by any of the following reasons:
You made use of an external link to an item that is no longer available
You followed an outdated link e.g. from a search engine or a bookmark
You tried to access a page that needs authentication
An internal link in the client is broken and the page does not exist

This is the error log. I could not interpret the log entries. Please help
me to solve the error.

[Fri Nov 26 14:10:04.628073 2021] [cgi:error] [pid 25265] [client
127.0.0.1:47400] AH01215: No method count found for Koha::Virtualshelves
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Unknown column 'me.created_on' in 'field list' [for
Statement "SELECT COUNT( * ) FROM (SELECT `me`.`shelfnumber`,
`me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`,
`me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`,
`me`.`allow_change_from_others` FROM `virtualshelves` `me` WHERE ( ( ( (
`me`.`allow_change_from_owner` = ? AND `me`.`owner` = ? ) OR
`me`.`allow_change_from_others` = ? ) AND `category` = ? ) ) GROUP BY
`me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`,
`me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`,
`me`.`allow_change_from_owner`, `me`.`allow_change_from_others`) `me`" with
ParamValues: 0=1, 1=1354, 2=1, 3=2] at /usr/share/koha/lib/Koha/Objects.pm
line 601: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer:
http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl
[Fri Nov 26 14:10:04.628152 2021] [cgi:error] [pid 25265] [client
127.0.0.1:47400] AH01215:  at
/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/cat-toolbar.inc
line 157.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer:
http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl
[Fri Nov 26 14:10:04.637228 2021] [cgi:error] [pid 25265] [client
127.0.0.1:47400] AH01215: Template process failed: undef error -
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Unknown column 'me.created_on' in 'field list' [for
Statement "SELECT `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`,
`me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`,
`me`.`allow_change_from_owner`, `me`.`allow_change_from_others` FROM
`virtualshelves` `me` LEFT JOIN `virtualshelfcontents`
`virtualshelfcontents` ON `virtualshelfcontents`.`shelfnumber` =
`me`.`shelfnumber` WHERE ( ( `biblionumber` = ? AND `category` = ? ) )"
with ParamValues: 0="22320", 1=2] at /usr/share/koha/lib/Koha/Objects.pm
line 417: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer:
http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl
[Fri Nov 26 14:10:04.681634 2021] [cgi:error] [pid 25265] [client
127.0.0.1:47400] End of script output before headers: detail.pl, referer:
http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl

-- 
*Dr Vimal Kumar V.*
Reference Assistant
Mahatma Gandhi University Library
Kottayam, Kerala-686560
------------------------------------------
My Home page:www.vimalkumar.info
My Blogs:linuxhalwa.blogspot.com
kohageek.blogspot.com moovandan.blogspot.com
-----------------------------------------------------------
*"The illiterate of the 21st century will not be those who cannot read and
write, but those who cannot learn, unlearn, and relearn." Alvin Toffler*