[Koha] Item availability status

[Steven Nickerson]

Thank you so much for your response, Robin!   I ran the update as suggested and get the following output/results:
Query OK, 0 rows affected (0.01 sec)
Rows matched: 379  Changed: 0  Warnings: 0

Does that look correct to you?   I would have expected it to have "changed" 379 rows as well, no?

-----Original Message-----
From: Robin Sheat [mailto:robin at catalyst.net.nz] 
Sent: Wednesday, April 02, 2014 6:07 PM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Item availability status

Steven Nickerson schreef op wo 02-04-2014 om 15:50 [-0400]:
> After a recent migration from
> Athena to Koha 3.14.03, I'm seeing "1 item, 1 available" for ALL of my 
> search results, but some of the items are actually checked out and if 
> I click on the title of the item to get the details I then see that it 
> is indeed checked out.

Availability is tracked in two places, for efficiency and convenience reasons. One is the issues table. This is what the detail display uses, and this was probably migrated.

The second is in the items table, column 'onloan' and it should be null (for items that aren't issued) or the due date. Most likely this wasn't updated in the migration. Try running this SQL:

update items,issues set items.onloan=issues.date_due where issues.itemnumber=items.itemnumber;

which will populate the items.onloan from the issues table. Then do a full zebra rebuild.

--
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF