Hi,
On my site I've regexp'd a feed leaving me with only products containing a specific keyword. When I search for that keyword no results come up. Similarly a keyword associated without about 50% of the products and included in their descriptions doesn't return any search results. Any clue to what is going wrong?
Thanks,
Paddy
Hi Paddy,
When keywords appear in > 50% of records MySQL's full text index is ineffective (it considers the word too common to index, like "and" and "or" etc.)
If this is the case on your site, the best thing to do would be to disable use of the full text index. To do this, search for the following code on line 77 of search.php:
if ($useFullText)...and REPLACE that with:
if (FALSE)Cheers,
David.