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@wlpl.org http://www.wlpl.org