Search not working prestashop 1.5.6.2

[goodl1ke]

Hi,

 

Using prestashop 1.5.6.2 search does not work properly.

I have 4000 products on the site with reference and combination reference code, some of them found, some not.

 

preference- search ->

-> Add missing products to the index - I tried but did not work

-> Re-build the entire index. - I tried but did not work

 

 

Here are two codes reference, and combination reference, but finds no one.

 

Help please. Thanks.

Edited July 10, 2014 by goodl1ke (see edit history)

[PSfever.com]

Hi,

 

have you tried reuploading the original Search classes and controller files?

[goodl1ke]

yes but did not work

[goodl1ke]

please help me to solve the problem..

[vekia]

try with this (im not sure at all if it will work, but it's worth to try)

search.php class file, search for find() function and change:

? ' \''.pSQL(Tools::substr($word, 1, PS_SEARCH_MAX_WORD_LENGTH)).'%\''
: '\''.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).'%\''

Change it to

? ' \'%'.pSQL(Tools::substr($word, 1, PS_SEARCH_MAX_WORD_LENGTH)).'%\''
: '\'%'.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).'%\''

Please note that your search might become slower

[goodl1ke]

 

I changed but still not working

[goodl1ke]

Does anyone know?