Hi.
I am facing difficulties with using groupjive. Hope someone could help me.
When I first install GJ members management tab in the backend works fine. But as soon as I add first category/group and go to members management I can see a list of users. And no users are in any group. Even the admin of my created groups!
To go further I try to add a user to a group manually. Then I receive an SQL error like(sorry can't reproduce the whole error as I am now getting another permanent mistake which doesn't afford me to work with members management at all):
| Code: |
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 2...
|
The 3rd and probably main problem is here:
When I try to filter any particular group in the members management I get this:
| Code: |
DB 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 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
|
There is no way to do something with that. So nothing else works in the members management tab.
I suppose you understand what these mistake lead to... Users can't join groups. Groups have no admin and no one has an access to the forum as far as they are not in groups(using GJ 1.8.5 beta and Kunena)
Hope very, very much that you can help me solve this!!!
BTW, the same question was created by a user of Community Builder forum and no one can help with that. Here is a
link
