Please help! - [PrestaShopDatabaseException] Query execution was interrupted

[RwVision]

Hi all,

 

So I'm adding new products to my shop, everythings fine... and after a 20 I suddenly get this error:

 

It appears when I'm trying to access the catalog-products page in panel

 

Where I'm supposed to look, what could it mean?. Can't find anywhere the answer:/

 

Presta ver 1.6

[PrestaShopDatabaseException]

Query execution was interrupted


			SELECT SQL_CALC_FOUND_ROWS
			a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active,cp.position as position
			, shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, sa.`active`, IF(sav.`quantity`<=0, 1, 0) badge_danger , cp.`position`
			FROM `pss_product` a
			LEFT JOIN `pss_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
			
		LEFT JOIN `pss_image` i ON (i.`id_product` = a.`id_product`)
		LEFT JOIN `pss_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
		 AND sav.id_shop = 1  AND sav.id_shop_group = 0 )  JOIN `pss_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
				LEFT JOIN `pss_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
				LEFT JOIN `pss_shop` shop ON (shop.id_shop = a.id_shop_default) 
				LEFT JOIN `pss_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
				LEFT JOIN `pss_product_download` pd ON (pd.`id_product` = a.`id_product`) INNER JOIN `pss_category_product` cp ON (cp.`id_product` = a.`id_product` AND cp.`id_category` = 16)  
			
			WHERE 1 
			GROUP BY sa.id_product 
			
			ORDER BY cp.`position` ASC LIMIT 0,50

at line 635 in file classes/db/Db.php
629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 2791 - classes/controller/AdminController.php] - [3 Arguments]
AdminControllerCore->getList - [line 358 - controllers/admin/AdminProductsController.php] - [6 Arguments]
AdminProductsControllerCore->getList - [line 1992 - classes/controller/AdminController.php] - [1 Arguments]
AdminControllerCore->renderList - [line 2431 - controllers/admin/AdminProductsController.php]
AdminProductsControllerCore->renderList - [line 1768 - classes/controller/AdminController.php]
AdminControllerCore->initContent - [line 2362 - controllers/admin/AdminProductsController.php]
AdminProductsControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

Edited August 1, 2014 by RwVision (see edit history)