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@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@bugs.koha-community.org> Sent: Wednesday, June 19, 2019 8:57 PM To: Ronald Vyhmeister <ronald.vyhmeister@meu.edu.lb> Cc: koha <koha@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@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@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@bugs.koha-community.org> Sent: Wednesday, June 19, 2019 3:55 AM To: Ronald Vyhmeister <ronald.vyhmeister@meu.edu.lb> Cc: koha <koha@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha