Query execution was interrupted

[web-contact]

Hello,
since a few days, i can't acces the front office, the BO is ok and there is no probleme with managing catalog.
The debug mode display :

[PrestaShopDatabaseException]

Query execution was interrupted
 

SELECT 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`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,
            product_shop.`date_add` > "2013-09-28" as new,
MAX(product_attribute_shop.id_product_attribute) id_product_attribute
FROM `stec_product` p
 INNER JOIN stec_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `stec_product_lang` `pl` ON
            p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = 5 AND pl.id_shop = 1
LEFT JOIN `stec_image` `i` ON i.`id_product` = p.`id_product`
 LEFT JOIN stec_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 `stec_image_lang` `il` ON i.`id_image` = il.`id_image` AND il.`id_lang` = 5
LEFT JOIN `stec_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT OUTER JOIN `stec_product_attribute` pa ON p.`id_product` = pa.`id_product`
 LEFT JOIN stec_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)
 LEFT
            JOIN stec_stock_available stock
            ON (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` > "2013-09-28") AND (p.`id_product` IN (
            SELECT cp.`id_product`
            FROM `stec_category_group` cg
            LEFT JOIN `stec_category_product` cp ON (cp.`id_category` = cg.`id_category`)
            WHERE cg.`id_group` = 1
        ))
GROUP BY product_shop.id_product
ORDER BY p.`date_add` DESC
LIMIT 5

at line 613 in file classes/db/Db.php

<code>
607.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 2067 - classes/Product.php] - [1 Arguments]
ProductCore::getNewProducts - [line 114 - modules/blocknewproducts/blocknewproducts.php] - [3 Arguments]
BlockNewProducts->hookRightColumn - [line 459 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 426 - classes/controller/FrontController.php] - [2 Arguments]
FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php] - [0 Argument]
IndexControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

////////////////

Any idea to solve this problem ?

Thanks


Presta 1.5.5
Php 5.4.6 / Mysql 5.1.66