Jump to content

[PrestaShopDatabaseException] sur certaines catégories


Recommended Posts

Bonjour,

 

Je n'avais pas constaté ce problème auparavant : sur certaines catégories, j'ai ce message d'erreur 

[PrestaShopDatabaseException]

Query execution was interrupt

SELECT
				p.*,
				product_shop.*,
				product_shop.id_category_default,
				pl.*,
				MAX(image_shop.`id_image`) id_image,
				il.legend, 
				m.name manufacturer_name,
				MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
				DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new,
				stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
			FROM `ps_category_product` cp
			LEFT JOIN ps_category c ON (c.id_category = cp.id_category)
			LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
			 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
			 LEFT 
			JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
			LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 5)
			LEFT JOIN `ps_image` i  ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
			LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5)
			LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
			LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
			WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
			AND c.nleft >= 5 AND c.nright <= 6
			AND c.active = 1
			AND p.id_product IN (1,2,3,5,6,7,8,11,13,21,23,34,39,73,74,99,101)
			GROUP BY product_shop.id_product
			ORDER BY p.date_add desc LIMIT 0,12

Avez-vous une idée de quoi ça peut venir et comment résoudre le problème ?

 

Problème constaté sous Chrome et IE.

 

Je vous met une capture d'écran de ce qui s'affiche en dessous

 

Merci d'avance :)

post-507578-0-84392300-1404811504_thumb.jpg

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...