[Koha] Ghost records

2012-04-09 Thread Lenora Oftedahl
I've got ghost records causing errors in a database transfer. I can't pull up these items in the staff interface. Is there another way to pull up these records and purge the last vestiges to get the database clean? We're upgrading from 3.0 to 3.6. Thanx. Lenora StreamNet Regional Librarian

Re: [Koha] Ghost records

2012-04-09 Thread Chris Cormack
On 10 April 2012 08:49, Lenora Oftedahl o...@critfc.org wrote: I've got ghost records causing errors in a database transfer.  I can't pull up these items in the staff interface.  Is there another way to pull up these records and purge the last vestiges to get the database clean? We're

Re: [Koha] Ghost records

2012-04-09 Thread Chris Cormack
On 10 April 2012 09:42, Lenora Oftedahl o...@critfc.org wrote: As far as I can tell, they aren't even biblios anymore.  Is there some way to find items that are not attached to biblios? Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber

Re: [Koha] Ghost records

2012-04-09 Thread Joy Nelson
Oftedahl o...@critfc.org Cc: koha-user koha@lists.katipo.co.nz Sent: Monday, April 9, 2012 4:46 PM Subject: Re: [Koha] Ghost records On 10 April 2012 09:42, Lenora Oftedahl o...@critfc.org wrote: As far as I can tell, they aren't even biblios anymore.  Is there some way to find items

Re: [Koha] Ghost records

2011-04-27 Thread Bernard Desnoues
Hello Lenora, We had the same problem. You could verify your .../biblio/record.abs file and be sure that you index only one field, containing the biblionumber in the local-number index (the biblionumber is stored in 001 in our configuration). Our problem was : melm 001

Re: [Koha] Ghost records

2011-04-27 Thread Tomas Cohen Arazi
On Wed, Apr 27, 2011 at 6:16 AM, Bernard Desnoues bernard.desno...@bulac.fr wrote: Hello Lenora, We had the same problem. You could verify your .../biblio/record.abs file and be sure that you index only one field, containing the biblionumber in the local-number index (the biblionumber is

Re: [Koha] Ghost records

2011-04-27 Thread Tomas Cohen Arazi
On Wed, Apr 27, 2011 at 9:55 PM, Jared Camins-Esakov jcam...@cpbibliography.com wrote: Tomas, Our problem was : melm 001        local-number,local-number:n .. melm 035$a      local-number,local-number:n We had two fields indexed in local-number and we had ghost entries. We have

[Koha] Ghost records

2011-04-26 Thread Lenora Oftedahl
Hello all. Koha v. 3.00.00.107 Zebra 2.0.34 We're having a problem with ghost records in the index. The Zebra index is rebuilt every night, but still when searching, I'll pull up two records: one that has been deleted and one that is real. The public receives a 404 error. I receive

Re: [Koha] Ghost records

2011-04-26 Thread Chris Cormack
* Lenora Oftedahl (o...@critfc.org) wrote: Hello all. Koha v. 3.00.00.107 Zebra 2.0.34 We're having a problem with ghost records in the index. The Zebra index is rebuilt every night, but still when searching, I'll pull up two records: one that has been deleted and one that is real.

Re: [Koha] Ghost records

2011-04-26 Thread Tomas Cohen Arazi
On Tue, Apr 26, 2011 at 2:40 PM, Lenora Oftedahl o...@critfc.org wrote: Hello all. Koha v. 3.00.00.107 Zebra 2.0.34 We're having a problem with ghost records in the index. The Zebra index is rebuilt every night, but still when searching, I'll pull up two records: one that has been