I've installed groupjive and when I click on members manager, I get this error:

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 b.id' at line 5 SQL=SELECT b.*, GROUP_CONCAT(g.id SEPARATOR ' ') AS groupids FROM jos_users AS b LEFT JOIN jos_gj_users AS u ON u.id_user = b.id LEFT JOIN jos_gj_groups AS g ON u.id_group = g.id WHERE b.id IN () GROUP BY b.id


Anyone know a fix for this?

If you can't find the error with a search of the forums or existing issues in the forge, make sure you've installed it correctly (including publishing the plugin). If you still have issues, give more information, like Joomla, CB, GJ and PHP versions.