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. /**
319. if ($sql instanceof DbQuery)
320. $sql = $sql->build();
321.
322. $this->result = $this->_query($sql);
323. if (_PS_DEBUG_SQL_)
324. $this->displayError($sql);
325. return $this->result;
326. }
327.
328. /**
329. * Execute an INSERT query
Argument [0] 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
495. {
496. $this->last_cached = true;
497. return $result;
498. }
499.
500. $this->result = $this->query($sql);
501.
502. if (!$this->result)
503. $result = false;
504. else
505. {
Argument [0] 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
115. Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
116. LEFT JOIN '._DB_PREFIX_.'image_lang il ON (il.id_image = image_shop.id_image)
117. LEFT JOIN '._DB_PREFIX_.'category_lang cl ON (cl.id_category = product_shop.id_category_default'.Shop::addSqlRestrictionOnLang('cl').')
118. WHERE p.id_product IN ('.$productIds.')
119. AND pl.id_lang = '.(int)($id_lang).'
120. AND cl.id_lang = '.(int)($id_lang).'
121. GROUP BY product_shop.id_product');
122. $related_products = array();
123. foreach ($products as $p)
124. $related_products[$p['id_product']] = $p;
125.
Argument [0] 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
25. {
26. $this->id_cs_blog_post = Tools::getValue('id_cs_blog_post');
27. $this->csLink = new csLink();
28. $this->csTag = new CSBLTag();
29. parent::initContent();
30. $this->_display();
31. $this->setTemplate('post.tpl');
32. }
33.
34. function _display()
35. {
174.
175. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
176. $this->initHeader();
177.
178. if ($this->viewAccess())
179. $this->initContent();
180. else
181. $this->errors[] = Tools::displayError('Access denied.');
182.
183. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
184. $this->initFooter();
367. // Execute hook dispatcher
368. if (isset($params_hook_action_dispatcher))
369. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
370.
371. // Running controller
372. $controller->run();
373. }
374. catch (PrestaShopException $e)
375. {
376. $e->displayMessage();
377. }
23. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require(dirname(__FILE__).'/config/config.inc.php');
28. Dispatcher::getInstance()->dispatch();