Hi It said there is a Unknown column 'me.damaged_on' ... this usually means that your DB schema has changed. Probably when updated/upgarded your koha install. There is a koha command to upgrade the schema but I don't know if that will solve the issue on a restore. Regards Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le ven. 22 févr. 2019 à 11:31, Beda Szukics <beda@kollegium-sarnen.ch> a écrit :
Hi all
I try to restore a koha-instance wiht koha-restore and I get the following messages:
error retrieving biblio 1669 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`, `me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`, `me`.`booksellerid`, `me`.`homebranch`, `me`.`price`, `me`.`replacementprice`, `me`.`replacementpricedate`, `me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`, `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`, `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`, `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`, `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`, `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`paidfor`, `me`.`timestamp`, `me`.`location`, `me`.`permanent_location`, `me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`, `me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`, `me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`, `me`.`new_status` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )" with ParamValues: 0=2262] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
Maybe my dump is too old? The one I have is from Juni 2018. Koha is 18.11.02.000.
It shows: System Maintenance
The Koha online catalog is offline for system maintenance. We'll be back soon! If you have any questions, please contact the site administrator
What can I do?
Beda _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha