Hi Everyone:
Today I suddenly started encountering an SQL Error message when accessing Community Builder 1.9.1 on my Joomla 2 website. At first, it started showing up when trying to delete a user, then it would be there at other times.
Now, after logging out and back in again a few hours later, it is not there. I'd really appreciate some help troubleshooting it and helping to resolve it. Below is the error message:
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 '' at line 7 SQL=SELECT COUNT(DISTINCT u.id) FROM iin_users AS u LEFT JOIN iin_comprofiler AS ue ON u.id = ue.id INNER JOIN iin_user_usergroup_map AS aro ON aro.user_id = u.id LEFT JOIN iin_user_usergroup_map AS arodisplay ON arodisplay.user_id = u.id INNER JOIN iin_usergroups AS g ON g.id = arodisplay.group_id WHERE aro.group_id = 0 ANDDB function failed with error number 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 u.id LIMIT 0, 20' at line 7 SQL=SELECT u.*, GROUP_CONCAT( DISTINCT g.title ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation FROM iin_users AS u LEFT JOIN iin_comprofiler AS ue ON u.id = ue.id INNER JOIN iin_user_usergroup_map AS aro ON aro.user_id = u.id LEFT JOIN iin_user_usergroup_map AS arodisplay ON arodisplay.user_id = u.id INNER JOIN iin_usergroups AS g ON g.id = arodisplay.group_id WHERE aro.group_id = 0 AND GROUP BY u.id LIMIT 0, 20
Howard
nant