Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
In some cases I see the error "SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause" when creating the summary rows in a table. This is because we need to add a groupby clause when we add the aggregation fields.
Comments
Comment #1
wsadowicz CreditAttribution: wsadowicz commentedI'm having the same on 7.x-1.0 version. it makes this module unusable :(
Comment #2
dustinrwh CreditAttribution: dustinrwh commentedYou may want to try turning on aggregation within Views. This gets rid of the error for me. It isn't calculating correctly but at least the error is gone :)
Comment #3
pyvarlet CreditAttribution: pyvarlet commentedPlease dustinrwh
Can you explain how you turn aggregation on.
I've been told the problem is solved also by turning off the MySQL mode "ONLY_FULL_GROUP_BY".
How can we do that (if it is a proper solution.
I got this error (in views using view_calc) after I transpoted my Drupal 7 site from test/development equipment to the production one. And it's still working properly on the test system.
Thanks in advance.
Pierre
Comment #4
fb-multimedia+1 looking for a solution cause views calc is unusable with the MySQL mode "ONLY_FULL_GROUP_BY".
It's seem the problem is in the mysql request of the module...please help.
Comment #5
webcube CreditAttribution: webcube commentedThis is what I did to show the total of similar types of fields
Hope this helps someone.
Comment #6
windsochi CreditAttribution: windsochi commentedHello.
I too got this error (in views using view_calc) after I transpoted my Drupal 7 site from test/development equipment to the production one. And it's still working properly on the test system. Thanks in advance.
Please need help!