If I select to search for all users in a group in the CB Backend useradministration, I see this message:
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `xxx_comprofiler` AS a INNER JOIN `xxx_users` AS b ON b.`id` = a.`id` LEFT JOIN `xxx_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `xxx_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `xxx_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`xxx_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 11 )
CB 2.0.8
J 3.4.1
Best regards
Fribse
Frømandsklubben Nikon,
www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
fribse2011 wrote: If I select to search for all users in a group in the CB Backend useradministration, I see this message:
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `xxx_comprofiler` AS a INNER JOIN `xxx_users` AS b ON b.`id` = a.`id` LEFT JOIN `xxx_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `xxx_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `xxx_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`xxx_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 11 )
nant