If you run Zebra, the records live in the zebra index database. You should update your index. What I do when things mess up (according to indexes) is the following: stop zebraqueue daemon stop zebra daemon execute bin/migration_tools/rebuild_zebra.pl -v -b -a -r (under the user who owns the koha files and runs zebra daemons). restart zebra daemon restart zebraqueue daemon Your 404 error should disappear. I noticed that when the zebraqueue contains a lot of records, it slows down the db ... So a "DELETE FROM zebraqueue where done=1" is a good idea. But after a complete index rebuild, a "TRUNCATE zebraqueue" is enough. Regards, Fred On 09/06/2010 17:21, Amy Schuler wrote:
Hello,
I have two bad records in my Koha database; actually they are error 404s and not real records at all. Therefore, I am unable to delete them the usual way (deleting attached items followed by deleting the entire record). Does anyone know what table these records live in? I am running Koha v. 3.0001005.
Thanks,
Amy
Amy C. Schuler
Manager of Information Services
Cary Institute of Ecosystem Studies
PO Box AB
Millbrook, NY 12545
(845) 677-7600 x164
schulera@caryinstitute.org <mailto:schulera@ecostudies.org>
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha