[Koha] invalid data, cannot decode object
Ronald Vyhmeister
ronald.vyhmeister at meu.edu.lb
Thu Jun 20 06:38:25 NZST 2019
Hi Jonathan,
The result of the query:
Count = 0
This was a fresh install about 4 months ago, then we imported the data from
OLib...which had died an ugly death, and therefore we had no MARC records...
so we crafted SQL queries to load the data and it was working fine...
running on Ubuntu 18.04 LTS.
When we updated Ubuntu, it updated to 19.05 automatically... and it's after
this that we have found this problem... which did not exist before... Once
it's working again, I'm going to disable the repository for Koha so that it
won't update Koha without me knowing :-)
Any input appreciated!
Ron
-----------------------------------------------------------------------------------------
Ronald Vyhmeister, PhD
Academic Dean
IT Manager
Middle East University
Beirut, Lebanon
ronald.vyhmeister at meu.edu.lb
Mobile:+961-81767015
Office: +961 1 685-800 x 102
US: +1 301-244-9191
Technology is dominated by two kinds of people:
Those who manage what they do not understand
and those who understand that which they do not manage.
-----Original Message-----
From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
Sent: Wednesday, June 19, 2019 8:57 PM
To: Ronald Vyhmeister <ronald.vyhmeister at meu.edu.lb>
Cc: koha <koha at lists.katipo.co.nz>
Subject: Re: [Koha] invalid data, cannot decode object
It means you have missing biblio_metadata for some of your bibliographic
records.
Is it a new fresh install? Did you just upgrade to 19.05? How did you import
your records?
The following SQL query will return the biblionumber that do not have a
biblio_metadata entry:
SELECT COUNT(*) FROM biblio b LEFT JOIN biblio_metadata m ON
b.biblionumber=m.biblionumber WHERE m.biblionumber IS NULL;
Le mer. 19 juin 2019 à 01:19, Ronald Vyhmeister
<ronald.vyhmeister at meu.edu.lb> a écrit :
>
> Here's what we get using ID = 1
>
> 0 row(s) returnedIf the item is one that exists, here is the result.
> Any assistance
> appreciated.
>
> | 23684 | <?xml version="1.0" encoding="UTF-8"?>
> <record
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://www.loc.gov/MARC21/slim
> http://www.loc.gov/standards
> /marcxml/schema/MARC21slim.xsd"
> xmlns="http://www.loc.gov/MARC21/slim">
>
> <leader>00952nam a2200253Ia 4500</leader>
> <controlfield tag="005">20190321165616.0</controlfield>
> <controlfield tag="008">0930624s1991 cau 000 0 eng
> d</controlfield>
> <controlfield tag="008">190321s9999 xx 000 0 und
> d</controlfield>
> <datafield tag="040" ind1=" " ind2=" ">
> <subfield code="a">DLC</subfield>
> </datafield>
> <datafield tag="040" ind1=" " ind2=" ">
> <subfield code="b">eng</subfield>
> </datafield>
> <datafield tag="040" ind1=" " ind2=" ">
> <subfield code="c">DLC</subfield>
> </datafield>
> <datafield tag="040" ind1=" " ind2=" ">
> <subfield code="d">DLC</subfield>
> </datafield>
> <datafield tag="100" ind1=" " ind2=" ">
> <subfield code="a">Cerna, Miguel Angel</subfield>
> </datafield>
> <datafield tag="245" ind1=" " ind2="4">
> <subfield code="a">The power of small groups in the church</subfield>
> </datafield>
> <datafield tag="245" ind1=" " ind2="0">
> <subfield code="c">Miguel Angel Cerna</subfield>
> </datafield>
> <datafield tag="260" ind1=" " ind2=" ">
> <subfield code="a">Newbury Park, CA</subfield>
> </datafield>
> <datafield tag="260" ind1=" " ind2=" ">
> <subfield code="b">El Camino Pub</subfield>
> </datafield>
> <datafield tag="260" ind1=" " ind2=" ">
> <subfield code="c">c1991</subfield>
> </datafield>
> <datafield tag="300" ind1=" " ind2=" ">
> <subfield code="a">243 p</subfield>
> </datafield>
> <datafield tag="300" ind1=" " ind2=" ">
> <subfield code="c">22 cm</subfield>
> </datafield>
> <datafield tag="500" ind1=" " ind2=" ">
> <subfield code="a">The Power of Small Groups in the Church tells
> how your churc h can be organized and inspired to witness with
> dramatic results. This book will b e an effective guide to every
> pastor who wants his church to grow. It will help re
> volutionize your ministry. I highly recommend it!" Dr. Werner
> Vyhmeiste
> r, Dean of Theological Seminary, Andrews University</subfield>
> </datafield>
> <datafield tag="650" ind1=" " ind2=" ">
> <subfield code="a">Divina commedia</subfield>
> </datafield>
> <datafield tag="942" ind1=" " ind2=" ">
> <subfield code="c">BK</subfield>
> </datafield>
> <datafield tag="999" ind1=" " ind2=" ">
> <subfield code="c">23684</subfield>
> <subfield code="d">23685</subfield>
> </datafield>
> </record>
>
> ----------------------------------------------------------------------
> -------------------
> Ronald Vyhmeister, PhD
> Academic Dean
> IT Manager
> Middle East University
> Beirut, Lebanon
> ronald.vyhmeister at meu.edu.lb
> Mobile:+961-81767015
> Office: +961 1 685-800 x 102
> US: +1 301-244-9191
> Technology is dominated by two kinds of people:
> Those who manage what they do not understand and those who understand
> that which they do not manage.
>
>
> -----Original Message-----
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> Sent: Wednesday, June 19, 2019 3:55 AM
> To: Ronald Vyhmeister <ronald.vyhmeister at meu.edu.lb>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] invalid data, cannot decode object
>
> Hello Ron,
>
> What is the return of the following SQL query:
> select biblionumber, metadata from biblio_metadata where id=1;
>
> Regards,
> Jonathan
>
> Le dim. 16 juin 2019 à 03:54, Ronald Vyhmeister
> <ronald.vyhmeister at meu.edu.lb> a écrit :
> >
> > Dear Colleagues,
> >
> >
> >
> > We’ve turned up a new error… when I do a search from the user
> > interface, I get this error
> >
> >
> >
> > Invalid data, cannot decode object (id=16037, format=marcxml,
> > schema=MARC21)
> >
> >
> >
> > The id number changes depending on the search.
> >
> >
> >
> > The weird thing is that if logged into the –intra site, the search
> > works normally.
> >
> >
> >
> > We’re running Koha 19.05 with all the updates in place.
> >
> >
> >
> > Thanks in advance for your assistance.
> >
> >
> >
> > Ron
> >
> > --------------------------------------------------------------------
> > --
> > -------------------
> > Ronald Vyhmeister, PhD
> > Academic Dean
> > IT Manager
> > Middle East University
> > Beirut, Lebanon
> > ronald.vyhmeister at meu.edu.lb
> > Mobile:+961-81767015
> > Office: +961 1 685-800 x 102
> >
> > US: +1 301-244-9191
> > Technology is dominated by two kinds of people:
> > Those who manage what they do not understand and those who
> > understand that which they do not manage.
> > _______________________________________________
> > Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list