SQL Error Message

9 years 8 months ago #246546 by freedomcoach
SQL Error Message was created by freedomcoach
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

Please Log in to join the conversation.

9 years 8 months ago #246553 by nant
Replied by nant on topic SQL Error Message

freedomcoach wrote: 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.


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.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.168 seconds

Facebook Twitter LinkedIn