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