[SOLVED] Index missing product

[ferra1980]

Hi everyone,

When I try to Add missing products to index get this error:

Fatal error: Uncaught Query execution was interrupted

				SELECT p.id_product
				FROM linps_product p
				 INNER JOIN linps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = p.id_shop_default)
				INNER JOIN linps_product_lang pl ON pl.`id_shop` = product_shop.`id_shop`
				WHERE product_shop.visibility IN ("both", "search")
				AND product_shop.`active` = 1
				AND product_shop.indexed = 0
thrown in /web/htdocs/www.lin.it/home/new/classes/db/Db.php on line 639

I have 12000 products and using prestashop 1.6.0.11

 

Also when I try to re-build entire index I get Internal server error after 5500 products.

Can someone help me?

 

Thanks

 

SOLVED using eMagicOne Store Manager, I've re-built entire index using this desktop software and then I've post the changes to web.

Edited February 10, 2015 by ferra1980 (see edit history)

[Fuz]

Hellou to all, I also have a problem with "Add missing products to index" on Preferences-> Search.  Searchtoken-full end on 960+- products. I have only 2500+- products. 

 

Does anyone have a solution for this? Please.

 

error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate bytes) in /data/web/virtuals/41090/virtual/www/classes/db/DbPDO.php on line 119

 

->memory limit set to 256M

 

PS v.1.6.0.11 - after upgrade from v. 1.5.6.2.

 

Thank you in advance...

[leste]

Hello FUZ...

have you found a solution to this problem or a response?

thank you

[Fuz]

Hello FUZ...

have you found a solution to this problem or a response?

thank you

Hellou, 

 

sorry for late reply. Today I found a fix for this bug. This one helped to me -> https://github.com/PrestaShop/PrestaShop/pull/2649/files from this link->http://forge.prestashop.com/browse/PSCSX-4717.

 

Fuz.