BlastChat - free chat for your website

Latest News

	BlastChat	Forum Threaded View Rules Help

Welcome, Guest
Please Login or Register. Lost Password?

BlastChat

BlastChat client 2.3 module

Joomla! 1.0.x, Joomla! 1.5.x legacy, Mambo 4.5.x, Mambo 4.6.x

Re:Errors in front- and backend (1 viewing) (1) Guest

Favoured: 0

TOPIC: Re:Errors in front- and backend

Forum Tools

#4299

Jermit (User)

Fresh Boarder

Posts: 3

Errors in front- and backend 4 Months, 3 Weeks ago Karma: 0

I'm getting the following errors on the frontend:

Code:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'jermit.nl'@'srv93.one.com' (using password: NO) in /customers/jermit.nl/jermit.nl/httpd.www/beta/components/com_blastchatc/module.blastchatc.php on line 73

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /customers/jermit.nl/jermit.nl/httpd.www/beta/components/com_blastchatc/module.blastchatc.php on line 73

And these in the backend:

Code:

DB function failed with error number 1054
Unknown column 'g.group_id' in 'on clause' SQL=SELECT a.*, g.name AS groupname , bcu.sec_code AS bc_sec_code , bcu.logged AS bc_logged , bcu.last_entry AS bc_last_entry , bcu.last_update AS bc_last_update , bcu.idle AS bc_idle , bcu.roomid AS bc_roomid , bcu.roomname AS bc_roomname FROM jos_users AS a INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = a.gid LEFT JOIN jos_blastchatc_users AS bcu ON bcu.userid = a.id WHERE bcu.serverid = 1 GROUP BY a.id LIMIT 0, 1

How can I fix this?

Report to moderator Logged

Logged

The administrator has disabled public write access.

#4300

Prutkar (Admin)

Admin

Posts: 1772

Re:Errors in front- and backend 4 Months, 3 Weeks ago

Karma: 49

frontend error: Look slike your connection to database has problems, contact your hosting company and check your mysql connection for user 'jermit.nl'@'srv93.one.com' (using password: NO). You can always turn off "Warnings" in your php.ini file if you have access to it.

backend error: Which version of Joomla are you using? (jos_core_acl_aro_groups should contain group_id field) If 1.5 are you running in legacy mode?

Report to moderator Logged

Logged

Peter Saitz
www.blastchat.com

The administrator has disabled public write access.

#4305

Jermit (User)

Fresh Boarder

Posts: 3

Re:Errors in front- and backend 4 Months, 3 Weeks ago	Karma: 0
The frontend error has dissapeared somehow. About the backend error, I'm using Joomla 1.5.3 in Legacy mode. With PHP 5.2.6 and MySQL 5.0.32 installed. I also have a lot of extensions, are there any known errors with other extensions?

Report to moderator Logged

Logged

The administrator has disabled public write access.

#4306

Prutkar (Admin)

Admin

Posts: 1772

Re:Errors in front- and backend 4 Months, 3 Weeks ago	Karma: 49
Did you try to contact Joomla developers and ask about 1.5.3 in legacy mode and missing 'group_id' in 'jos_core_acl_aro_groups' table? Where exactly in backend are you getting this error? We do not have time to track errors of other extensions.

Report to moderator Logged

Logged

Peter Saitz
www.blastchat.com

The administrator has disabled public write access.

#4307

Prutkar (Admin)

Admin

Posts: 1772

Re:Errors in front- and backend 4 Months, 3 Weeks ago Karma: 49

Go to administrator/components/com_blastchatc and open file users.php for editing, find lines 109-113

Code:

	if (!$bc_legacy) {
		$query .= "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = a.gid";
	} else {
		$query .= "\n INNER JOIN #__core_acl_aro_groups AS g ON g.id = a.gid";
	}

and replace it with

Code:

$query .= "\n INNER JOIN #__core_acl_aro_groups AS g ON g.id = a.gid";

Report to moderator Logged

Logged

Last Edit: 2008/06/28 11:24 By Prutkar.

Peter Saitz
www.blastchat.com

The administrator has disabled public write access.