Moderator
krileon
Team Member- OFFLINE
- Posts: 68515
- Thanks: 9087
- Karma: 1434
12 years 7 months ago - 12 years 7 months ago #177429
by krileon
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.
Replied by krileon on topic Re: Moderator
Then the fix wasn't applied properly. There is only 1 place the query is actually made all through GJ 2.4 RC2 for that table and that's it. The error was happening because the fake "order" was being added to the object, which doesn't actually exist in database and on store actions it was trying to add it. This is fixed with next release however.
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.
Last edit: 12 years 7 months ago by krileon.
Please Log in to join the conversation.
- letube
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
12 years 7 months ago #177438
by letube
Replied by letube on topic Re: Moderator
Can you attach the new file that works?
Regards
Regards
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68515
- Thanks: 9087
- Karma: 1434
12 years 7 months ago - 12 years 6 months ago #177459
by krileon
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.
Replied by krileon on topic Re: Moderator
Unfortunately I can't attached any said files as is subscriber accessible content and these forums are public. Below is the exact change according to the GJ 2.4 RC2 released in professional downloads section.
IN: components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php
ON: Lines 147-150
FROMTO
Please do let me know if you've any further issues with the above applied.
IN: components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php
ON: Lines 147-150
FROM
$query = 'SELECT *'
. ', ( CASE WHEN ( ' . $_CB_database->NameQuote( 'status' ) . ' = 0 ) THEN 1 WHEN ( ' . $_CB_database->NameQuote( 'status' ) . ' >= 1 ) THEN 2 ELSE 3 END ) AS ' . $_CB_database->Quote( 'order' )
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' )
. "\n ORDER BY " . $_CB_database->NameQuote( 'order' ) . " ASC, " . $_CB_database->NameQuote( 'status' ) . " DESC, " . $_CB_database->NameQuote( 'date' ) . " DESC"; $query = 'SELECT *'
. "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' )
. "\n ORDER BY ( CASE WHEN ( " . $_CB_database->NameQuote( 'status' ) . " = 0 ) THEN 1 WHEN ( " . $_CB_database->NameQuote( 'status' ) . " >= 1 ) THEN 2 ELSE 3 END ) ASC, " . $_CB_database->NameQuote( 'status' ) . " DESC, " . $_CB_database->NameQuote( 'date' ) . " DESC";Please do let me know if you've any further issues with the above applied.
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.
Last edit: 12 years 6 months ago by krileon.
Please Log in to join the conversation.
- letube
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
12 years 7 months ago #177469
by letube
Replied by letube on topic Re: Moderator
Many thanks. I have applied it and now I get:
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfil the request.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfil the request.
Please Log in to join the conversation.
- lincolnsuncity
- OFFLINE
-
New Member
- Posts: 13
- Thanks: 0
- Karma: 1
12 years 7 months ago #177474
by lincolnsuncity
Replied by lincolnsuncity on topic Re: Moderator
I also saw this issue and have applied the change you suggested.
I no longer see users in the GroupJive->Users Administrator interface and I also see no users in the Users tab in the frontend for a group.
Although there may be other unintended consequences, it works if I put:
$query = 'SELECT *' . "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' );
I no longer see users in the GroupJive->Users Administrator interface and I also see no users in the Users tab in the frontend for a group.
Although there may be other unintended consequences, it works if I put:
$query = 'SELECT *' . "\n FROM " . $_CB_database->NameQuote( '#__groupjive_users' );
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68515
- Thanks: 9087
- Karma: 1434
12 years 6 months ago - 12 years 6 months ago #177638
by krileon
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.
Replied by krileon on topic Re: Moderator
There was an error in the "TO" code. I've fixed it, please re-read my previous reply. Without the correct ordering code the users will not display in their correct order.
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.
Last edit: 12 years 6 months ago by krileon.
The following user(s) said Thank You: jojo12
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.280 seconds
