[Koha] Error 500 search not working

[Vimal Kumar V.]

Dear Alvaro,
Thanks, I'll check it out.

On Fri, 26 Nov, 2021, 9:30 pm Alvaro Cornejo, <cornejo.alvaro at gmail.com>
wrote:

> Hi Vimal
>
> DB Error seems to indicate that the field "created_on"  in table
> virtualshleves does not exist.. Can you verify it?
>
> You can do it from  koha itself creating a report like
>
> select * from virtualshelves
>
> If the field does not exist, you can add that field from within mysql.
>
> Here you can find the table information you might need to create that
> field.
>
> http://schema.koha-community.org/21_05/tables/virtualshelves.html
>
> Hope it helps.
>
> Regards,
>
> Alvaro
>
>
>
> |----------------------------------------------------------------------------------------|
>  Stay safe / Cuídate/  Reste sécurisé
> *7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  *q *Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le ven. 26 nov. 2021 à 05:56, Vimal Kumar V. <vimal0212 at gmail.com> a
> écrit :
>
>> 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*
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>