[Koha] Missing bibliographic details.
muirunyeri at gmail.com
Tue Aug 3 20:16:29 NZST 2021
Hi Aleisha and all,
Thank you so much for your help. It helped my problem.
Thanks a million.
Very Warm Regards
On Tue, 3 Aug 2021 00:07 Aleisha Amohia, <aleisha at catalyst.net.nz> wrote:
> Hi Muiru
> Your query is almost there! I think your error is happening because of the
> columns you're joining the tables on. The joining column should be equal
> (or represent the same data) in both tables to be accurate. You should
> amend the query to look more like:
> SELECT items.itemcallnumber, items.barcode, biblio.author,biblio.title,
> biblioitems.publishercode AS ISBN, items.price
> FROM items
> LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
> LEFT JOIN biblioitems ON (biblioitems.biblionumber=items.biblionumber)
> LEFT JOIN biblio_metadata ON
> Hopefully that gives you some data in your results.
> Also just noticed that you're using biblioitems.publishercode as ISBN, I'm
> sure you know this, but there is also a biblioitems.isbn field that might
> be mapped more accurately for you to use for this purpose.
> Hope that helps!
> On 2/08/21 9:40 pm, muiru james wrote:
> Hello team,
> I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete
> shelflist report with columns biblio.author, biblio.title. However for new
> items added to the records, columns for author and title are blank. I have
> tried to use the extractvalue from biblio_metadata and the result is the
> The query is as below:
> items.itemcallnumber, items.barcode, biblio.author,biblio.title,
> biblioitems.publishercode AS ISBN, items.price.
> From items
> LEFT JOIN biblio ON (biblio.biblionumber=items.itemnumber)
> LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=biblionumber)
> LEFT JOIN biblio_metadata ON (items.itemnumber=biblio_metadata.biblionumber)
> Records staged after installation has the details but new items added ti
> the existing records has only data from the items table- callnumber,
> barcode and price.
> During the installation process, i could not install mariadb directly n had
> to install the mariadbserver10.03 then mariadbclient-10.03 then
> I have tried rebuilding zebra and also rebuilding the tables from therebuildtables.pl without success.
> Any help will be greatly appreciated.
> Koha mailing list http://koha-community.orgKoha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> *Aleisha Amohia*(she/her)
> Koha Developer
> Catalyst IT - Expert Open Source Solutions
> Tel: +64 4 499 2267 | www.catalyst.net.nz
> [image: Catalyst Logo]
> CONFIDENTIALITY NOTICE: This email is intended for the named recipients
> only. It may contain privileged, confidential or copyright information. If
> you are not the named recipient, any use, reliance upon, disclosure or
> copying of this email or its attachments is unauthorised. If you have
> received this email in error, please reply via email or call +64 4 499 2267.
More information about the Koha