In laravel 5.3 we have strict mode for mysql and if we try to create DataTable with query that has ordering - we got an error. It occurs within make method of DataTable class.
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (SQL: select count(*) as aggregate from bfm_forms_options where field_id = 17 order by lft asc)
In laravel 5.3 we have strict mode for mysql and if we try to create DataTable with query that has ordering - we got an error. It occurs within
makemethod ofDataTableclass.SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (SQL: select count(*) as aggregate from
bfm_forms_optionswherefield_id= 17 order bylftasc)