Search dont work

[qwerty232]

Hello

 

My search fuction dont work.

I try reindexing - i have 67/67 but in my database i have empty ps_search_word, ps_search_index

 

In backoffice it is ok but in front still : "No results found for your search"

 

Edit:

now i set ‘display_errors’ to ‘on’ in /config/config.inc.php

 

ini_set(‘display_errors’, ‘on’);

 

When i try reindex i have many times this :

Warning: preg_replace() [function.preg-replace]: Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 1829 in /home/html/nanakupe.sk/public_html/classes/Search.php on line 103

 

this is on the end:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/html/nanakupe.sk/public_html/classes/Search.php:103) in /home/html/nanakupe.sk/public_html/classes/Tools.php on line 107

 

 

EDIT 2

 

Today i try move it to localhost (same error on localhost), then i update from 1.4.6.2. to 1.4.7. now on localhost everything is OK. But when i upload it to server it is same ... if i try reindex i only empty tables in database: ps_search_word, ps_search_index

 

 

 

Please somebody any ideas? Anybody

Edited February 26, 2012 by qwerty232 (see edit history)

[CraigMeade]

I remember something about search needing to be hooked into header to work properly. Does that help?

[qwerty232]

Hello CraigMeade

thanks for reply but i don't understand how "hooked into header" did you mean in BO - modules/positions?

 

 

edit:

 

I don't understand it.

 

On localhost it's everything OK.

When upload it to server same error.

When i download version from server to localhost it's OK.

Edited February 26, 2012 by qwerty232 (see edit history)

[thienxu]

My solution is replacing code of FO search by BO search.

 

FO search uses search_word and search_index tables but BO search uses SQL query directly.

 

Find these code in /classes/search.php:

 

 

foreach ($words AS $key => $word)

if (!empty($word) AND strlen($word) >= (int)Configuration::get('PS_SEARCH_MINWORDLEN'))

{

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

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

 

$intersectArray[] = 'SELECT id_product

FROM '._DB_PREFIX_.'search_word sw

LEFT JOIN '._DB_PREFIX_.'search_index si ON sw.id_word = si.id_word

WHERE sw.id_lang = '.(int)$id_lang.'

AND sw.word LIKE

'.($word[0] == '-'

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

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

);

if ($word[0] != '-')

$scoreArray[] = 'sw.word LIKE \''.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).'%\'';

}

else

unset($words[$key]);

 

replace by:

 

 

$intersectArray[] = 'SELECT distinct p.id_product

FROM ps_product p

LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = '.(int)$id_lang.')

WHERE pl.name LIKE \'%'.pSQL($expr).'%\'';

[Saryus]

Hi qwerty232,

 

Did you solve this problem? I'm having the same one. But! the indexation works in english language but not in the others (spanish or french).

 

thanks

[ninos]

Hello thienxu,

 

great many thanks! I had the same problem after the database uprgade on php 5.3.21.

 

PrestaShop-Version: 1.4.6.2

[mmsh]

  On 6/17/2012 at 3:08 PM, thienxu said:

$intersectArray[] = 'SELECT distinct p.id_product
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = '.(int)$id_lang.')
WHERE pl.name LIKE \'%'.pSQL($expr).'%\'';

If I do that I miss the ajax search ...how to avoid?

Edited July 2, 2013 by mmsh (see edit history)

[ADM777]

  On 2/24/2012 at 6:17 PM, qwerty232 said:

Hello

 

My search fuction dont work.

I try reindexing - i have 67/67 but in my database i have empty ps_search_word, ps_search_index

 

In backoffice it is ok but in front still : "No results found for your search"

 

Edit:

now i set ‘display_errors’ to ‘on’ in /config/config.inc.php

 

ini_set(‘display_errors’, ‘on’);

 

When i try reindex i have many times this :

Warning: preg_replace() [function.preg-replace]: Compilation failed: disallowed Unicode code point (>= 0xd800 && <= 0xdfff) at offset 1829 in /home/html/nanakupe.sk/public_html/classes/Search.php on line 103

 

this is on the end:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/html/nanakupe.sk/public_html/classes/Search.php:103) in /home/html/nanakupe.sk/public_html/classes/Tools.php on line 107

 

 

EDIT 2

 

Today i try move it to localhost (same error on localhost), then i update from 1.4.6.2. to 1.4.7. now on localhost everything is OK. But when i upload it to server it is same ... if i try reindex i only empty tables in database: ps_search_word, ps_search_index

 

 

 

Please somebody any ideas? Anybody

 

 

On Search.php on /public_html/classes just delete line:

 

'\x{a80b}\x{a823}-\x{a82b}\x{d800}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e}\x{fd3f}'.

 

Save and upload it now.

  On 6/26/2012 at 10:12 AM, Saryus said:

Hi qwerty232,

 

Did you solve this problem? I'm having the same one. But! the indexation works in english language but not in the others (spanish or french).

 

thanks

 

 

On Search.php on /public_html/classes just delete line:

 

'\x{a80b}\x{a823}-\x{a82b}\x{d800}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e}\x{fd3f}'.

 

Save and upload it now.

[S7 Media Ltd]

  On 8/13/2014 at 12:01 PM, ADM777 said:

 

On Search.php on /public_html/classes just delete line:

 

'\x{a80b}\x{a823}-\x{a82b}\x{d800}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e}\x{fd3f}'.

 

Save and upload it now.

 

 

On Search.php on /public_html/classes just delete line:

 

'\x{a80b}\x{a823}-\x{a82b}\x{d800}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e}\x{fd3f}'.

 

Save and upload it now.

 

Thankyou sir, this helped... not sure why after two years this error has come about but hey ho.

[ADM777]

  On 8/14/2014 at 9:44 PM, S7 Media Ltd said:

Thankyou sir, this helped... not sure why after two years this error has come about but hey ho.

 

On my site after 4 years got this error...I dont know why...;-)