[#5301] Member Search Error

In CB/User Management, I have tried searching for a members of a particular ACL group (Administrators) and got this error:

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `w4s8u_comprofiler` AS a INNER JOIN `w4s8u_users` AS b ON b.`id` = a.`id` LEFT JOIN `w4s8u_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `w4s8u_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `w4s8u_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`w4s8u_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 7 )

In tools all database checks are ok.

Update to 2.0.9 where this is now fixed. It was caused by a change in our XML query parsing that broke join filters.

Loaded 2.0.9 and it allowed me to search, without results.

I then selected
Type - administrator
Confirmed
Enable

and got:

Unknown column 'a.block' in 'where clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `w4s8u_comprofiler` AS a INNER JOIN `w4s8u_users` AS b ON b.`id` = a.`id` LEFT JOIN `w4s8u_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `w4s8u_user_usergroup_map` AS d ON d.`user_id` = a.`id` LEFT JOIN `w4s8u_user_usergroup_map` AS e ON e.`user_id` = a.`id` WHERE ( e.`group_id` = 7 ) AND ( a.`block` = 0 ) AND ( a.`confirmed` = 1 )

Looks like there's a regression with the blocked filter. Same fix as before, logout to clear the filter then don't use that one (the enabled state filter). Have created a bug ticket to investigate and fix for next release.

forge.joomlapolis.com/issues/5301

Ok, found the cause. Quickfix is as follows.

IN: libraries/CBLib/CBLib/AhaWow/Model/XmlQuery.php
ON: Line 835
FROM: TO:

All done and looks good!

BTW, the forum email showed this:

IN: libraries/CBLib/CBLib/AhaWow/Model/XmlQuery.php
ON: Line 835
FROM:
if ( preg_match( '/[a-z]\./i', substr( $this->fieldsArray[$filterValuesArray], 0, 1 ) ) ) {
if ( preg_match( '/^[a-z]\./i', substr( $this->fieldsArray[$filterValuesArray], 0, 2 ) ) ) {


A little different to the post!!