[Bug 27158] New: software error
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 Bug ID: 27158 Summary: software error Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: Linux Status: NEW Severity: major Priority: P5 - low Component: Z39.50 / SRU / OpenSearch Servers Assignee: koha-bugs@lists.koha-community.org Reporter: nishathahmed@gmail.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl 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! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 Nishath Ahmed <nishathahmed@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Z39.50 / SRU / OpenSearch |OPAC |Servers | Assignee|koha-bugs@lists.koha-commun |oleonard@myacpl.org |ity.org | CC| |nishathahmed@gmail.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- 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 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 --- Comment #2 from Nishath Ahmed <nishathahmed@gmail.com> --- Created attachment 114305 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114305&action=edit Koha-sys-info Dear Jonathan Druart , I tried everything and dropped a bug here. I have attached system information for your reference. Regards! Nishath -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Does the column virtualshelves.created_on exist in DB? % koha-mysql $INSTANCE MariaDB > desc virtualshelves; You should see: | created_on | datetime | NO | | NULL || -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 --- Comment #4 from Nishath Ahmed <nishathahmed@gmail.com> --- Created attachment 114307 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114307&action=edit Koha-shelves-info cgi-bin/koha/opac-shelves.pl -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- 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; -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|oleonard@myacpl.org |koha-bugs@lists.koha-commun | |ity.org Component|OPAC |Architecture, internals, | |and plumbing -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158 Nishath Ahmed <nishathahmed@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #6 from Nishath Ahmed <nishathahmed@gmail.com> --- 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! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org