[almost SOLVED] Full text search, sub string search

[grasnal]

Hello. Did anybody managed to force "simple search module" to make full text search? For example:

query: SATA
result: eSATA

If anyone know free search module better than provided by Presta i will be thankfully if you point me it.

[grasnal]

Can someone confirm that PrestaShop do not return positive search match if a searched string is a sub string of longer one? For example if I search for: "TB ST3" i want to find item with name "HDD SEAGATE 1TB ST31000528AS SATA II 32MB".

Maybe I messed something?

[dave7x7]

yeah i need to know too

[rocky]

I can confirm that PrestaShop doesn't search substrings for performance reasons. It only indexes starting from the first x characters (the minimum word length on the Preferences > Search tab).

[grasnal]

I made "quick&dirty;" hack to force PrestaShop search sub string through at least product name.

This do not check product is active/inactive and visitor access right to list product (user groups). I don't have any idea is this safe at all. But it works .

@rocky: can you help me solve above disadvantages

PrrestaShop version: 1.3.3
file: classes/Search.php
line: 185

change from:

$eligibleProducts = $db->ExecuteS('
       SELECT DISTINCT cp.`id_product`
       FROM `'._DB_PREFIX_.'category_group` cg
       INNER JOIN `'._DB_PREFIX_.'category_product` cp ON cp.`id_category` = cg.`id_category`
       INNER JOIN `'._DB_PREFIX_.'category` c ON cp.`id_category` = c.`id_category`
       INNER JOIN `'._DB_PREFIX_.'product` p ON cp.`id_product` = p.`id_product`
       WHERE c.`active` = 1 AND p.`active` = 1 
       AND cg.`id_group` '.(!$cookie->id_customer ?  '= 1' : 'IN (
           SELECT id_group FROM '._DB_PREFIX_.'customer_group
           WHERE id_customer = '.intval($cookie->id_customer).'
       )').'
       AND '.implode(' AND ', $whereArray));

to

$eligibleProducts = $db->ExecuteS('
      SELECT id_product FROM '._DB_PREFIX_.'product_lang WHERE id_lang = '.intval($id_lang).' AND name LIKE \'%'.$expr.'%\'
       UNION
       SELECT DISTINCT cp.`id_product`
       FROM `'._DB_PREFIX_.'category_group` cg
       INNER JOIN `'._DB_PREFIX_.'category_product` cp ON cp.`id_category` = cg.`id_category`
       INNER JOIN `'._DB_PREFIX_.'category` c ON cp.`id_category` = c.`id_category`
       INNER JOIN `'._DB_PREFIX_.'product` p ON cp.`id_product` = p.`id_product`
       WHERE c.`active` = 1 AND p.`active` = 1 
       AND cg.`id_group` '.(!$cookie->id_customer ?  '= 1' : 'IN (
           SELECT id_group FROM '._DB_PREFIX_.'customer_group
           WHERE id_customer = '.intval($cookie->id_customer).'
       )').'
       AND '.implode(' AND ', $whereArray));

added statment:

SELECT id_product FROM '._DB_PREFIX_.'product_lang WHERE id_lang = '.intval($id_lang).' AND name LIKE \'%'.$expr.'%\'
UNION

[seniz]

is there any solution for PrestaShop Version 1.3.7.0 ?

[culex]

Thank you very much @grasnal for the code, is very useful

is there any way to search only in active products?
not on the active/inactive products

[SkyHiRider]

How can I make this work on version 1.4.4 ?

[SkyHiRider]

I've edited Search.php and added the modified sql querry, but the search still doesn't work as expected (finds t4915 but does not find 4915). I've even tried restarting apache for the changes to take effect.

 

What should I do to make it work?

[SkyHiRider]

-double post, sorry-

[RybtsovSergey]

Try to insert

$word ='%'.$word.'%';

after

 

$word = str_replace('%', '\\%', $word);

$word = str_replace('_', '\\_', $word);

String number 175.

It seems to be work. Prestashop 1.4.7.