atal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column

atal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column

There are many ways to fix this

Quickest way just run this

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

Secod Solution

just go to

config/database.php make sure to set strict => true to strict => false for the mysql settings. 

Third solution is in the video below

If it worked for you please share on Facebook and also leave a comment below.