GroupBy Error in Laravel Eloquent Builder

Solution:

• Add this configuration to your mysql database config in config/database.php:

     'mysql' => [
          ....
          'strict' => false,
          //'strict' => true,
      ],
  

• Edit sql_mode in your mysql config file (my.ini or my.cnf) [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
  

• Restart your MySQL