laravel 5.5 group by不起作用

Question

I'm trying to get some data but I just get this error

SQLSTATE[42000]: Syntax error or access violation: 1055 'ms_mascotas.ms_razas.id' isn't in GROUP BY (SQL: select ms_razas.id, ms_razas.nombre, ms_mascotas.raza_id, ms_mascotas.id from ms_mascotas inner join ms_razas on ms_razas.id = ms_mascotas.raza_id where ms_razas.tipo_animal_id = 1 group by ms_mascotas.raza_id)"

my query is this

$data=Mascota::select("ms_razas.id","ms_razas.nombre","ms_mascotas.raza_id","ms_mascotas.id")
       ->join("ms_razas","ms_razas.id","=","ms_mascotas.raza_id")
       ->where("ms_razas.tipo_animal_id",$id)
       ->groupBy("ms_mascotas.raza_id")
       ->get();

I've been reading about this error and it is related with the strict mode in the database file, strict is set to false by default, what should I do?

Answer 1

go to your config\database.php and change the setting the database that you use

'strict' => false