Index: trunk/admin/users/adduser_groups.php =================================================================== diff -u -r822 -r881 --- trunk/admin/users/adduser_groups.php (.../adduser_groups.php) (revision 822) +++ trunk/admin/users/adduser_groups.php (.../adduser_groups.php) (revision 881) @@ -243,7 +243,7 @@ if(strlen($orderBy)) $orderBy = " ORDER BY ".$orderBy; $sql = "SELECT g.GroupId as GroupId, g.name as GroupName, count(u.PortalUserId) as UserCount FROM ".GetTablePrefix()."PortalGroup as g "; -$sql .="INNER JOIN ".GetTablePrefix()."UserGroup as u ON g.GroupId=u.GroupId WHERE u.PortalUserId=".$c->Get("PortalUserId")." $where GROUP BY g.name".$orderBy; +$sql .="INNER JOIN ".$objSession->GetEditTable("UserGroup")." as u ON g.GroupId=u.GroupId WHERE u.PortalUserId=".$c->Get("PortalUserId")." $where GROUP BY g.name".$orderBy; if($objSession->HasSystemPermission("DEBUG.LIST")) echo htmlentities($sql,ENT_NOQUOTES)."
\n";