Page 1 of 1

can't get users to show

PostPosted: 12 Dec 2011, 19:02
by SSchumacher
Hey all,

I've installed arrowchat on a Joomla 1.7/Jomsocial 2.4 base and the chat bar isn't showing any users. In the debug file I get,

User ID: 62
You are being registered as logged in. If you are not logged in, please check the functions_receive.php file to make sure the getUserID function is correct.

There was an error with your getFriendsList function. Please check your includes/functions_receive.php file and fix your getFriendsList function so that it is receiveing your online friends correctly. mySQL Error:

User ID is not banned.

You are using an ArrowChat compatible browser.

You have a functions_receive.php file.


My config file is set as such:
Code: Select all
<?php 
define('_JEXEC',1);
define('DS',DIRECTORY_SEPARATOR);
define('JPATH_BASE',dirname(dirname(__FILE__)));
require_once dirname(dirname(__FILE__)).'/includes/defines.php';
require_once dirname(dirname(__FILE__)).'/includes/framework.php';
$mainframe =& JFactory::getApplication('site');
$mainframe->initialise();
define('DB_SERVER','localhost');
define('DB_PORT','3306');
define('DB_NAME','yfsd_joomla');
define('TABLE_PREFIX','j17_');
define('DB_USERTABLE','users');
define('DB_USERTABLE_NAME','name');
define('DB_USERTABLE_USERID','id');
define('DB_USERTABLE_AVATAR','id');
define('DB_FRIENDSTABLE','community_connection');
define('DB_FRIENDSTABLE_USERID', 'connect_from');
define('DB_FRIENDSTABLE_FRIENDID', 'connect_to');
define('DB_FRIENDSTABLE_FRIENDS', 'status');
include_once dirname(__FILE__).'/version.php';

$dbh = mysql_connect(DB_SERVER.':'.DB_PORT,DB_USERNAME,DB_PASSWORD);
if (!$dbh) {
   echo "<h3>Unable to connect to database. Please check details in configuration file.</h3>";
   exit();
}
mysql_selectdb(DB_NAME,$dbh);
mysql_query("SET NAMES utf8");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_general_ci'");

?>

I omitted the username and password, but rest assured they are correct.

Any ideas on how to fix this?

Seth Schumacher
Dionysius Technologies LLC.

PostPosted: 12 Dec 2011, 21:07
by Jason
Are you sure the prefix is j17_ and not jos_

PostPosted: 12 Dec 2011, 22:22
by SSchumacher
absolutely certain

PostPosted: 13 Dec 2011, 00:43
by SSchumacher
So by returning the avatar field in config to the default (thumb), the error in debug disappears. I'm still not able to see other online users, even when logged in as admin with see all online enabled.

PostPosted: 13 Dec 2011, 02:13
by SSchumacher
It's working finally. Had to alter the SQL query. Thanks.

Topic Closed

PostPosted: 07 Nov 2012, 12:40
by Staff Bot
This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.