Project

General

Profile

Actions

Bug #5260

closed

User Management Search filtering for user groups gives SQL error

Added by nant over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
30 April 2015
Due date:
% Done:

100%

Estimated time:

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

Also available in: Atom PDF