3 replies to this topic

[kangoo]

Hi

 

my module named block search doesnt work well.

im selling xerox printers and other stuff related to xerox brand.

 

when im trying to search for "3010" (xerox phaser 3010) i don't see any result.

when i try to search "phaser 3010" it works well.

 

what i can do in this case?

[vekia]

hello

for the first try to go to back office section: preferences > search

and try to:

 

 

after that please try again to search

[kangoo]

ok i did that but it doesnt work. problem is somewhere else

any other ideas?

[vekia]

ok thank you for fast reply
so, in this case it's necessary to modify Search class located in /classes/Search.php file

 

there is a code like:

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

you have to add % before the searched word, so just change it to:

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