Project

General

Profile

Actions
Copy link

Bug #5382

closed

Admin User management advanced filtering with email and formatted name errors

Bug #5382: Admin User management advanced filtering with email and formatted name errors

Added by beat over 10 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
beat
Target version:
CB 2.0.11
Start date:
12 July 2015
Due date:
% Done:

100%

Estimated time:

Description

Error message is:

Unknown column 'a.email' in 'where clause' SQL =

SELEC_T COUNT FROM `jos_comprofiler` AS a INNER JOIN `jos_users` AS b ON b.`id` = a.`id` LEFT JOIN `jos_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `jos_user_usergroup_map` AS d ON d.`user_id` = a.`id` WHERE ( a.`email` LIKE '%test%' ) AND ( a.`formatname` LIKE '%9%' )

Actions
Copy link

Also available in: PDF Atom