---------- Forwarded message ---------- From: "Tim Young" <Tim.Young@lightsys.org> Date: Jun 23, 2017 15:02 Subject: Unable to reindex after massive upgrade To: "Mary Maina" <mmaina@scott.ac.ke> Cc: (Mary, could you send this on to the Koha email list?) We recently upgraded our old Koha install to a new install. We went from a tarball install to a debian package install at the same time. I am not entirely sure what version they had previously, but it was 3.something, and now it is Koha 17.0500000. I made a new site, upgraded the old schema, and successfully followed the instructions from here: https://wiki.koha-community.org/wiki/Moving_an_installation_ from_a_regular_install_to_the_Debian_packages The website (http://opac.scott.ac.ke/) comes up fine. I can do a search for a book, and I can find it. But, when I click on a link, it gives me a 404. So far as I can tell, my current issue is that we are not getting any of the old records to reindex: Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/zebradb/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== .^M1error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. .error retrieving biblio 3 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. .error retrieving biblio 4 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. ...lots of lines... .error retrieving biblio 18258 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. .error retrieving biblio 18259 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== Opening up the rebuild_zebra.pl program and tracing it down, it seems that the biblio_metadata table, where it is trying to track down the biblio data from, is empty. I am assuming that it used to be stored elsewhere in a previous version? I do see a deletedbiblio_metadata table, and I have tracked some of that data down; I have a lot of biblio data in the "import_biblios" table. Anyway, It seems that my biblio_metadata table needs to be rebuilt / repopulated after an upgrade. Any pointers on where to start? - Tim Young