Laravel 5.5 group by doesn't work - fixed

By Hardik Savani | September 22, 2017 | Category : PHP Laravel

Someday ago i just installed laravel 5.5 application and i was checking new feature and making some examples. But i was working on database query builder example one by one, i got following error when i used group by on single column.

My query was like as bellow 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")




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 '' 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:



'strict' => true,


'strict' => false,


After that i hope you found your solution.

Thank you...

Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: