Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 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 `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` FROM `ipr_product_sku` `ps` JOIN `ipr_product` `p` ON p.id = ps.product_id AND p.id = ps.product_id_reference JOIN `ipr_assign_product_cat` `apc` ON apc.product_sku_id = ps.id JOIN `ipr_product_store` `pstore` ON pstore.product_sku_id = ps.id JOIN `ipr_master_status` `ms` ON ms.id = p.product_type WHERE (`pstore`.`store_id`='933') AND (`ps`.`status_id`='44') AND (`ps`.`view_store`='1') AND (`ps`.`login`=0) GROUP BY `p`.`id`) `c`

Error Info: Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #1 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 = [
    'id' => '933',
];

$_SESSION = [
    '__flash' => [],
];