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 ('7', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '434', '435', '436', '437', '438', '439', '440', '441', '442', '443', '444', '445', '446', '447', '448', '449', '450', '451', '452', '453', '454', '455', '456', '457', '458', '459', '460', '461', '462', '463', '464', '465', '466', '467', '468', '469', '470', '471', '472', '473', '474', '475', '476', '477', '478', '479', '480', '481', '1489', '1490', '1491', '1492', '1493', '1494', '1495', '1496')) 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' => '7',
];

$_SESSION = [
    '__flash' => [],
    'category' => 12,
    'category_asli' => 7,
];