HELP can't load my site in full site

[and12345]

Hi need your help guys, just installed Prestashop 1.5.6.2 and recently i got this error :

 

[PrestaShopDatabaseException]

'c9id.a.id_product' isn't in GROUP BY

SELECT SQL_CALC_FOUND_ROWS
		a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active
		, 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, sav.`quantity` as sav_quantity, sa.`active`
		FROM `ps_product` a
		LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
		
		LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`)
		LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
		 AND sav.id_shop = 1 )  JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
				LEFT JOIN `ps_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 `ps_shop` shop ON (shop.id_shop = a.id_shop_default) 
				LEFT JOIN `ps_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) 
		
		WHERE 1 
		GROUP BY sa.id_product 
		
		ORDER BY a.`id_product` ASC LIMIT 0,50

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

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 2301 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->getList - [line 328 - controllers/admin/AdminProductsController.php] - [6 Arguments]
• AdminProductsControllerCore->getList - [line 1608 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->renderList - [line 2304 - controllers/admin/AdminProductsController.php] - [0 Argument]
• AdminProductsControllerCore->renderList - [line 1502 - classes/controller/AdminController.php] - [0 Argument]
• AdminControllerCore->initContent - [line 2296 - controllers/admin/AdminProductsController.php] - [0 Argument]
• AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 53 - admin2996/index.php] - [0 Argument]

[and12345]

what i've done is after login to BO i select catalog - products

several menu also got affected like 

 

 

 

• Bad SQL query
  'c9id.a.name' isn't in GROUP BY