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 ('16', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '1325', '1326', '1327', '1328', '1329', '1330', '1331', '1332', '1333', '1334', '1335', '1336', '1337', '1338', '1339', '1340', '1341', '1342', '1343', '1344', '1345', '1346', '1347', '1348', '1349', '1350', '1351', '1352', '1353', '1354', '1355', '1356', '1357', '1358', '1359', '1360', '1361', '1362', '1363', '1364', '1365', '1366', '1367', '1368', '1369', '1370', '1371', '1372', '1373', '1374', '1375', '1376', '1377', '1378', '1379', '1380', '1381', '1382', '1383', '1384', '1385', '1386', '1387', '1388', '1389', '1390', '1391', '1392', '1393', '1394', '1395', '1396', '1397', '1398', '1399', '1400', '1401', '1402', '1403', '1404', '1405', '1406', '1407', '1408', '1409', '1410', '1411', '1412', '1413', '1414', '1415', '1416', '1417', '1418', '1419', '1420', '1421', '1422', '1423', '1424', '1425', '1426', '1427', '1428', '1429', '1430', '1431', '1432', '1433', '1434', '1435', '1436', '1437', '1438', '1439', '1440', '1441', '1442', '1443', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1526', '1527', '1528', '1529', '1530', '1531', '1532', '1533', '7001')) 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' => '16',
    'page' => '5',
];

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