[Koha] Results display in Koha 3

[Tim McMahon]

I found the script fix_onloan.pl in the migration_tools directory.  The 
script says that items.onloan didn't exist in 2.2 and the script will 
copy the information from items.onlon to the marc record.  The problem 
with the upgrade from 2.2 is that items.onloan isn't filled.  I think 
this MySQL query should fix that.  Then you can run fix_onloan.pl.

update items,issues set items.onloan=issues.date_due where 
issues.returndate is not null and items.itemnumber=issues.itemnumber;


Tim McMahon wrote:
> I'm trying to upgrade from 2.2 to 3 and the search results aren't correct.
> 
> In the OPAC listing, it tells me the item is available even if it's 
> checked out.  It will tell me it's checked out if I click on it to get 
> more detail
> 
> In the intranet listing, it tells me the item is available even if it's 
> checked out.  In the detail view, it tells me it's checked out with the 
> patrons name and the due date, but below that it says it's available.
> 
> Any ideas what I'm doing wrong?

-- 
Tim McMahon
Technical Services
West Liberty Public Library
400 N. Spencer St.
West Liberty, IA 52776
Phone: 319-627-2084	Fax: 319-627-2135
tmcmahon at wlpl.org	http://www.wlpl.org