Hi Ma. Victoria Some tables has been modified in the latest version of koha. Al marc data has been moved to an especific table outside the rest of reccord information. The new table is biblio_metadata
xml strucure is the same though. You can check the tables structure for your specific version in: http://schema.koha-community.org/ Therefore, you need to edit your query using a join of the biblio table and biblio_metadata 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 jeu. 15 août 2019 à 19:33, Ma. Victoria H. Silva-Manuel < [email protected]> a écrit : > Hi. > > I got the SQL report below from wiki.koha-community.org, however it is not > working. > > > SELECT concat(b.title, ' ', ExtractValue(( > > SELECT marcxml > > FROM biblioitems b2 > > WHERE b.biblionumber = b2.biblionumber), > > '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, > > b.author, i.itemcallnumber FROM biblio b LEFT JOIN items i ON > > (i.biblionumber=b.biblionumber) > > > > It shows the following error: > > The following error was encountered: > > The database returned the following error: > > Unknown column 'marcxml' in 'field list' > > Please check the log for further details. > > Return to previous page > > > Does anyone knows what went wrong? > > Thank you. > > -- > Ma. Victoria H. Silva-Manuel > Registered Librarian, 3892 > _______________________________________________ > 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
