[Koha] Error restoring Koha-Instance

[Alvaro Cornejo]

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
>