Search indexation does nothing and times out.

[Shwamateur]

Hi forum,

I'm experiencing this issue:

One week ago the search indexation (activated via backoffice) worked well.

This week we've been adding a lot of products via CSV and I've performed a couple changes in Search.php (modified the class and created an override).

 

At this moment, when I try to add the missing products to the index, it does nothing. It remains as it was and after a while it triggers a 504 time out error. The number of indexed products stays the same.

 

I've tried doing this in a development instalation of prestashop that we have using the same Search.php file (original and override)  and there it works perfect.

 

I'm afraid to hit "Rebuild entire index" because if it doesn't work we may lose a lot of money (the search won't work).

 

Does anybody know what could be happening?

 

Thank you in advance.

[Shwamateur]

Well I won't say this is solved but I managed to write a script that performs the indexing of a subset of products and I managed to index them little by little. If anyone is interested in this, let me know.

[rajlaskar]

Well I won't say this is solved but I managed to write a script that performs the indexing of a subset of products and I managed to index them little by little. If anyone is interested in this, let me know.

 

hi , i am also facing same issue, search indexing is not working at all after csv upload.

 

what i figured out, there are 3 tables responsible for search indexing 

ps_search_word

ps_search_index

ps_product_shop

 

below query will create indexing for a 'Product name'

insert keyword in ps_search_word table like (id_word, id_shop,id_lang, word) VALUES ('', '2', '1','Product name')

insert keyword_id, in ps_search_index like  ('id_product', 'id_word', 'weight') VALUES ('3150', '19677', '10')

update ps_product_shop  set indexed = 1 where id_product=3150;

 

Can you please share your script?

Edited September 10, 2014 by rajlaskar (see edit history)