I have a view for Organic Group (og) that displays a list of the groups, a picture, the language, the categories the groups fall into, and a summary of the mission statement. All of this is neatly organized in a grid.

I want to add a membership count for each group in the view. As soon as I turn aggregation on, I get the following error message:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS node_og_field_data_field_group_image_, node_og.title AS node_og_title, node_' at line 1

Does anyone know what's going on and how to fix it?

closed as off-topic by Mołot, Bala, AjitS, Free Radical, 4life Mar 17 '14 at 15:30

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers." – Mołot, Bala, AjitS, Free Radical, 4life
If this question can be reworded to fit the rules in the help center, please edit the question.


I finally found the answer for this. My view had a group picture; removing the group picture, turning the aggregation on, and putting back the group picture field solved the problem.

It's a problem others have had and that's how they all fixed it; See https://drupal.org/node/1809584.

Not the answer you're looking for? Browse other questions tagged or ask your own question.