Laravel GROUP BY clause and contains nonaggregated column



ERROR ::
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #54 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mp_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.
SOLUTION :: Change the file
 config/database.php 
:: here is the code::
'mysql' => [        
    'strict' => false, //behave like 5.6        
   //'strict' => true //behave like 5.7    ],
Selim Reza

Site Footer