[#5260] BIG BUG !!??

8 years 10 months ago - 8 years 10 months ago #263404 by rbuelund
[#5260] BIG BUG !!?? was created by rbuelund
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 )

Please Log in to join the conversation.

8 years 10 months ago #263406 by nant
Replied by nant on topic BIG BUG !!??

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!

Please Log in to join the conversation.

8 years 10 months ago #263430 by rbuelund
Replied by rbuelund on topic BIG BUG !!??
When is the 2.0.9 release due? - I really need this fixed..

Please Log in to join the conversation.

8 years 10 months ago #263458 by krileon
Replied by krileon on topic BIG BUG !!??
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.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

8 years 10 months ago - 8 years 10 months ago #263474 by RFrazier
Replied by RFrazier on topic BIG BUG !!??
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

Please Log in to join the conversation.

8 years 10 months ago #263477 by nant
Replied by nant on topic BIG BUG !!??

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.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.255 seconds