[PrestaShopDatabaseException]

Expression #48 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'goorgani_live.il.legend' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

					SELECT MAX(image_shop.id_image) id_image, p.*, il.legend, product_shop.*, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite
					FROM ps_product p
					 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
					LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 )
					LEFT JOIN ps_image i ON (i.id_product = p.id_product) LEFT JOIN ps_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 ps_image_lang il ON (il.id_image = image_shop.id_image)
					LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
					WHERE p.id_product IN (9,13,23,19)
					AND pl.id_lang = 1
					AND cl.id_lang = 1
					GROUP BY product_shop.id_product

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. 	/**