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 ('15', '163', '164', '165', '166', '167', '168', '169', '170', '171', '172', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '1138', '1139', '1140', '1141', '1142', '1143', '1144', '1145', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1157', '1158', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '1168', '1169', '1170', '1171', '1172', '1173', '1174', '1175', '1176', '1177', '1178', '1179', '1180', '1181', '1182', '1183', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1194', '1195', '1196', '1197', '1198', '1199', '1200', '1201', '1202', '1203', '1204', '1205', '1206', '1207', '1208', '1209', '1210', '1211', '1212', '1213', '1214', '1215', '1216', '1217', '1218', '1219', '1220', '1221', '1222', '1223', '1224', '1225', '1226', '1227', '1228', '1229', '1230', '1231', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '1240', '1241', '1242', '1243', '1244', '1245', '1246', '1247', '1248', '1249', '1250', '1251', '1252', '1253', '1254', '1255', '1256', '1257', '1258', '1259', '1260', '1261', '1262', '1263', '1264', '1265', '1266', '1267', '1268', '1269', '1270', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1278', '1279', '1280', '1281', '1282', '1283', '1284', '1285', '1286', '1287', '1288', '1289', '1290', '1291', '1292', '1293', '1294', '1295', '1296', '1297', '1298', '1299', '1300', '1301', '1302', '1303', '1304', '1305', '1306', '1307', '1308', '1309', '1310', '1311', '1312', '1313', '1314', '1315', '1316', '1317', '1318', '1319', '1320', '1321', '1322', '1323', '1324', '1520', '1521', '1522', '1523', '1524', '1525')) 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' => '15',
    'page' => '5',
];

$_SESSION = [
    '__flash' => [],
    'category' => 9,
    'category_asli' => 15,
];