here is the message i get with the debug mode :

500 - Une erreur est survenue

JDatabaseMySQL::query: 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 '(g.id SEPARATOR ' ') AS groupids FROM jos_users AS b LEFT JOIN 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 (62,63,64) GROUP BY b.id

Call stack
# Function Location
1 JAdministrator->dispatch() ../www/administrator/index.php:67
2 JComponentHelper->renderComponent() ../www/administrator/includes/application.php:136
3 require_once() ../www/libraries/joomla/application/component/helper.php:162
4 membersManager() ../www/administrator/components/com_groupjive/admin.groupjive.php:126
5 CBdatabase->loadObjectList() ../www/administrator/components/com_groupjive/admin.groupjive.php:821
6 CBdatabase->query() ../www/administrator/components/com_comprofiler/library/cb/cb.database.php:838
7 JDatabaseMySQL->query() ../www/administrator/components/com_comprofiler/library/cb/cb.database.php:673
8 JError->raiseError() ../www/libraries/joomla/database/database/mysql.php:231
9 JError->raise() ../www/libraries/joomla/error/error.php:171
10 JException->__construct() ../www/libraries/joomla/error/error.php:136

it seems that the problem would be it's better to indicate directly columns we need, instead of using SELECT b.*

$query = "SELECT b.*,
...
GROUP BY B.Id ;

if somebody knows the correct programmation, ...

i'm afraid i'm going to look impertinent, but i tried

In: admin.groupjive.php
On: 815
From:
."\nWHERE b.id IN ($tmp)"
To:
."\nWHERE b.id IN (".($tmp?$tmp:0).")"

so what ?
i've always

DB function failed with error number 1064
You have an error in your SQL syntax.etc...

i have had the information it would be better to replace

SELECT B.*
...
GROUP BY B.Id

by the columns needed themselves;
what would it be then ?

as i was fed up (i hope it's not too rude !) with this, i tried many stupid things;
the last one was

$query = "SELECT b.* AS groupids"
."\nFROM #__users AS b "
."\nLEFT JOIN #__gj_users AS u ON u.id_user = b.id"
."\nLEFT JOIN #__gj_groups AS g ON u.id_group = g.id"
."\nWHERE b.id IN (".($tmp?$tmp:0).")"
. $and
."\nGROUP BY b.id" ;

(no more GROUP_CONCAT)
AND I GET MY MEMBERS LIST, YEEEEES !

Post edited by: corbin1, at: 2009/11/06 13:39