Search index keeps getting corrupted

[dadiotis]

Hello,

 

I have a problem with the native search function of Prestashop.

 

Every couple of days, the search index seems to become corrupt, which results in search results not being displayed correctly (might display 10 results out of 400, or it might not display anything).

 

When that happens, I do a re-indexing of the search index, and the problem is solved, but a day or two later, the same happens and I have to do a full re-indexing again.

 

I tried disabling the "auto-index new products" feature, and now I am just adding new products to the index by clicking on the link after I am done adding new ones, but the problem still persists.

 

Any idea what I should do?

[RabbitZzZ]

I have a similiar problem. Any ideas?

PS 1.6.1.9 default-bootstrap

Edited December 8, 2016 by RabbitZzZ (see edit history)

[RabbitZzZ]

Still having the same problem. Every few days we get reports, that some of the products can't be found through the search. 
After rebuilding the index it seems to work. Is there a solution for this? It's very annoying.

Edited February 13, 2017 by RabbitZzZ (see edit history)

[WolfD]

Hi all,

 

I already apologize if this is not the correct group for my topic but I did not know how to open one nor could I find this issue anywhere in this forum.

Last week I had to reinstall Prestashop. I downloaded the version 1.6.1.11. Everything went fine and my shop is up and running and online again since Sunday March 12th.

Yesterday I noticed that my product search was at 1/16880 so thinking this is nothing unusual I started a re-indexing. After it went up to 16820/16880 I hit index missing products. This time it stopped at 16879. I hit the link for missing products again and it went down to 15899 or so. I repeated this step a few times and the number of indexed products became smaller and smaller. Half an hour later it was down to 1/16880 again. I did a full index regeneration and it went up to 16880 products again and it stayed there even after refreshing the page several times. Again one hour later it was down to 1 product again. I have activated the multishop option and I replaced the search.php with the one from PS 1.6.1.9. Unfortunately no difference. I know that this should not change again once the indexing has has been completed unless there were changes to some products. I have set up cronjob to have at least a rebuild every hour but this cannot be the solution. Has someone else made this experience? 

 

Kind regards

Wolf

[HanzCZ]

Still having the same problem. Every few days we get reports, that some of the products can't be found through the search. 

After rebuilding the index it seems to work. Is there a solution for this? It's very annoying.

 

Use CRON for rebuilding automatically in specific time... 

[Casper_O]

On 15/3/2017 at 3:52 PM, HanzCZ said:

 

Use CRON for rebuilding automatically in specific time... 

Sadly this do not help, we still face this issue from time to time and we generate hour index every night. When we run a reindex all products, it works as expected. No issues, what so ever..

then a few days later, we notice a drop in sale of some products and can then see, that people can not search it. Boom, all over again

[Casper_O]

Okay, I found the issue to this problem and it seems like other did so and reported in Forge - I can't come up with a nice solution.

It all seems to happen, when you delete a product

http://forge.prestashop.com/browse/PSCSX-8239

Edited December 4, 2017 by Casper_O (see edit history)

[selectshop.at]

If search index cannot be rebuilt automatically, than perhaps your server is having time-out of the script. Check max_input_time and max_execution_time of your server. It should be set not less than 300 for each.

Check also server error-logs in this context.

[Casper_O]

@selectshop.at let me try to explain the issue in a few steps:

Step 1.
Clean prestashop, with  only 3 products as listed below here:

Product 1 Name : Test product 1
Product 2 Name: Test product 2
Product 3 Name: Test product 3

Step 2.

Make sure a full search index has been running and go to FO and search for Test
- you should see all 3 products in your list

Step 3.
Delete one of the 3 products from Backoffice and search again for Test
- This time you see no results in your list

Step 4.
Open one of the 2 remaining products in BO, like you would change the price etc, but do nothing else than save it.

Step 5.
Search again for Test in FO of the store
- you would now see the product you just edited, as the result but not the one you did not edit.

Edited December 6, 2017 by Casper_O (see edit history)

[selectshop.at]

Sorry, but cannot confirm the problem you are having. Tested on my server. Perhaps it is a special server setting, manipulation done on database/code or simply the database version/php version in use.

[Casper_O]

here is a fiddle that shows what happens, excatly at the sites im looking at, they are spread over diffrent hosting providers so its not because the have the same server setup at all:

https://www.db-fiddle.com/f/66HvRYMyh5WVrSba71SZ2t/1

[Casper_O]

@selectshop.at When you followed the steps in this posts, how many times to the "Test" come up in your search_word table after step 2 ? and again after step 3?
 

 https://www.prestashop.com/forums/topic/573134-search-index-keeps-getting-corrupted/?do=findComment&comment=2641997