Dear Alvaro, Thanks, I'll check it out. On Fri, 26 Nov, 2021, 9:30 pm Alvaro Cornejo, <cornejo.alv...@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. <vimal0...@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@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha