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
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
On Wed, Jun 11, 2008 at 2:16 PM, Tim McMahon <tmcmahon@wlpl.org> 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 wonder if perhaps there was a missing mapping in your framework? Did you stick with the 2.2 frameworks, as upgraded by the upgrade process, or did you start fresh with 3.0 frameworks?
Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Joshua Ferraro wrote:
On Wed, Jun 11, 2008 at 2:16 PM, Tim McMahon <tmcmahon@wlpl.org> 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 wonder if perhaps there was a missing mapping in your framework? Did you stick with the 2.2 frameworks, as upgraded by the upgrade process, or did you start fresh with 3.0 frameworks?
Cheers,
I started with a mysqldump of our current 2.2 system, so it would have the 2.2 framework. -- 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
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
participants (2)
-
Joshua Ferraro -
Tim McMahon