lundi 7 novembre 2016

SQLSTATE[42000]: Syntax error or access violation: 1055 column isn't in GROUP BY

I have a query which works perfectly fine on mysql client and phpmyadmin, my query is :

select members.m_id, members.m_reach, members.m_member_num_groups, members.m_name, groups.tr_cat,
    groups.tr_id, group_categories.tc_id, group_categories.tc_name,group_members.tm_owner_id,
    group_members.tm_group_id from members join group_members on group_members.tm_owner_id = members.m_id
    join groups on groups.tr_id = group_members.tm_owner_id
    join group_categories on group.tr_cat = group_categories.tc_id
    group by members.m_id
    order by members.m_reach DESC limit 5

but when I try it with laravel DB::select I get error :

SQLSTATE[42000]: Syntax error or access violation: 1055 'muzikal.members.m_reach' isn't in GROUP BY 

I have seen many people asking the same question but couldn't get to a proper answer



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire