[Koha-bugs] [Bug 27158] software error

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Dec 10 14:19:55 CET 2020


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27158

--- Comment #5 from Jonathan Druart <jonathan.druart at 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.


More information about the Koha-bugs mailing list