Moderator
- MeRLiNMC
- OFFLINE
-
New Member
- Posts: 8
- Thanks: 0
- Karma: 0
12 years 7 months ago - 12 years 7 months ago #176754
by MeRLiNMC
Moderator was created by MeRLiNMC
In the case i make a Groupmember to a moderator i get a error message:
User-Status konnte nicht gespeichert werden! Fehler: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `jos_groupjive_users` SET `user_id`='115',`group`='3',`date`='2011-05-04 20:30:16',`status`=2,`order`='2' WHERE id='14'
User-Status konnte nicht gespeichert werden! Fehler: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `jos_groupjive_users` SET `user_id`='115',`group`='3',`date`='2011-05-04 20:30:16',`status`=2,`order`='2' WHERE id='14'
Last edit: 12 years 7 months ago by MeRLiNMC.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68482
- Thanks: 9076
- Karma: 1434
12 years 6 months ago #176899
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
Known issue, resolved for stable release. Quick fix as follows.
IN: components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php
ON: Lines 147-149
IN: components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php
ON: Lines 147-149
$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";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.
- letube
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
12 years 6 months ago #176925
by letube
Replied by letube on topic Re: Moderator
Many thanks for the fix.
I have the same problem but I can't seem to find the line numbers and it is not clear whether one should insert the the three lines or replace existing code.
Can you provide further guidance please?
Regards
I have the same problem but I can't seem to find the line numbers and it is not clear whether one should insert the the three lines or replace existing code.
Can you provide further guidance please?
Regards
Please Log in to join the conversation.
- letube
- OFFLINE
-
New Member
- Posts: 4
- Thanks: 0
- Karma: 0
12 years 6 months ago #177043
by letube
Replied by letube on topic Re: Moderator
Did you get a chance to look at this to provide further clarification please?
I am still getting the following error below at backend when I try to promote a group member to admin or owner:
User status failed to save! Error: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `jos_groupjive_users` SET `user_id`='133',`group`='2',`date`='2011-09-20 18:15:10',`status`=4,`order`='2' WHERE id='3'
I am still getting the following error below at backend when I try to promote a group member to admin or owner:
User status failed to save! Error: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `jos_groupjive_users` SET `user_id`='133',`group`='2',`date`='2011-09-20 18:15:10',`status`=4,`order`='2' WHERE id='3'
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68482
- Thanks: 9076
- Karma: 1434
12 years 6 months ago #177160
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
The above is the fix for GJ 2.4, there's no other place to edit or implement the fix. Location, code lines, and what code is already provided in my previous reply. Code lines may different as am running on a developer version.
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.
The following user(s) said Thank You: Dorkyme
Please Log in to join the conversation.
- jojo12
- OFFLINE
-
Platinum Member
- Posts: 1125
- Thanks: 132
- Karma: 25
12 years 6 months ago #177400
by jojo12
Replied by jojo12 on topic Re: Moderator
[joomla 1.7, cb1.7 gj 2.4RC2]
did not work for me, error:
user status failed to saved! Error: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `nre95_groupjive_users` SET `user_id`='52',`group`='3',`date`='2011-09-23 14:34:02',`status`=2,`order`='2' WHERE id='159'
did not work for me, error:
user status failed to saved! Error: cbgjuser::store failed: Unknown column 'order' in 'field list' SQL=UPDATE `nre95_groupjive_users` SET `user_id`='52',`group`='3',`date`='2011-09-23 14:34:02',`status`=2,`order`='2' WHERE id='159'
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.323 seconds
