Actions
Bug #5260
closedUser Management Search filtering for user groups gives SQL error
Description
As reported here:
I was able to replicate on a CB 2.0.8 site trying to search in User Management for Superadmins.
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT FROM `wpdgf_comprofiler` AS a INNER JOIN `wpdgf_users` AS b ON b.`id` = a.`id` LEFT JOIN `wpdgf_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `wpdgf_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `wpdgf_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`wpdgf_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 8 )
Actions