Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'filtershopgr_shop.ps_layered_category.filter_show_limit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 50
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
420. $this->result = $this->_query($sql);
421. }
422. }
423.
424. if (_PS_DEBUG_SQL_) {
425. $this->displayError($sql);
426. }
427.
428. return $this->result;
429. }
430.
Argument [0] SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 50 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
638. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
639. }
640. return $this->execute($sql, $use_cache);
641. }
642.
643. $this->result = $this->query($sql);
644.
645. if (!$this->result) {
646. $result = false;
647. } else {
648. if (!$array) {
Argument [0] SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 50 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
2123. $filters = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
2124. SELECT type, id_value, filter_show_limit, filter_type FROM '._DB_PREFIX_.'layered_category
2125. WHERE id_category = '.(int)$id_parent.'
2126. AND id_shop = '.$id_shop.'
2127. GROUP BY `type`, id_value ORDER BY position ASC'
2128. );
2129.
2130. /* Create the table which contains all the id_product in a cat or a tree */
2131.
2132. Db::getInstance()->execute('DROP TEMPORARY TABLE IF EXISTS '._DB_PREFIX_.'cat_restriction', false);
2133. Db::getInstance()->execute('CREATE TEMPORARY TABLE '._DB_PREFIX_.'cat_restriction ENGINE=MEMORY
Argument [0] SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 50 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
683. return false;
684.
685. global $smarty, $cookie;
686.
687. // No filters => module disable
688. if ($filter_block = $this->getFilterBlock($this->getSelectedFilters()))
689. if ($filter_block['nbr_filterBlocks'] == 0)
690. return false;
691.
692. if (Tools::getValue('id_category', Tools::getValue('id_category_layered', Configuration::get('PS_HOME_CATEGORY'))) == Configuration::get('PS_HOME_CATEGORY'))
693. return;
Argument [0]
Array
(
[category] => Array
(
[0] => 50
)
)
582. }
583. }
584.
585. // Immediately return the result if we do not log performances
586. if (!Module::$_log_modules_perfs) {
587. return $module->{$method}($params);
588. }
589.
590. // Store time and memory before and after hook call and save the result in the database
591. $time_start = microtime(true);
592. $memory_start = memory_get_usage(true);
Argument [0]
539.
540. // Call hook method
541. if ($hook_callable) {
542. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
543. } elseif ($hook_retro_callable) {
544. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
545. }
546.
547. // Live edit
548. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad')
549. && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'
Argument [0] Argument [1] hookHeader Argument [2]
574.
575. if (!$this->useMobileTheme()) {
576. // These hooks aren't used for the mobile theme.
577. // Needed hooks are called in the tpl files.
578. $this->context->smarty->assign(array(
579. 'HOOK_HEADER' => Hook::exec('displayHeader'),
580. 'HOOK_TOP' => Hook::exec('displayTop'),
581. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
582. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
583. ));
584. } else {
Argument [0] displayHeader
124. /**
125. * Initializes page content variables
126. */
127. public function initContent()
128. {
129. parent::initContent();
130.
131. $this->setTemplate(_PS_THEME_DIR_.'category.tpl');
132.
133. if (!$this->customer_access) {
134. return;
184. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
185. $this->initHeader();
186. }
187.
188. if ($this->viewAccess()) {
189. $this->initContent();
190. } else {
191. $this->errors[] = Tools::displayError('Access denied.');
192. }
193.
194. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
362. if (isset($params_hook_action_dispatcher)) {
363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
364. }
365.
366. // Running controller
367. $controller->run();
368. } catch (PrestaShopException $e) {
369. $e->displayMessage();
370. }
371. }
372.
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();