×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× This is not a support forum for JomSocial or its related products. For JomSocial support you should visit JomSocial .

The information given in this category is intended to guide users who want to use JomSocial with Kunena and, mostly, was written by Kunena users. The information here is not necessarily accurate, up-to-date nor is it intended to replace the support given by the developers of JomSocial.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Solved Reference Kunena_users avatar collum

More
4 years 10 months ago #1 by breebee2
Hey guys, i am trying to swap a comet chat avatar linked to jomsocial user avatar with the kunena users avatar and i cant seem to reference the actual collum correctly. This is the original and my manual attempt of the DB define that im trying to edit since which i have tried multiple combinations to switch to kunena, sorry for the burden. I will attach the php file just incase theres something there thats breaking( short file)
 
$config = new JConfig;
$secret = $config->secret;
 
 
 
define('DB_SERVER',		       'localhost'	    );
define('DB_PORT',              '3306'   	    );
define('DB_USERNAME',	       'username'	    );
define('DB_PASSWORD',	       'password'	    );
define('DB_NAME',   	       'lc' 	        );
define('TABLE_PREFIX',	       'jos_'           );
define('DB_USERTABLE',         'kunena_users'	);
define('DB_USERTABLE_NAME',	   'name'   	    );
define('DB_USERTABLE_USERID',  'kunena_users_userid');
define('DB_AVATARTABLE',       'kunena_users'      	);
define('DB_AVATARFIELD',       'kunena_users_avatar');
 
 
$config = new JConfig;
$secret = $config->secret;
 
// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW
 
define('DB_SERVER',				$config->host								);
define('DB_PORT',				'3306'										);
define('DB_USERNAME',				$config->user								);
define('DB_PASSWORD',				$config->password							);
define('DB_NAME',				$config->db									);
define('TABLE_PREFIX',				$config->dbprefix							);
define('DB_USERTABLE',				'users'										);
define('DB_USERTABLE_NAME',			'name'										);
define('DB_USERTABLE_USERID',                   'id'										);
define('DB_AVATARTABLE',                        " left join ".TABLE_PREFIX."community_users on ".TABLE_PREFIX."community_users.userid = ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID.""							);
define('DB_AVATARFIELD',                        " ".TABLE_PREFIX."community_users.thumb "	);
 
 
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #2 by breebee2
Ok so the answer was kunena_users.avatar , my problem was in the get user information function. Hope this helps anyone in the future :D

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.086 seconds