[Evergreen-dev] Why are our catalog searches always empty?

[Jeffrey Goettsch]

Thank you Galen, this fixes the issue. And thanks for the note about the ‘-1’ rows, I’ll look into getting those restored properly.

Cheers.

-- 
Jeff Goettsch



> On Nov 2, 2020, at 11:33 AM, Galen Charlton <gmc at equinoxinitiative.org> wrote:
> 
> Hi Jeff,
> 
> On Mon, Nov 2, 2020 at 1:47 PM Jeffrey Goettsch <jdgoettsch at ucdavis.edu <mailto:jdgoettsch at ucdavis.edu>> wrote:
> > TL;DR: All our catalog searches give no results. The search query joins on the
> > metabib.record_attr_vector_list table, which is empty. How do we populate this table?
> 
> First, thank you for including a clear set of data and scripts for reproducing the problem; I was able to get it working without much effort.
> 
> The immediate reason why the record attributes table is not being populated is because the MARC records being supplied don't include values that feed into that table. At minimum, the Leader/06-07 (counting from zero) should be set to non-blank values suitable for your materials. E.g., if they're books, "am" would be a good value for those two positions. You should also consider adding an 008 control field, as that's where the stock record attribute definitions expect to find the publication date and the language of the work.
> 
> Unrelated, but something I noted: be careful about doing truncates on biblio.record_entry, asset.call_number, and asset.copy to clear the way for the next attempt: the script should make sure that it's restoring the row in each of those tables whose ID is -1, as those serve a special function for handling pre-catalogued item checkouts.
> 
> Regards,
> 
> Galen
> --
> Galen Charlton
> Implementation and Services Manager
> Equinox Open Library Initiative
> phone:  1-877-OPEN-ILS (673-6457)
> email:  gmc at equinoxInitiative.org
> web:  https://equinoxInitiative.org <https://equinoxinitiative.org/>
> direct: +1 770-709-5581
> cell:   +1 404-984-4366

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20201102/09b81b8d/attachment.html>