[Koha] Zebra problems

[David Cook]

Hi Helen:

I'm not sure if someone has already helped you, but I can see at least one
obvious problem just looking at your email.

I assume that you're using MARC21?

It looks like your Koha to MARC mappings are incorrect.

> BIBLIONUMBER in :???? 090$c
> BIBLIOITEMNUMBER in : 090$d

This should be:

> BIBLIONUMBER in :???? 999$c
> BIBLIOITEMNUMBER in : 999$d

At this point, you'll want to examine your records. Do you also have
database access? Where is the biblionumber being stored in these records? Is
it in 090$c or is it in 999$c? (The number from the biblio.biblionumber
column should probably appear in the 999$c.)

If it is 999$c, then continue following these instructions. If it's 090$c,
then I'll have to respond again later :p.

If you examine your records, I bet that they have 999$c and 999$d fields,
but not 090$c and 090$d fields. 

So the first step will be to go to "Administration",  then "Koha to MARC
mapping". You'll want to change "biblionumber" so that it uses Tag 999 and
subfield "c". Then you'll want to do the same with "biblioitemnumber"
mapping it to Tag 999 and subfield "d".  

Then try a full re-index of your bibliographic records (e.g. perl
rebuild_zebra.pl -b -x -r -v -v -v). The extra "-v" flags are handy as they
print out more information about what's going on as you're indexing.

Hopefully that should make you right as rain again.

If you find that your biblionumber is being stored sometimes in 090$c and
sometimes in 999$c, it might be an idea to run "touch_all_biblios.pl" after
you've changed your "Koha to MARC mapping" to 999$c (and 999$d). That should
put the biblionumber (and biblioitemnumber) in the right place, and you can
try re-indexing again.

Let me/us know how you go!

David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St, Ultimo, NSW 2007

> -----Original Message-----
> Message: 2
> Date: Mon, 3 Nov 2014 16:17:57 +0000 (UTC)
> From: All Saints Cathedral Library <ascleg at yahoo.co.uk>
> To: Koha mailing list <koha at lists.katipo.co.nz>
> Subject: [Koha] Zebra problems
> Message-ID:
> 	<357045189.418673.1415031477797.JavaMail.yahoo at jws11152.mail.ir
> 2.yahoo.com>
> 
> Content-Type: text/plain; charset=UTF-8
> 
> Hello All,
> ?
> Recently we replaced our Koha 3.06 with a new install of Koha 3.16 on
Linux
> Mint 13? XFCE via Ubuntu packages.? Since the upgrade, searching for
books,
> both from the old database and recently entered, in both the staff client
and
> the opac yields only books in the reservoir in the staff section.?
> 
> In the terminal it looks like Zebra is working, with errors for some, but
not all,
> records:
> 
> exporting biblio
> ====================
>
1...........................................................................
...101...............
> 
> 3301..............................error retrieving biblio 3518 at
> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 679.
> in/migration_tools/rebuild_zebra.pl line 679.
> .....error retrieving biblio 7462 at
> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 679.
> 7201...................
> Records exported: 7066
> ====================
> REINDEXING zebra
> ====================
> 11:40:57-28/10 zebraidx(3813) [warn] Record didn't contain match fields in
> (bib1,Local-number) ==================== CLEANING Zebra
> configuration information ================================ Zebra
> biblio directory????? = /var/lib/koha/cathlib/biblios Zebra authorities
> directory = /var/lib/koha/cathlib/authorities Koha directory?????????????
=
> /usr/share/koha/intranet/cgi-bin Lockfile??????????????????? =
> /var/lock/koha/cathlib/rebuild/rebuild..LCK
> BIBLIONUMBER in :???? 090$c
> BIBLIOITEMNUMBER in : 090$d
> ================================
> ====================
> exporting authority
> ====================
> 
> Records exported: 0
> ====================
> REINDEXING zebra
> ====================
> skipping biblios
> ====================
> CLEANING
> 
> I have tried resetting the permissions as described in the Koha wiki, but
that
> did not help. Are there other permissions I should check?? Which ones??
> What should the permissions be?? Should the user names and passwords for
> Mysql and Zebra and Koha all be the same?
> 
> When I investigated the path all the files seemed to be there, but the
/usr/
> bin/ zebraidx file is, according to gedit, ?corrupted?.? Is that the
problem??
> What should be in it?? Can I remove it and download a single replacement
> file? What would the commands be?
> 
> I have also noticed that ' libmarc-xml-perl_1.0.1-1_all.deb ' is sitting
in my
> home directory.? Where does it belong?? If I download it again as in the
Koha
> wiki Koha on Ubuntu packages ? long, I get a message ?Permission denied?.
> All the best,
> Helen Belal
> Volunteer librarian
> All Saints' Cathedral Library
> 
> 
>  ??
> ??
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> ------------------------------
> 
> End of Koha Digest, Vol 109, Issue 4
> ************************************