Help
Ask questions about how to do or fix things in Arrowchat
User avatar
SSchumacher
Customer
 
Posts: 4
Joined: 12 Dec 2011, 14:37

 

by SSchumacher 12 Dec 2011, 19:02

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.
User avatar
Jason
Customer
 
Posts: 2356
Joined: 12 Dec 2009, 16:06

 

by Jason 12 Dec 2011, 21:07

Are you sure the prefix is j17_ and not jos_
User avatar
SSchumacher
Customer
 
Posts: 4
Joined: 12 Dec 2011, 14:37

 

by SSchumacher 12 Dec 2011, 22:22

absolutely certain
User avatar
SSchumacher
Customer
 
Posts: 4
Joined: 12 Dec 2011, 14:37

 

by SSchumacher 13 Dec 2011, 00:43

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.
User avatar
SSchumacher
Customer
 
Posts: 4
Joined: 12 Dec 2011, 14:37

 

by SSchumacher 13 Dec 2011, 02:13

It's working finally. Had to alter the SQL query. Thanks.
User avatar
Staff Bot
ArrowChat Team
 
Posts: 8996
Joined: 07 Nov 2012, 13:41

 

by Staff Bot 07 Nov 2012, 12:40

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.