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
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.
Well code doesn't suddenly change so something has been added to your environment that must be causing this.
Try disabling all third party CB plugins you have installed.
nant