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 'tzaro_v2_live.tbl_products.id' 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 * FROM `tbl_products` WHERE (status = 1 and category_id = 8 and (parent_id is null OR parent_id = 0)) AND (`used_for`=3) GROUP BY `unique_id` ORDER BY `preview_order` DESC, `inventory` DESC LIMIT 12

Error Info: Array
(
    [0] => 42000
    [1] => 1055
    [2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tzaro_v2_live.tbl_products.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
$_GET = [
    'name' => 'ilina-watches',
    'price' => '3',
];