[#5260] BIG BUG !!??

After update from 2.0.7 to 2.0.8 i get this error when filtering on a usergroup in backend - please help!

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `nj1234_comprofiler` AS a INNER JOIN `nj1234_users` AS b ON b.`id` = a.`id` LEFT JOIN `nj1234_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `nj1234_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `nj1234_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`nj1234_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 16 )

rbuelund wrote: After update from 2.0.7 to 2.0.8 i get this error when filtering on a usergroup in backend - please help!

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `nj1234_comprofiler` AS a INNER JOIN `nj1234_users` AS b ON b.`id` = a.`id` LEFT JOIN `nj1234_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `nj1234_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `nj1234_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`nj1234_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 16 )

Was able to replicate - opened ticket:

forge.joomlapolis.com/issues/5260

Thanks for reporting!

When is the 2.0.9 release due? - I really need this fixed..

Not for awhile, but once fixed you'll be able to grab the nightly for the fix. Once I'm done clearing support topics I'll look into why it broke.

I am waiting for the fix as well. I cant access my User Management area now...is there a way to access the user management area before the fix is released? I am locked out all together. i have 2.0.8 also..thanks

RFrazier wrote: I am waiting for the fix as well. I cant access my User Management area now...is there a way to access the user management area before the fix is released? I am locked out all together. i have 2.0.8 also..thanks

This bug just keeps you from searching for users in a specific user group.

It does not stop you from using the CB User Manager.

If you have a different issue please start different thread.