Edit History

Bonjour,

Lorsque je veux avoir accès aux produits d'une catégorie à partir du menu, j'ai cette erreur après un long temps de charge. Si je vais dans les sous-menu, je n'ai pas ce problème mais je peux avoir des "request time out" . Le site est aussi vraiment très lent à charger. 

Avez-vous une idée du problème. 

Nouvel upgrade de 1.6.24 à 1.7.6.8... 

Merci

(1/1) ContextErrorException
Warning: PDO::query(): MySQL server has gone away

in DbPDO.php line 156
at DbPDOCore->_query('SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN (\'both\', \'catalog\') AND c.nleft>=3 AND c.nright<=44 AND ps.id_shop=\'1\' GROUP BY p.id_product) p INNER JOIN category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position DESC LIMIT 0, 12')
in Db.php line 376
at DbCore->query('SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN (\'both\', \'catalog\') AND c.nleft>=3 AND c.nright<=44 AND ps.id_shop=\'1\' GROUP BY p.id_product) p INNER JOIN category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position DESC LIMIT 0, 12')
in Db.php line 613
at DbCore->executeS('SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM product p LEFT JOIN product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN product_sale psales ON (psales.id_product = p.id_product) INNER JOIN category_product cp ON (p.id_product = cp.id_product) INNER JOIN category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN (\'both\', \'catalog\') AND c.nleft>=3 AND c.nright<=44 AND ps.id_shop=\'1\' GROUP BY p.id_product) p INNER JOIN category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position DESC LIMIT 0, 12')
in MySQL.php line 86
at MySQL->execute()
in Products.php line 88
at Products->getProductByFilters(12, 1, 'position', 'desc', array())
in SearchProvider.php line 133
at SearchProvider->runQuery(object(Context), object(ProductSearchQuery))
in ProductListingFrontController.php line 307
at ProductListingFrontControllerCore->getProductSearchVariables()
in ProductListingFrontController.php line 580
at ProductListingFrontControllerCore->doProductSearch('catalog/listing/category', array('entity' => 'category', 'id' => 7))
in CategoryController.php line 137
at CategoryControllerCore->initContent()
in Controller.php line 292
at ControllerCore->run()
in Dispatcher.php line 515
at DispatcherCore->dispatch()
in index.php line 28