Question 20912 in Mysql Question posted in
The official MySQL documentation can be found here.

list is not in GROUP BY clause and contains nonaggregated column in X2CRM – Mysql

I have created a custom module in X2CRM. Then, I created a new record in that module and logged time using the Log Time widget. Ultimately, when I retrieve the same record by clicking on that record name from the All records view, it throws the following error:

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 ‘x2_db.x2_actions.complete’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I have seen similar issue with other frameworks on Google, but this one is the builtin code generator module (which I created from the Admin area). So, those solution do not work for this CRM.

I have reviewed the logs but found nothing there.

Update:

I have found in the stack trace that the call to this SQL is being sent from the following line in source code:

ActionHistoryChartWidget::getChartData(‘1675792337’, 1675967470, ‘8’, ‘tasks’, NULL)

Tags:

2

Answers


  1. 0

    Apparently, this is related to MySQL where the Group BY clause is not corresponding to the data in SELECT clause. So, you will need to synchronize the select data and the remaining items in the query.

    As a quick workaround, as I can see that the

    getChartData()

    function is causing the issue, you can open another record view from the same module and disable the Charts widget.
    You can do this first by hiding the Charts Widget.
    If that does not work, then you can simply delete this widget from the detail view page (for now). You can do so by clicking on X icon for that widget.

    Then, you CRM will start to work!

    Login or Signup to reply.
  2. 0

    This issue is related to MySql Group By.
    Below mentioned query will hopefully resolve your problem.

    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search