How To Fix GroupBy Not Working In Laravel
In this post we will give you information about How To Fix GroupBy Not Working In Laravel. Hear we will give you detail about How To Fix GroupBy Not Working In LaravelAnd how to use it also give you demo for it if it is necessary.
Recently we are working with laravel application and in my one of the system laravel groupBy not working and it show following error. we are search lots of in google and finaly we are find best solution how to fix it very easy way.
Error Message Look Like
[ADDCODE]
Laravel 5.5 group by doesn't work - fixed
In this post we will give you information about Laravel 5.5 group by doesn't work - fixed. Hear we will give you detail about Laravel 5.5 group by doesn't work - fixedAnd how to use it also give you demo for it if it is necessary.
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")
->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.
Thank you...
Hope this code and post will helped you for implement Laravel 5.5 group by doesn't work - fixed. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
Error message!!
#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘opaper.notifications.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
This problem always arise when we are formate our system and not fully install some dependacy regarding mysql. so, how to fix it simple follow this step and fix it.
Step – 1 : Open Your /etc/mysql/my.cnf file
First open your /etc/mysql/my.cnf file using following command and make some following changes.
sudo nano /etc/mysql/my.cnf
After open this file in nano editor then after go to the last and add following code in this file and save it.
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Step – 2 : Open Your config/database.php file
Then after open your laravel application’s config/database.php file and make some following changes.
'mysql' => [
'strict' => false,
//'strict' => true,
],
Step – 3 : Restart Your MySql
Then after restart your MySql server by following command. and your problem is gone.
sudo service mysql restart
If you face any problem then please write a comment or give some suggestions for improvement. Thanks…
Hope this code and post will helped you for implement How To Fix GroupBy Not Working In Laravel. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs