Skip to content

Instantly share code, notes, and snippets.

@jsonzilla
Last active March 4, 2024 19:23
Show Gist options
  • Save jsonzilla/b37da2b47a8178320574992f31974262 to your computer and use it in GitHub Desktop.
Save jsonzilla/b37da2b47a8178320574992f31974262 to your computer and use it in GitHub Desktop.
fix for group by error in crashfix webservice

Group by error

If crashfix webserver show the error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crashfix.b.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Execute the query below:

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment