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 ('12', '109', '110', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '719', '720', '721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '760', '761', '762', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782', '783', '784', '785', '786', '787', '788', '789', '790', '791', '792', '793', '794', '795', '796', '797', '798', '799', '800', '801', '802', '803', '804', '805', '806', '807', '808', '809', '810', '811', '812', '813', '814', '815', '816', '817', '1508', '1509', '1510', '1511', '1512', '1513', '1514', '1515')) 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' => '12',
    'page' => '2',
];

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