[Koha] Ghost records
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 Columbia River Inter-Tribal Fish Commission ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
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 upgrading from 3.0 to 3.6. Hi Lenora Are these biblios with no items attached? Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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 that are not attached to biblios? Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber FROM biblio) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
Lenora- I have seen something similar when the index is 'off'. Often a rebuild of the index clears this up. i.e. perl rebuild_zebra.pl -b -x -v -r -Joy Nelson Migration Specialist ByWater Solutions From: Chris Cormack ch...@bigballofwax.co.nz To: Lenora 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 that are not attached to biblios? Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber FROM biblio) Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
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 001local-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 corrected in : melm 001local-number,local-number:n .. melm 035$a identifier-other,identifier-other:n Reindex and it was the end of the fabulous story of ghost entries. I hope this will help you. Regards Bernard Lenora Oftedahl a écrit : 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 Can't call method fields on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123. Has anyone solved this problem? Will upgrading solve the problem or just compound? Thanx. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Bernard Desnoues Bibliothécaire Bibliothèque universitaire des langues et civilisations Pôle informatique 60, rue de Wattignies - 75012 Paris Tél. (+33) 01 53 46 15 57 Fax. (+33) 01 53 46 15 90 http://www.bulac.fr bernard.desno...@bulac.fr ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
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 stored in 001 in our configuration). 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 corrected in : melm 001 local-number,local-number:n .. melm 035$a identifier-other,identifier-other:n Reindex and it was the end of the fabulous story of ghost entries. Perhaps its just out of my knowledge's scope, by I don't see the problem of having two different fields indexed under the same name, I mean, I'd think both would match the same record and thus not be shown twice. I'd rather think of a weird coincidence. I'm sorry if my confusion just makes the situation more obscure. To+ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
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 corrected in : melm 001 local-number,local-number:n .. melm 035$a identifier-other,identifier-other:n Reindex and it was the end of the fabulous story of ghost entries. Perhaps its just out of my knowledge's scope, by I don't see the problem of having two different fields indexed under the same name, I mean, I'd think both would match the same record and thus not be shown twice. I'd rather think of a weird coincidence. I'm sorry if my confusion just makes the situation more obscure. The issue here is that the local-number index has magic properties. I don't really understand how Zebra works, but I do know that every entry in the local-number index is considered a separate record. So if record has two fields that appear in the local-number index, the Zebra index will store two copies of the record (this is where the search results in Koha come from, not from the database). At some point I will submit a patch changing the suggestion for the 035 index, since uncommenting the melm 035 line as it stands now in the MARC21 record.abs is pretty much guaranteed to corrupt your Zebra indexes. I guess the magic property might have to do with this in zebra-*.cfg: recordId: (bib1,Local-number) i suppose it is the value used as interal ID for the record. I'd think it is a bug in zebra or th eway we use it. Regards To+ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Ghost records
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 Can't call method fields on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123. Has anyone solved this problem? Will upgrading solve the problem or just compound? Thanx. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
* 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. The public receives a 404 error. I receive Can't call method fields on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123. Has anyone solved this problem? Will upgrading solve the problem or just compound? Hi Lenora You could try http://koha-community.org/documentation/faq/searching/#5 Chris Thanx. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand signature.asc Description: Digital signature ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Ghost records
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 deleted and one that is real. The public receives a 404 error. I receive Can't call method fields on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123. Has anyone solved this problem? Will upgrading solve the problem or just compound? Perhaps you're missing the '-r' switch for rebuild_zebra.pl to zero the indexed records before reindexing. That could lead to duplicated records, and some deleted records to still appear in search results and hence the (fixed in master :-D) 404 error for asking for inexistent record retreival when you click on them. Regards To+ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha