Project

General

Profile

Actions

Bug #5301

closed

User management enabled filter not functional

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

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
29 May 2015
Due date:
% Done:

100%

Estimated time:

Description

When filtering by blocked it does not function and outputs the following SQL error.

Unknown column 'a.block' in 'where clause' SQL=SELECT COUNT( DISTINCT a.`id` ) 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.`block` = 1 )

https://www.joomlapolis.com/forum/255-developer-members-support/229916-member-search-error

Actions

Also available in: Atom PDF