Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
Faced same problem with laravel 5.3 They are trying to enforce strict query writing came with mysql-5.7 However to disabled this just go to config/database.php and change strict flag ‘mysql’ => [ . . . ‘strict’ => false, //’strict’ => true, . . ], Hope this will solve your problem too. PS – For details … Read more