robert.keir 7 Posted June 15 Report Share Posted June 15 After updating a lead we get this error. Anyone know what this is about? Error Code: 500Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myagcovr_x2343.x2_actions.complete' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byStack Trace: [click to toggle display]X2Engine Version: 7.1PHP Version: 7.3.33 Quote Link to post Share on other sites
jack 30 Posted June 17 Report Share Posted June 17 Hi Robert, Can you tell me what version of mysql you are running. Can you also click the stack trace and post the full thing. -Jack Quote Link to post Share on other sites
robert.keir 7 Posted July 5 Author Report Share Posted July 5 Hi Jack. Please see below the stack and our MySQL Version is 5.7.38. What do you think the problem could be? Quote Link to post Share on other sites
robert.keir 7 Posted July 15 Author Report Share Posted July 15 Does anyone have any idea what the problem could be? Maybe the mysql version? Quote Link to post Share on other sites
jack 30 Posted July 19 Report Share Posted July 19 Hi Robert, I think this is an issue with your sql not allowing stuff in the select clause if it is not in the group by clause. I would recommend taking a backup of your database and trying to change the "sql_mode" It is solution 2 from this page https://www.percona.com/blog/2019/05/13/solve-query-failures-regarding-only_full_group_by-sql-mode/ -Jack Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.