Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #31 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vadim775_2.shop_item_discounts.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Query: SELECT *
FROM `shop_discounts`
INNER JOIN `shop_item_discounts` ON `shop_discounts`.`id` = `shop_item_discounts`.`shop_discount_id`
WHERE `shop_id` = '22' AND `shop_item_discounts`.`shop_item_id` = '295722' AND `shop_discounts`.`active` = 1 AND `shop_discounts`.`coupon` = 1 AND `shop_discounts`.`coupon_text` != '' AND ( `shop_discounts`.`start_datetime` < '2026-05-05 11:13:23' OR `shop_discounts`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_discounts`.`end_datetime` > '2026-05-05 11:13:23' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' )
GROUP BY `shop_discounts`.`id`
ORDER BY `shop_discounts`.`id` ASC
modules/core/database/pdo.php:679 Core_Exception->__construct
modules/core/querybuilder/statement.php:86 Core_DataBase_Pdo->query
hostcmsfiles/lib/lib_156/lib_156.php:561 Core_QueryBuilder_Statement->execute
modules/lib/model.php:389 include
modules/core/page.php:179 Lib_Model->execute
templates/template240/template.htm:13 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:179 Template_Model->execute
templates/template206/template.htm:570 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:179 Template_Model->execute
modules/core/command/controller/default.php:723 Core_Page->execute
modules/core/router/route.php:280 Core_Command_Controller_Default->showAction
modules/core/router/route.php:290 Core_Router_Route->{closure}
index.php:406 Core_Router_Route->execute