Clearchat problems - Please Help!

Posted: Thu Feb 05, 2004 10:19 pm

I just installed Clearchat, but something went wrong with it so I deleted the modules/clearchat folder and replaced it. Now I have two clearchat links in the administration block and I get an two or three error messages, which I had from the first install, that I can't see to obliviate.

This error appears where the smilies and input field should be:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site35/fst/var/www/html/modules/ClearChat/block-files/input.php on line 45

This error is in the text box where messages are displayed:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site35/fst/var/www/html/modules/ClearChat/block-files/view.php on line 22

Can anyone possibly assist me in this problem?

Nuke Cadet Joined: Mar 02, 2004 Posts: 6

What version of phpnuke are you using? I am running this fine on cpgnuke8.01, however the sql calls need to be udpated to use the new sql abstraction ($db->) I have not much of a programmer so I have not figured out how to update the code. (anyone want to take a shot at this, or at least give me a hint where to start?)

Your error could be your version of nuke, or your version of mysql.

Sergeant Joined: Feb 28, 2005 Posts: 140

Wow, this post is old but I thought I'd enter here rather then starting a new one.

Had clearchat working fine at old host (mysql 3.23.5 Cool

but I moved to a new host. All works well cept clearchat which in itself seems fine in all respects cept it's not writing to the new mysql 5.1.2

To be more specific, there are no errors. Everything with it seems fine. But when you type in some chat and hit post, it does not post nor get entered into the nuke_clearchat table. Nothing shows up in the nuke_errors table either.

I'm thinking I need to rewrite something in the script for it to work with mysql 5???

Code:

<?php

$timedate = date("l F dS, Y - g:i a");
$useraddress = $_SERVER['REMOTE_ADDR'];
require "../common/config.php";

if (isset($submit))
{

$db = mysql_connect("$dbaddress", "$dbuser", "$dbpass");

mysql_select_db("$dbname",$db);
$checker = mysql_query("SELECT user_password FROM nuke_users WHERE username = '$username'");
while ($disp = mysql_fetch_array($checker))
{
$realuserpw = $disp["user_password"];
}

if (($userpw == $realuserpw) && ($userpw != "")) {
include "../common/checks.php";

mysql_select_db("$dbname",$db);
$sql = "INSERT INTO nuke_clearchat (username, useravatar, comment, useraddress, date) VALUES ('$username','$useravatar','$comment','$useraddress','$timedate')";
$result = mysql_query($sql);

} else {

//Inserts error data
$userinfo = $_SERVER['HTTP_USER_AGENT'];
$errornumber = "1: Docked";
mysql_select_db("$dbname",$db);
$sql = "INSERT INTO nuke_ccerror (username, userpw, realuserpw, errornumber, useraddress, userinfo, date, comment, useravatar) VALUES ('$username', '$userpw', '$realuserpw', '$errornumber', '$useraddress', '$userinfo', '$timedate', '$comment', '$user_avatar')";
$result = mysql_query($sql);

$error = "true";
}
}

$db = mysql_connect("$dbaddress", "$dbuser", "$dbpass");

mysql_select_db("$dbname",$db);
$checker = mysql_query("SELECT user_password FROM nuke_users WHERE username = '$username'");
while ($disp = mysql_fetch_array($checker))
{
$userpw = $disp["user_password"];
}
<?php

Sergeant Joined: Feb 28, 2005 Posts: 140

Anyone?

Nuke Cadet Joined: Mar 06, 2007 Posts: 1

I'm having exactly the same problem as 552211

The chatbox is on the site and everything, but when I type anything into it, it fails to show up in the window.

Posted: Tue Mar 06, 2007 9:13 am

552211 wrote:

Anyone?

Pumpkin_Masher wrote:

I'm having exactly the same problem as 552211

The chatbox is on the site and everything, but when I type anything into it, it fails to show up in the window.

Since you are using PhP Nuke Platinum and not PHP-Nuke , I would suggest going to http://www.futurenuke.com since they are the developers of this moded version.

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

Exactly same problem here all seems ok but cannot log in as admin or type messages. some help would be great. BTW I am using phpnuke 7.8, and it worked fine on my old server

Thanks in advance

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

follow up to this thread. I finally got this working (with a little help from my friends). Then about a week ago I noticed that there were no msgs coming thru. So I checked and suddenly its back to as it was no update on the chat. Anyone else having same probs. Also I haven't changed anything on my site to effect this.Also the following

I have a problem with my admin block. I have tried to install a module which I'm having problems with. I have installed and un installed it 5 times (still doesnt work). Now I have 5 links to this programme in amy admin block. Even when I remove it completely from the system AND the database I still get the 5 links showing. If I install it again I will then have 6 links. how can I get rid of these

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

Me again, as there seems to be a major problem with Clearchat can someone suggest another chat prog the does the same job.and sits in a block

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

is anyone monitoring this forum, dont seem to be getting a lot of help I am desperate to get this chat working help please Crying or Very sad

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

sorted the problem myself turn register globals on

Nuke Soldier Joined: Feb 02, 2008 Posts: 12

scorpio4646 wrote:

is anyone monitoring this forum, dont seem to be getting a lot of help I am desperate to get this chat working help please Crying or Very sad

I've yet to find a forum supporting PHP Nuke that isn't dead. Until I find one have to put up with thise site.

Nuke Soldier Joined: Aug 16, 2004 Posts: 32

you need suport? go to www.ravenphpscript.com.

They will usualy reply within 12 hrs.

I would sugest changing to Raven Nuke for better security

Nuke Cadet Joined: Jun 16, 2007 Posts: 1

Yep, need to have register Globals on. Does anyone have a work around for this? Makes the server very un-secure.

Site Admin Joined: Aug 17, 2003 Posts: 12368

phpNuke itself does not require register_globals, but if you're using a specific addon like ClearChat that requires such settings, you're going to have to talk to the creator of those addons