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]
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...
Hi, My name is Harsukh Makwana. i have been work with many programming language like php, python, javascript, node, react, anguler, etc.. since last 5 year. if you have any issue or want me hire then contact me on harsukh21@gmail.com
How to remove wrapper element but keep the text content intact using jQuery
Use the jQuery unwrap() method...Login with Facebook in Angular9 using Firebase
I am going to talk about How you can&nbs...How to Check If a String Contains a Specific Word in PHP
Use the PHP strpos() Function You can...How to reverse the order of an array in PHP
Use the PHP array_reverse() fu...How to check if an element is hidden using jQuery
Use the jQuery :hidden Selector The j...