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