laravel localhost xamp SQLSTATE[42000]: Syntax error or access violation: 1055 'saveapp.marketing_ad.id' isn't in GROUP BY

Error: laravel localhost xamp SQLSTATE[42000]: Syntax error or access violation: 1055 'your groupby field' isn't in GROUP BY

 

 

In config/database.php

Change 'strict' => true To 'strict' => false and clear the cache

php artisan config:cache
above command plays the main role to solving this error

OR In MySql settings change

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));