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 )
Updated by krileon over 9 years ago
This broke due to MR !855 parsing the joins before parsing <where
Updated by krileon over 9 years ago
- Status changed from New to Feedback
- Assignee changed from krileon to beat
Reverted !855 in MR !867
Updated by beat over 9 years ago
- Status changed from Feedback to Resolved
- Assignee changed from beat to krileon
- % Done changed from 0 to 100
Fixed in MR !867 by Kyle. Thanks!
Actions