Project

General

Profile

Actions

Bug #5301

closed

User management enabled filter not functional

Added by krileon almost 9 years ago. Updated almost 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 #1

Updated by krileon almost 9 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Fixed in MR !901

Actions #2

Updated by beat almost 9 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF