[Koha] bad records (error 404)

[Frédéric Rouyre]

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 at caryinstitute.org <mailto:schulera at ecostudies.org>
>
>  
>
>  
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100609/0e6dd458/attachment.htm