I just upgraded to the new Jomsocial and I have a major issue on my production site that I have to have fixed ASAP.

This is the entire error that I am getting and I know it has to do with non of the users are actually showing in the tables in myadminphp. I need help fixing this ASAP.

Error: 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 'GROUP BY `groupid`' at line 1 SQL=SELECT `groupid` FROM `x8l96_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`

Please can some one assist me quickly as this is time sensitive as this is our production site. Thanks in advance.
The drop down below only has one domain and would not let me change it when i upgraded so please look to the Test/Development Site Information (Optional) for the correct site as it would not let me change the domain when i upgraded.

Hi Jason.

which page got that error message? because i check your site according Test/Development Site Info detail. I can't find that error at frontend and backend. please try to clear your browser cache and joomla cache first. and let see you still get that error or not. if still,
please provide me screenshot and page URL for that error. and provide me cpanel/database manager access for me.

Regards,
Albert

Hi Jason,

We have not received any response back from you in over 7 days, and would like to know if you consider this issue to be resolved. If you have any further questions, simply reply to this post.

Regards,
Albert