[Koha] Error 500 search not working

[Alvaro Cornejo]

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
>