hello Coroico,
i’ve got a similar problem, on this site :
http://tendances-de-voyages.ecotour.com
trying to search « dîner à oman » answer me that i need at least 3 car.
so i looked at the code, in ajaxSearchInput.class.inc.php, line 177 ++…
and if one of the word has less than 3 car. like my example, it won’t works.
So i just commented lines 180 to 183, and now it works just fine.
BUT
another problem occured, exactPhrase doesn’t work too :
[advSearch] => exactphrase in my config.
but it still search for each independant word…
log show this :
…
HAVING ((((sc.pagetitle LIKE ’%
dîner%’) OR (sc.longtitle LIKE ’%
dîner%’) OR (sc.description LIKE ’%
dîner%’) OR (sc.alias LIKE ’%dîner%’) OR (sc.introtext LIKE ’%dîner%’) OR (sc.menutitle LIKE ’%dîner%’) OR (sc.content LIKE ’%dîner%’) OR (tv_value LIKE ’%dîner%’)) OR ((sc.pagetitle LIKE ’%dîner%’) OR (sc.longtitle LIKE ’%dîner%’) OR (sc.description LIKE ’%dîner%’) OR (sc.alias LIKE ’%dîner%’) OR (sc.introtext LIKE ’%dîner%’) OR (sc.menutitle LIKE ’%dîner%’) OR (sc.content LIKE ’%dîner%’) OR (tv_value LIKE ’%dîner%’))) OR (((sc.pagetitle LIKE ’%à%’) OR (sc.longtitle LIKE ’%
à%’) OR (sc.description LIKE ’%
à%’) OR (sc.alias LIKE ’%à%’) OR (sc.introtext LIKE ’%à%’) OR (sc.menutitle LIKE ’%à%’) OR (sc.content LIKE ’%à%’) OR (tv_value LIKE ’%à%’)) OR ((sc.pagetitle LIKE ’%à%’) OR (sc.longtitle LIKE ’%à%’) OR (sc.description LIKE ’%
à%’) OR (sc.alias LIKE ’%à%’) OR (sc.introtext LIKE ’%à%’) OR (sc.menutitle LIKE ’%à%’) OR (sc.content LIKE ’%à%’) OR (tv_value LIKE ’%à%’))) OR ((sc.pagetitle LIKE ’%
oman%’) OR (sc.longtitle LIKE ’%
oman%’) OR (sc.description LIKE ’%oman%’) OR (sc.alias LIKE ’%oman%’) OR (sc.introtext LIKE ’%oman%’) OR (sc.menutitle LIKE ’%oman%’) OR (sc.content LIKE ’%oman%’) OR (tv_value LIKE ’%oman%’)))
…
and return me a hundred of results instead of one…
so my question is, how to search really for an exact phrase ??
merci d’avance !