Moderator

12 years 2 months ago - 12 years 2 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'

Please Log in to join the conversation.

12 years 2 months ago #176899 by krileon
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
			$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.

12 years 2 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

Please Log in to join the conversation.

12 years 2 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'

Please Log in to join the conversation.

12 years 2 months ago #177160 by krileon
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.

12 years 2 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'

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.480 seconds

Facebook Twitter LinkedIn