It worked that time, but when I tried updating the data from our current version 2.2 server, it didn't work. Has anyone else had the problem with no items showing when you hide lost items? I'm sure there has to be something I didn't put in the notes I took on getting it running the first time. Tim McMahon wrote:
It looks like items.itemlost isn't getting copied to the zebra database during the upgrade. To fix this I copied misc/migration_tools/fix_onloan.pl and modified it.
I modified the select to SELECT biblionumber,itemnumber,itemlost FROM items and replaced onloan in all of the lines after that to itemlost.
Run this script then rebuild_zebra and these problems go away.
Tim McMahon wrote:
If I have the hidelostitems system preference set to ON or select 'Limit to currently available items' in the OPAC, I get no results. I need to have hidelostitems set to OFF to get any results in an OPAC search. I have authorized values set for LOST and the lost itmes report seems to be working with these values.
-- 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