Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'belaintan.ps.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
The SQL being executed was: SELECT COUNT(*) FROM (SELECT `p`.`prakatalog`, `ps`.`name`, `ps`.`id` AS `sku_id`, `ps`.`sku`, `ps`.`has_ppn`, `ps`.`has_shipping`, `p`.`id`, `ms`.`name` AS `product_type_name`, `ps`.`produsen_type`, `p`.`price_type`, `p`.`product_type`, `ps`.`made_in`, `apc`.`product_sku_id` FROM `ipr_product_sku` `ps` LEFT JOIN `ipr_product` `p` ON p.id = ps.product_id AND p.id = ps.product_id_reference LEFT JOIN `ipr_assign_product_cat` `apc` ON apc.product_sku_id = ps.id LEFT JOIN `ipr_product_price` `product_price` ON product_price.product_sku_id = ps.id AND product_price.price >= 0 AND product_price.price <= 9999999999999999999 AND product_price.zona = 0 LEFT JOIN `ipr_master_status` `ms` ON ms.id = p.product_type LEFT JOIN `ipr_product_store` `product_store` ON product_store.product_sku_id = ps.id LEFT JOIN (SELECT product_sku_id, avg(rating) AS rating FROM ipr_product_rating GROUP BY product_sku_id) as product_rating ON product_rating.product_sku_id = ps.id WHERE (`apc`.`category_id` IN ('74', '506', '507', '508', '509', '510', '511', '512', '513', '514', '515', '516', '517', '518', '519', '520')) AND (ps.status_id ='44') AND (`ps`.`id` NOT IN (SELECT `product_sku_id` FROM `ipr_product_bundle` WHERE `is_hide`=1)) AND (`ps`.`view_cat`='1') GROUP BY `p`.`id` ORDER BY `ps`.`created_at` DESC) `c`

Error Info: Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'belaintan.ps.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
$_GET = [
    'category' => '74',
];

$_SESSION = [
    '__flash' => [],
    'category' => 5,
    'category_asli' => 4,
];