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 #1

Updated by krileon over 9 years ago

This broke due to MR !855 parsing the joins before parsing <where

Actions #2

Updated by krileon over 9 years ago

  • Status changed from New to Feedback
  • Assignee changed from krileon to beat

Reverted !855 in MR !867

Actions #3

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 #4

Updated by beat over 9 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF