[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
[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
* 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 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
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 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
Tomas, > 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. > > 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. Regards, Jared -- Jared Camins-Esakov Freelance bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ 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 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
Re: [Koha] Ghost records
On 10 April 2012 08:49, Lenora Oftedahl 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 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 To: Lenora Oftedahl Cc: koha-user Sent: Monday, April 9, 2012 4:46 PM Subject: Re: [Koha] Ghost records On 10 April 2012 09:42, Lenora Oftedahl 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