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 [email protected] 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 <[email protected]> Sent: Wednesday, June 19, 2019 8:57 PM To: Ronald Vyhmeister <[email protected]> Cc: koha <[email protected]> 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 <[email protected]> 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!&quot; 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 > [email protected] > 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 <[email protected]> > Sent: Wednesday, June 19, 2019 3:55 AM > To: Ronald Vyhmeister <[email protected]> > Cc: koha <[email protected]> > 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 > <[email protected]> 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 > > [email protected] > > 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 [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
