thomas-59 Posted September 18, 2014 Share Posted September 18, 2014 Bonjour, En me connectant à mon site j'ai régulièrement le message d'erreur ci-dessous. Est-ce que quelqu'un sait d'où ça peut venir et comment y remédier ? Merci ! [PrestaShopDatabaseException]Query execution was interruptedSELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,product_shop.`date_add` > "2014-06-10" as new,MAX(product_attribute_shop.id_product_attribute) id_product_attributeFROM `mb_product` pINNER JOIN mb_product_shop product_shopON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `mb_product_lang` `pl` ONp.`id_product` = pl.`id_product`AND pl.`id_lang` = 1 AND pl.id_shop = 1LEFT JOIN `mb_image` `i` ON i.`id_product` = p.`id_product`LEFT JOIN mb_image_shop image_shopON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)LEFT JOIN `mb_image_lang` `il` ON i.`id_image` = il.`id_image` AND il.`id_lang` = 1LEFT JOIN `mb_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`LEFT OUTER JOIN `mb_product_attribute` pa ON p.`id_product` = pa.`id_product`LEFT JOIN mb_product_attribute_shop product_attribute_shopON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.default_on = 1)LEFTJOIN mb_stock_available stockON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 )WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2014-06-10") AND (p.`id_product` IN (SELECT cp.`id_product`FROM `mb_category_group` cgLEFT JOIN `mb_category_product` cp ON (cp.`id_category` = cg.`id_category`)WHERE cg.`id_group` AND p.`id_product` IN (SELECT cp.`id_product`FROM `mb_category_group` cgLEFT JOIN `mb_category_product` cp ON (cp.`id_category` = cg.`id_category`)WHERE cg.`id_group` = 1)))GROUP BY product_shop.id_productORDER BY p.`date_add` DESCLIMIT 8at line 635 in file classes/db/Db.php629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /**DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]DbCore->executeS - [line 2111 - classes/Product.php] - [1 Arguments]ProductCore::getNewProducts - [line 115 - modules/blocknewproducts/blocknewproducts.php] - [3 Arguments]BlockNewProducts->getNewProducts - [line 157 - modules/blocknewproducts/blocknewproducts.php]BlockNewProducts->hookdisplayHomeTab - [line 507 - classes/Hook.php] - [1 Arguments]HookCore::exec - [line 41 - controllers/front/IndexController.php] - [1 Arguments]IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]ControllerCore->run - [line 373 - classes/Dispatcher.php]DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
2FR3 Posted September 23, 2014 Share Posted September 23, 2014 C'est une erreur 500, je pense que c'est votre hébergement qui est trop faible. Qu'avez vous comme hebergement ? 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