Incomplete products indexing

[MarcAur]

Hello everyone,

 

Our Prestashop (1.5) is undergoing strange problems while indexing products (Preferences > Search), the number of indexed products never grow higher than 804/967.

 

We've tried many times "Add missing products" and "Re-build the entire index" : the counter always stops at 804.

 

Any ideas on what could possibly cause such and odd behavior ?

 

Any help greatly appreciated !

 

thanks,

Marc

 

Our website : http://marc-aurele.ru/

[ufctemple1]

We are having a similar but slightly less problematic issue:  we are missing ONE item in the product search indexation.

 

So, currently our "Indexed Products" always sits one less than the total number of products.  Currently it is at 1373/1374.

 

Any help finding that corrupted or missing product would be much appreciated:  ufctemple.com

Thanks, Jon in Texas

[parsifal]

Hi guys.

 

Do you have any products with their visibility set to 'None'?

 

This can cause the symptom you are describing. It works like this: products with no visibility don't get indexed. IF you changed something in their descriptions AFTER having set their visibility to "none", they will perpetually be reported as unindexed (and annoy you every time you check the index status! )

 

You can quickly find any such products if you go to BackOffice > Advanced Parameters > SQL Manager, then create and run the following SQL query:

 

SELECT * FROM ps_product WHERE visibility = 'none';

Just change their visibility to, say "Search only", reindex the missing products, change visibility back to "None" and don't ever again touch their descriptions!

Edited November 30, 2014 by parsifal (see edit history)

[Nicowcow]

Thanks for your advice parsifal !

 

But all my products are visible everywhere and i have the same problem as MarcAur. (480/2842 indexed products)

[parsifal]

Thanks for your advice parsifal !

 

But all my products are visible everywhere and i have the same problem as MarcAur. (480/2842 indexed products)

And if you click on the phrase "Add missing products to index", what happens then? The missing products don't get indexed?

Edited December 1, 2014 by parsifal (see edit history)

[ufctemple1]

parsifal -- that is correct:

"The "indexed" products have been analyzed by PrestaShop and will appear in the results of a Front Office search.

Indexed products 1385 / 1386."

[parsifal]

parsifal -- that is correct:

 

The "indexed" products have been analyzed by PrestaShop and will appear in the results of a Front Office search.

Indexed products 1385 / 1386

What about the SQL query I mentioned above? Does it return any results?

Edited December 1, 2014 by parsifal (see edit history)

[Nicowcow]

And if you click on the phrase "Add missing products to index", what happens then? The missing products don't get indexed?

 

No, they don't get indexed. I have a 500 error after waiting about 1min

[parsifal]

No, they don't get indexed. I have a 500 error after waiting about 1min

This could be a PHP timeout issue. Have you tried increasing the max_execution_time value? Example here.

[Nicowcow]

Yes I created a php.ini file in the admin folder and put this in it :

 

max_input_vars = 10153
suhosin.post.max_vars = 10153
suhosin.request.max_vars = 10153
max_execution_time = 20000
max_input_time = 3000
max_execution_time = 0
memory_limit = -1

 

But the problem is still there

[Nicowcow]

Oh wait i have this error :

 

 

Fatal error: Uncaught Deadlock found when trying to get lock; try restarting transaction<br /><br /><pre>INSERT INTO ps_search_index (id_product, id_word, weight) VALUES (918,93978,1),(918,93979,1),(918,93980,1),(918,76594,1),(918,93981,1),(918,33080,1),(918,70177,1),(918,93982,2),(918,86197,1),(918,93983,1),(918,41296,1),(918,38320,1),(918,14576,1),(918,10536,1),(918,10432,1),(918,40599,1),(918,52709,1),(918,38268,1),(918,33053,2),(918,33056,1),(918,18280,1),(918,6775,1),(918,746,1),(918,33057,1),(918,22040,1),(918,38293,1),(918,19374,1),(918,14575,1),(918,54282,1),(918,23220,1),(918,28221,1),(918,33054,1),(918,90506,3),(918,45625,3),(918,6786,4),(918,96048,8),(918,96049,4),(918,6818,4464),(918,91981,4464),(918,6815,4464),(918,91982,4464),(918,91983,4464),(918,52954,2232),(918,19397,1984),(918,85052,2232),(918,31073,496),(918,52990,15),(918,8603,12),(918,833,7),(918,31894,6),(918,96050,7),(918,5292,11),(918,91216,12),(918,10678,12),(918,86574,9),(918,91217,21),(918,96051,16),(918,46361,16),(918,96052,1),(918,91995,1) in /homepages/6/d366098234/htdocs/classes/db/Db.php on line635

 

 

Help !

[MarcAur]

We've tried the same things without any luck :

- products visibility : all of them are set to 'both'

- increase memory and timeout limits : no difference

 

Marc