Re: [Koha] Item availability status
Steven Nickerson schreef op wo 02-04-2014 om 20:38 [-0400]: > Does that look correct to you? I would have expected it to have > "changed" 379 rows as well, no? I would have expected that also, but if it worked, it worked :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Item availability status
That definitely fixed the issue for me, Robin, so thanks again!!! I see the availability status properly in both the "summary" and "detail" screens now. Steve -Original Message- From: Robin Sheat [mailto:ro...@catalyst.net.nz] Sent: Wednesday, April 02, 2014 6:07 PM To: koha@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Item availability status
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:ro...@catalyst.net.nz] Sent: Wednesday, April 02, 2014 6:07 PM To: koha@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Item availability status
Thanks for the suggestion.yes, I had also already done a full zebra rebuild with 'sudo koha-rebuild-zebra -f ' and that did not resolve it for me. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Wednesday, April 02, 2014 4:34 PM To: Steven Nickerson Cc: koha list Subject: Re: [Koha] Item availability status Hi Steve, Try to Rebuild the Zebra database of your KOHA. Might fix your problem. Regards, - Jerwyn ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Item availability status
Hi Steve, Try to Rebuild the Zebra database of your KOHA. Might fix your problem. Regards, - Jerwyn On Thu, Apr 3, 2014 at 3:50 AM, Steven Nickerson wrote: > Hi everyone, > >Can anyone tell me where the item availability status on the search > results page comes from, specifically if a search yields more than one > match > and shows the results in the summary format? 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. This is only happening in the Staff Client and not in > the "public"/OPAC search results. So I'm trying to figure out why the > "summary" results don't show the correct availability. I must have missed > updating some field in Koha during my data migration that Koha uses to > check > "summary" availability status versus the "detailed" view. > > > > Thanks in advance! > > Steve > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha