LMSouq
database Open

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

SA
Saltern
1 month ago
3 views
Problem Description
when i got upgraded my ubuntu from 15.10 to 16.04 i have this erro in my yii2 project SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'iicityYii.opportunity_conditions.money' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by The SQL being executed was: SELECT SUM(oc.money),op.id,oc.money, op.mantaghe, op.`time`, op.`id`, `op`.`logo`, `pd`.`user_id`, `op`.`name`, `pd`.`co_name`, `op`.`address`, `op`.`project_type_id`, `op`.`state_id` FROM `opportunity` op INNER JOIN `profile_details` pd ON op.user_id=pd.user_id INNER JOIN `opportunity_conditions` oc ON op.id=oc.opportunity_id GROUP BY `op`.`id` ORDER BY `op`.`id` DESC how to solve my problem ?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base