Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jazma_jazma.ps_layered_category.id_layered_category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT * FROM ps_layered_category
WHERE id_category = 9
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
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 * FROM ps_layered_category WHERE id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
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 * FROM ps_layered_category WHERE id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
2046. $filters = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
2047. SELECT * FROM '._DB_PREFIX_.'layered_category
2048. WHERE id_category = '.(int)$id_parent.'
2049. AND id_shop = '.$id_shop.'
2050. GROUP BY `type`, id_value ORDER BY position ASC'
2051. );
2052. // Remove all empty selected filters
2053. foreach ($selected_filters as $key => $value)
2054. switch ($key)
2055. {
2056. case 'price':
Argument [0] SELECT * FROM ps_layered_category WHERE id_category = 9 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
691. return false;
692.
693. global $smarty, $cookie;
694.
695. // No filters => module disable
696. if ($filter_block = $this->getFilterBlock($this->getSelectedFilters()))
697. if ($filter_block['nbr_filterBlocks'] == 0)
698. return false;
699.
700. if (Tools::getValue('id_category', Tools::getValue('id_category_layered', Configuration::get('PS_HOME_CATEGORY'))) == Configuration::get('PS_HOME_CATEGORY'))
701. return;
Argument [0] Array ( [category] => Array ( ) )
503.
504. // Call hook method
505. if ($hook_callable)
506. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
507. elseif ($hook_retro_callable)
508. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
509. // Live edit
510. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
511. {
512. $live_edit = true;
513. $output .= self::wrapLiveEdit($display, $moduleInstance, $array['id_hook']);
Argument [0] Array ( [cookie] => Cookie Object ( [_content:protected] => Array ( [date_add] => 2024-03-28 19:35:10 [id_lang] => 3 [id_currency] => 2 ) [_name:protected] => ee71a5687e53d260a86f630d713c16c7 [_expire:protected] => 1713353710 [_domain:protected] => www.jazmawatch.com [_path:protected] => / [_cipherTool:protected] => Rijndael Object ( [_key:protected] => rgZ4djyBTfPpir6gu5xg4GRIO8zmHJjN [_iv:protected] => ¾²w|¡_'ÄÕU—#áÊ ) [_modified:protected] => 1 [_allow_writing:protected] => 1 [_salt:protected] => 8rHgFd5O [_standalone:protected] => ) [cart] => Cart Object ( [id] => [id_shop_group] => 1 [id_shop] => 1 [id_address_delivery] => 0 [id_address_invoice] => 0 [id_currency] => 2 [id_customer] => [id_guest] => 0 [id_lang] => 3 [recyclable] => 0 [gift] => 0 [gift_message] => [mobile_theme] => [date_add] => [secure_key] => [id_carrier] => 0 [date_upd] => [checkedTos] => [pictures] => [textFields] => [delivery_option] => [allow_seperated_package] => [_products:protected] => [_taxCalculationMethod:protected] => 0 [webserviceParameters:protected] => Array ( [fields] => Array ( [id_address_delivery] => Array ( [xlink_resource] => addresses ) [id_address_invoice] => Array ( [xlink_resource] => addresses ) [id_currency] => Array ( [xlink_resource] => currencies ) [id_customer] => Array ( [xlink_resource] => customers ) [id_guest] => Array ( [xlink_resource] => guests ) [id_lang] => Array ( [xlink_resource] => languages ) ) [associations] => Array ( [cart_rows] => Array ( [resource] => cart_row [virtual_entity] => 1 [fields] => Array ( [id_product] => Array ( [required] => 1 [xlink_resource] => products ) [id_product_attribute] => Array ( [required] => 1 [xlink_resource] => combinations ) [id_address_delivery] => Array ( [required] => 1 [xlink_resource] => addresses ) [quantity] => Array ( [required] => 1 ) ) ) ) ) [id_shop_list] => [get_shop_from_context:protected] => 1 [table:protected] => cart [identifier:protected] => id_cart [fieldsRequired:protected] => Array ( [0] => id_currency [1] => id_lang ) [fieldsSize:protected] => Array ( [secure_key] => 32 ) [fieldsValidate:protected] => Array ( [id_shop_group] => isUnsignedId [id_shop] => isUnsignedId [id_address_delivery] => isUnsignedId [id_address_invoice] => isUnsignedId [id_carrier] => isUnsignedId [id_currency] => isUnsignedId [id_customer] => isUnsignedId [id_guest] => isUnsignedId [id_lang] => isUnsignedId [recyclable] => isBool [gift] => isBool [gift_message] => isMessage [mobile_theme] => isBool [allow_seperated_package] => isBool [date_add] => isDateFormat [date_upd] => isDateFormat ) [fieldsRequiredLang:protected] => Array ( ) [fieldsSizeLang:protected] => Array ( ) [fieldsValidateLang:protected] => Array ( ) [tables:protected] => Array ( ) [image_dir:protected] => [image_format:protected] => jpg [def:protected] => Array ( [table] => cart [primary] => id_cart [fields] => Array ( [id_shop_group] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_shop] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_delivery] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_invoice] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_carrier] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_currency] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [id_customer] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_guest] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_lang] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [recyclable] => Array ( [type] => 2 [validate] => isBool ) [gift] => Array ( [type] => 2 [validate] => isBool ) [gift_message] => Array ( [type] => 3 [validate] => isMessage ) [mobile_theme] => Array ( [type] => 2 [validate] => isBool ) [delivery_option] => Array ( [type] => 3 ) [secure_key] => Array ( [type] => 3 [size] => 32 ) [allow_seperated_package] => Array ( [type] => 2 [validate] => isBool ) [date_add] => Array ( [type] => 5 [validate] => isDateFormat ) [date_upd] => Array ( [type] => 5 [validate] => isDateFormat ) ) [classname] => Cart ) [update_fields:protected] => [force_id] => ) [altern] => 8 )
441. if (!$this->useMobileTheme())
442. {
443. // These hooks aren't used for the mobile theme.
444. // Needed hooks are called in the tpl files.
445. $this->context->smarty->assign(array(
446. 'HOOK_HEADER' => Hook::exec('displayHeader'),
447. 'HOOK_TOP' => Hook::exec('displayTop'),
448. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
449. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
450. ));
451. }
Argument [0] displayHeader
1.
2. class smartblogModuleFrontController extends ModuleFrontController
3. {
4. public function initContent()
5. {
6. parent::initContent();
7. if($id_category = Tools::getvalue('id_category') && Tools::getvalue('id_category') != Null){
8. $this->context->smarty->assign(BlogCategory::GetMetaByCategory(Tools::getvalue('id_category')));
9. }
10. if($id_post = Tools::getvalue('id_post') && Tools::getvalue('id_post') != Null){
11. $this->context->smarty->assign(SmartBlogPost::GetPostMetaByPost(Tools::getvalue('id_post')));
7.
8. public function init(){
9. parent::init();
10. }
11. public function initContent(){
12. parent::initContent();
13. $category_status = '';
14. $totalpages = '';
15. $cat_image = 'no';
16. $categoryinfo = '';
17. $title_category = '';
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. }
22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
23. * International Registered Trademark & Property of PrestaShop SA
24. */
25.
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();