[Koha] [koha] Missing bibliographic details.

[muiru james]

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
same.

The query is as below:

SELECT
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
mariadbserver.

I have tried rebuilding zebra and also rebuilding the tables from the
rebuildtables.pl without success.

Any help will be greatly appreciated.

Regards
James