[Koha] Error restoring Koha-Instance

[Josef Moravec]

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.alvaro at 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 <beda at 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 at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>