Patched a site from 2.4.5-p8 to p9 last week. Now the search is not returning any results. The search box uses MagePlaza Advanced Search which shows results in a dropdown and that works, but the actual results page has nothing. Disabling that module changes nothing. We have re-indexed and cleared/flushed cache a million times. Also tested ElasticSearch which seems fine. Also checked in product attributes that Name and Sku are set up for search, resaved that too. Products are all set up for Catalog/Search.
Is there anything else we can test or try?
Only thing is that at one point earlier in the week, since the patch, SQL connection was lost for some reason and the whole site went down. When it came back there were no products in catalog pages until the ElasticSearch service was restarted – it had not restarted itself. The search issue was only spotted since then. No-one can say for sure whether the search was working before this ES issue happened, so we don’t know whether it’s a result of this or of the patch itself.
Thanks