Thanks Michael, It was a simple problem with a comma on line 5:
ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') as Date*,* After correcting the problem, it worked just fine :) All the best, Vanda 2018-02-28 10:23 GMT+00:00 Michael Kuhn <[email protected]>: > Hi Vanda Koha > > You wrote: > > > *The following error was encountered:* The database returned the > > following error: > > You have an error in your SQL syntax; check the manual that > > corresponds to your MariaDB server version for the right syntax to use > > near 'FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > LEFT JOIN b' at line 6 > > Please check the log for further details. > > I omitted some errors and then tested the following SQL statement using > the Biblibre demo installation of Koha 16.11 ( > http://intranet-demo.biblibre.com/ ) and it reported no more errors: > > SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, i.barcode, > v.lib, ExtractValue(bi.marcxml,'//datafield[@tag="205"]/subfield[@code="a"]') > as Edition, > ExtractValue(bi.marcxml,'//datafield[@tag="210"]/subfield[@code="c"]') > as Publisher, > ExtractValue(bi.marcxml,'//datafield[@tag="210"]/subfield[@code="d"]') > as Date > FROM items i > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber) > LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) > WHERE i.itemlost != 0 AND v.category='LOST' > > In the demo insrtallation no matches were found but in your own database > this would be different, I guess. > > Hope this helps. > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E [email protected] · W www.adminkuhn.ch > > _______________________________________________ > 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
