Hello dears,
I get the following error:
[2019-05-31 20:50:11] [SQLSTATE=42000] Err 1055: Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rathena.cp_itemshop.cost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
I have read that this error is common in mysql 5.7. Everything else works but I need mysql 5.7 for other projects, so I can't change the version. Is the problem solvable? Can anyone help me?
Question
Pusteblume
Hello dears,
I get the following error:
[2019-05-31 20:50:11] [SQLSTATE=42000] Err 1055: Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rathena.cp_itemshop.cost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
I have read that this error is common in mysql 5.7. Everything else works but I need mysql 5.7 for other projects, so I can't change the version. Is the problem solvable? Can anyone help me?
Link to comment
Share on other sites
4 answers to this question
Recommended Posts