<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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))<BR><BR><BR>--- On <B>Fri, 4/23/10, Chris Hobbs <I><chobbs@nhusd.k12.ca.us></I></B> wrote:<BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: Chris Hobbs <chobbs@nhusd.k12.ca.us><BR>Subject: Re: [Koha] Availability (& Zebra?)<BR>To: koha@lists.katipo.co.nz, "Scott Daniels" <scott@tw.co.nz><BR>Received: Friday, April 23, 2010, 2:48 PM<BR><BR>
<DIV id=yiv1753774431>
<STYLE type=text/css>
<!--
#yiv1753774431 {margin-bottom:1px;margin-right:4px;margin-left:4px;margin-top:4px;line-height:normal;font-variant:normal;}
#yiv1753774431 p {margin-bottom:0;margin-top:0;}
-->
</STYLE>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>Scott,</FONT> </DIV><BR>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>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:</FONT> </DIV><BR>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>update items set onloan = NULL WHERE onloan = '0000-00-00'</FONT> </DIV><BR>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>I've reported this as bug 4392.</FONT> </DIV><BR>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>Hope this helps!</FONT> </DIV><BR>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face="Lucida Grande" size=3>Chris</FONT><BR><BR><BR>Chris Hobbs<BR>Director, Technology<BR>New Haven Unified School District<BR><BR><BR>>>> Scott Daniels <scott@tw.co.nz> 04/20/10 9:19 PM >>><BR>Hi,<BR><BR>I am hoping to get some help with an issue I am having with our<BR>Koha(v3.00.05.003) installation. This is a new installation and<BR>biblio/item data has been imported via MARC records. All of our items<BR>imported correctly, we imported patrons and manually populated the<BR>issues table with data from the previous system.<BR><BR>The problem we are having is, in the search screen (ie<BR>cgi-bin/koha/opac-search.pl?q=test).<BR>The books are ALL reported to be on loan. (Availability: No items<BR>available: Checked out (1))<BR><BR>The reality is, some are available, some are not. This is ACCURATELY(and<BR>contradictory to the search screen)
reflected in the details screen for<BR>each book (cgi-bin/koha/opac-detail.pl?biblionumber=733), this will list<BR>the items with their correct status, available or checked out.<BR><BR>In my research I found that Availability is calculated based on 5<BR>fields, notforloan(0); damaged(0); itemlost(0); wthdrawn(0) and<BR>onloan(null). These are all accurately set in our data.<BR><BR>I looked into the code (/usr/share/koha/lib/C4/Search.pm line 1249) and<BR>it seems that the availability is retrieved from the Zebra index for the<BR>search screen, and not the data, unless I am misinterpreting the comment.<BR><BR># 'available' is defined as (items.onloan is NULL) and (items.itemlost = 0)<BR># In English:<BR># all records not indexed in the onloan register (zebra) and all records<BR>with a value of lost equal to 0<BR><BR>The scenario of a 'Zebra onloan register' not being populated would<BR>'fit' my problem in my mind, as it is only on the search screen
that<BR>availability is wrongly presented.<BR><BR>My question is how can I populate this 'register'?<BR><BR>I have run zebra_rebuild -v -b -w , this has had no effect.<BR><BR>--<BR>Regards,<BR>Scott Daniels<BR><BR>TechnologyWise Ltd, Tauranga, NZ<BR>scott@tw.co.nz<BR>ph: +64 (0)7 571 1060<BR>fax: +64 (0)7 571 1061<BR><BR>_______________________________________________<BR>Koha mailing list<BR>Koha@lists.katipo.co.nz<BR><A href="http://lists.katipo.co.nz/mailman/listinfo/koha" target=_blank rel=nofollow>http://lists.katipo.co.nz/mailman/listinfo/koha</A><BR><BR>--<BR>This message was scanned by ESVA and is believed to be clean.<BR>Click here to report this message as spam.<BR><A href="http://mx.nhusd.k12.ca.us/cgi" target=_blank rel=nofollow>http://mx.nhusd.k12.ca.us/cgi</A>-bin/learn-msg.cgi?id=92E702AC5F.A08C0<BR><BR><BR></DIV>-- This message has been checked by ESVA and is believed to be clean. </DIV><BR>-----Inline Attachment Follows-----<BR><BR>
<DIV class=plainMail>_______________________________________________<BR>Koha mailing list<BR><A href="http://ca.mc624.mail.yahoo.com/mc/compose?to=Koha@lists.katipo.co.nz" ymailto="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</A><BR><A href="http://lists.katipo.co.nz/mailman/listinfo/koha" target=_blank>http://lists.katipo.co.nz/mailman/listinfo/koha</A><BR></DIV></BLOCKQUOTE></td></tr></table><br>