Hi THere, In the given link on OPAC (i.e.) your list http://localhost/cgi-bin/koha/opac-shelves.pl?op=list&category=1 when I click I get following error Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/perl5/Data/Page.pm line 49 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Please help me out. Thanks!
Which exact version of Koha are you using, 20.11.00? How did you install it? Did you upgrade from a previous version of Koha? Did you restart the different services? % sudo service apache2 restart % sudo service koha-common restart
Created attachment 114305 [details] Koha-sys-info Dear Jonathan Druart , I tried everything and dropped a bug here. I have attached system information for your reference. Regards! Nishath
Does the column virtualshelves.created_on exist in DB? % koha-mysql $INSTANCE MariaDB > desc virtualshelves; You should see: | created_on | datetime | NO | | NULL ||
Created attachment 114307 [details] Koha-shelves-info cgi-bin/koha/opac-shelves.pl
So you don't have the column. That's very weird, it has been added by 3.19.00.038, so a long time ago. From which Koha version did you upgrade? You can try the two following queries, to add the missing column, but you should have seen an error during the upgrade. ALTER TABLE virtualshelves ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified; UPDATE virtualshelves SET created_on = lastmodified, lastmodified = lastmodified;
Jonathan Druart, Got it! Thanks for your kind help. By the way why it wasn't altered during upgrade I mean (upgrade-database-schema) command. Anyways many thanks! Regards!