Laravel 5.5 group by doesn't work

In Laravel5.5  I  got following error when I used group by on single column.

My query was like as below example so you can see on database query I simple get all users and group by with name. So, let's simply see how it is:

DB Query:

$users = DB::table("users")

->groupBy("name")

->get();

dd($users);

But when i run above query using database query builder i got following error, as you can see:

SQLSTATE[42000]: Syntax error or access violation: 1055 'laravel_test.users.id' isn't in GROUP BY (SQL: select * from `users` group by `name`)

I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply "strict" mode make it true into false in database.php file. So let's do it as bellow:

config/database.php

...

'strict' => true,



To



'strict' => false,

....

After that i hope you found your solution.