[Koha] Availability (& Zebra?)

[Marty]

I also had this problem, but for me it was because the item field in biblioitems was not filled in. Solved it by making an extra table and transfering items from another table (sorry, am far from my computer, can't remember which one) via my extra table (just in case Chris's solution is not the right one for your situation))


--- On Fri, 4/23/10, Chris Hobbs <chobbs at nhusd.k12.ca.us> wrote:


From: Chris Hobbs <chobbs at nhusd.k12.ca.us>
Subject: Re: [Koha] Availability (& Zebra?)
To: koha at lists.katipo.co.nz, "Scott Daniels" <scott at tw.co.nz>
Received: Friday, April 23, 2010, 2:48 PM







Scott, 

I had a similar problem (see the thread titled "All items checked out in OPAC"). What I found was that the onloan field in the items table had been populated with '0000-00-00' instead of NULL for iterms during the import with bulkmarcimport.pl. I was able to fix it by running the following in my database: 

update items set onloan = NULL  WHERE onloan = '0000-00-00' 

I've reported this as bug 4392. 

Hope this helps! 

Chris


Chris Hobbs
Director, Technology
New Haven Unified School District


>>> Scott Daniels <scott at tw.co.nz> 04/20/10 9:19 PM >>>
Hi,

I am hoping to get some help with an issue I am having with our
Koha(v3.00.05.003) installation. This is a new installation and
biblio/item data has been imported via MARC records. All of our items
imported correctly, we imported patrons and manually populated the
issues table with data from the previous system.

The problem we are having is, in the search screen (ie
cgi-bin/koha/opac-search.pl?q=test).
The books are ALL reported to be on loan. (Availability: No items
available: Checked out (1))

The reality is, some are available, some are not. This is ACCURATELY(and
contradictory to the search screen) reflected in the details screen for
each book (cgi-bin/koha/opac-detail.pl?biblionumber=733), this will list
the items with their correct status, available or checked out.

In my research I found that Availability is calculated based on 5
fields, notforloan(0); damaged(0); itemlost(0); wthdrawn(0) and
onloan(null). These are all accurately set in our data.

I looked into the code (/usr/share/koha/lib/C4/Search.pm line 1249) and
it seems that the availability is retrieved from the Zebra index for the
search screen, and not the data, unless I am misinterpreting the comment.

# 'available' is defined as (items.onloan is NULL) and (items.itemlost = 0)
# In English:
# all records not indexed in the onloan register (zebra) and all records
with a value of lost equal to 0

The scenario of a 'Zebra onloan register' not being populated would
'fit' my problem in my mind, as it is only on the search screen that
availability is wrongly presented.

My question is how can I populate this 'register'?

I have run zebra_rebuild -v -b -w , this has had no effect.

--
Regards,
Scott Daniels

TechnologyWise Ltd, Tauranga, NZ
scott at tw.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam.
http://mx.nhusd.k12.ca.us/cgi-bin/learn-msg.cgi?id=92E702AC5F.A08C0


-- This message has been checked by ESVA and is believed to be clean. 
-----Inline Attachment Follows-----


_______________________________________________
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/20100425/c5ae7f7f/attachment.htm