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
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 <snicker1@maine.rr.com>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
Thanks for the suggestion.yes, I had also already done a full zebra rebuild with 'sudo koha-rebuild-zebra -f <LIBNAME>' and that did not resolve it for me. From: Jerwyn Fernandez [mailto:jerwyn_fernandez@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
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
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:robin@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
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
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:robin@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
participants (3)
-
Jerwyn Fernandez -
Robin Sheat -
Steven Nickerson