* ggardei (ggardei@gbs.edu) wrote:
Greetings Koha Guru's
We are currently in the progress of migrating from Follett Destiny to Koha. One of the issues that we are having is that a bunch of biblio items are being imported that do not have an item (and some that are). I have run the SQL query to remove biblio without items; however the biblio records are still showing up when I search in OPAC. When you click on one of these items, a page with error 404 appears
Here is the script I ran to remove the biblio items
INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT IN (SELECT biblionumber from items)); INSERT into deletedbiblioitems (SELECT * FROM biblioitems where biblionumber NOT IN (SELECT biblionumber from items)); DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items);
Hiya So what you have done is fine, but the step you are missing is to do a full zebra reindex, because you have deleted stuff, but not told zebra of that fact. So if you do a full zebra reindex they will drop out of your search results Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand