lilynette Posted July 8, 2014 Share Posted July 8, 2014 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 Link to comment Share on other sites More sharing options...
lilynette Posted July 10, 2014 Author Share Posted July 10, 2014 Personne ? J'ai envoyé un mail au support d'OVH, j'attend encore leur réponse. Pour info, j'ai ce souci sur les catégorie de 2e rang : Accueil > Categorie > Sous catégorie Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now