with jomsocial 3.2.1.5, with joomls 3.2

if user edit profil and change something in account informationhe has this error when he save the profile.
If he change something in account information, and click on account détails before save the change, all is ok.


Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT `user_id`, GROUP_CONCAT( DISTINCT (if(`field_id`= 2, `value`, NULL))) AS field_id_2, GROUP_CONCAT( DISTINCT (if(`field_id`= 16, `value`, NULL))) AS field_id_16, GROUP_CONCAT( DISTINCT (if(`field_id`= 3, `value`, NULL))) AS field_id_3, GROUP_CONCAT( DISTINCT (if(`field_id`= 10, `value`, NULL))) AS field_id_10, GROUP_CONCAT( DISTINCT (if(`field_id`= 9, `value`, NULL))) AS field_id_9, GROUP_CONCAT( DISTINCT (if(`field_id`= 11, `value`, NULL))) AS field_id_11 FROM `i13fc_community_fields_values` WHERE `user_id`= 650

Thanks

Hi, Sarl.

I assign developer to this thread.

Thanks a lot.

Hi Sarl,

the problem with XIUS System Plugin it self. please disable it and contact that plugin provider for the fix.

Regards,
Albert

You are thrue, when plugin is off, all is ok. Thanks for the help..