hi david,
I've noticed a strange behaviuor when I search products.
The search is configured to search either on name and in description. The fulltext indexes are created.
If I do a search word1 word2 word3 it works fine and returns articles where these words appears only in description (not on name)
If I do a search word4 word5 word6 no results are given althoug I know a I have products that these words appear only on description.
I tried reindexing several times, but the problem stills is there.
these are my indexes on products
PRIMARY PRIMARY 3073 id
dupe_filter UNIQUE 3073 dupe_hash
filename INDEX 1 filename
merchant INDEX 6 merchant
normalised_name INDEX 3073 normalised_name
search_name INDEX 3073 search_name
category INDEX 61 category
brand INDEX 54 brand
name_2 FULLTEXT 1 name
search_name_2 FULLTEXT 1 search_name
search_name_description FULLTEXT 1 search_name, description
name_description FULLTEXT 1 name, description
Any idea?
hi david,
you are great man!
i turned off $config_useFullText and works perfect.
what is the difference between on/off on this parameter ?
thanks
javier
Hello Javier,
The configuration sets whether the full text or normal search method is used in search.php. See the IF construct beginning at line 188 for how it's used in the code...
Cheers,
David.
--
PriceTapestry.com
Hi,
Check if any of word4 word5 or word6 are either less than 4 characters, or are stopwords (see includes/stopwords.php).
If that doesn't look like the case;the most likely reason is that one of word4 word5 or word6 are considered too common to be included in the full text index. In this situation, it is normally best to disable the use of full text in config.advanced.php (line 8). Either way, it might be worth trying that as an experiment to confirm that it is a function of the full text index.
If you're not sure, could you let me know the URL of the installation both your working and non working queries and I'll take a look (i'll remove the details before publishing your reply...)
Cheers,
David.
--
PriceTapestry.com