a54552239/pearProject

项目管理-我的项目 报错

Closed this issue · 1 comments

Error Code | 10501

-- | --

Error Message | SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pearproject.pp.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Error SQL | select * from pear_project as pp join pear_project_member as pm on pm.project_code = pp.code where pp.organization_code = '7vwpiyz26fmdon451tq0xjeu' and (pm.member_code = '627s3cyojt4zfiwx1pu89hen' or pp.private = 0) group by pp.code order by pp.id desc

好吧,是mysql参数的问题