Recherche: combinaison de mots

seabird
Topic Author
Offline
Elite Member

10 years 10 months ago #44366 by seabird

Recherche: combinaison de mots was created by seabird

Bonjour,

j'ai la version 2.1.2 r1806 beta de flexi et je viens de remarquer un petit souci pour la recherche de texte dans les articles d'une catégorie.
En effet pour la combinaison, j'ai sélectionné phrase exacte.
Si je tape par exemple: documents en ligne .
La recherche me sort tous les articles qui contiennent le mot: documents et tous les articles qui contiennent le mot: ligne. Donc ce n'est pas ce que je veux. J'ai testé toutes les possibilités, je n'arrive pas à obtenir seulement les articles qui contiennent exactement: documents en ligne.

Est ce que le souci vient de moi où y a t-il un problème ?

NB: je viens juste de remarquer qu'en mettant la requète entre guillemets, cela fonctionne.

Merci,

Eric

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 9 months ago #44411 by ggppdk

Replied by ggppdk on topic Recherche: combinaison de mots

Hello

i think i remember noticing this

next time we update this part of FLEXIcontent,
will see what we can do about it

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

seabird
Topic Author
Offline
Elite Member

10 years 9 months ago #44461 by seabird

Replied by seabird on topic Recherche: combinaison de mots

Hello,

Ok for update:
I quickly changed the file: \com_flexicontent\models\category.php line 849.

Code:

case 'exact':
				$text = '"'.$text.'"';
				$text = trim( $text );
				$quoted_text = FLEXI_J16GE ? $db->escape($text, true) : $db->getEscaped($text, true);
			$quoted_text = $db->Quote( $quoted_text, false );
				
					$_text_match  = ' MATCH (ie.search_index) AGAINST ('.$quoted_text.' IN BOOLEAN MODE) ';
					
					break;

Now it's work

Eric

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 9 months ago #44478 by ggppdk

Replied by ggppdk on topic Recherche: combinaison de mots

Hello

i see now,
thanks for feedback and issue report + fix

i thought you were talking about
auto-complete of the TEXT form field (by quickly reading translation of your original message)

-- what you did will give correct results but it will be slow in big sites

to improve performance try/test this:
replace:

Code:

case 'exact':
	$_text_match  = ' MATCH (ie.search_index) AGAINST ('.$quoted_text.' IN BOOLEAN MODE) ';
	break;

with:

Code:

case 'exact':
	$like_text = $db->Quote( '%'. (FLEXI_J16GE ? $db->escape($text, true) : $db->getEscaped($text, true)) .'%', false );
	$_text_match  = ' MATCH (search_index) AGAINST ('.$quoted_text.' IN BOOLEAN MODE) AND search_index LIKE '.$like_text;
	break;

Please Log in or Create an account to join the conversation.

seabird
Topic Author
Offline
Elite Member

10 years 9 months ago #44482 by seabird

Replied by seabird on topic Recherche: combinaison de mots

Hello,

It's work fine.

Code:

$like_text = $db->Quote( '%'. (FLEXI_J16GE ? $db->escape($text, true) : $db->getEscaped($text, true)) .'%', false );
   $_text_match  = ' MATCH (search_index) AGAINST ('.$quoted_text.' IN BOOLEAN MODE) AND search_index LIKE '.$like_text;

Thanks,

Eric

Please Log in or Create an account to join the conversation.