I should work this way: restore old db ignore zebra errors update database schema rebuild zebra manually
Josef pá 22. 2. 2019 v 18:30 odesílatel Alvaro Cornejo <cornejo.alv...@gmail.com> napsal: > 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 <b...@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 > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha