Access Denied (Php problem)

[killaklown]

Im using phpBannerExchange 2.0 Gold and when i put the HTML code on a site, it shows this error:

Warning: mysql_real_escape_string(): Access denied for user: 'ovfactor@localhost' (Using password: NO) in /home/ovfactor/public_html/view.php on line 43

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/ovfactor/public_html/view.php on line 43

Warning: mysql_real_escape_string(): Access denied for user: 'ovfactor@localhost' (Using password: NO) in /home/ovfactor/public_html/view.php on line 44

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/ovfactor/public_html/view.php on line 44
Invalid Banner Code!

The view.php file is attached, can anyone fix it or tell me whats wrong? (had to save it as a txt, couldnt upload php and didnt feel like zipping it).



Edit: it has something to do with these two lines:

$uid=mysql_real_escape_string($uid);
$cat=mysql_real_escape_string($cat);

I removed them and the error was gone (but it needs these lines to work)

 

[Dan]

It's access denied, so I think the problem is the MySQL details you have in config.php

Check if they are right, etc.

 

[killaklown]

there all right, ill double check it though (i have changed it since i installed the script, and it had no errors)


Edit: double checked and its all right...

 

[tanfwc]

It seems that you do not have a password input in config.php.

 

[killaklown]

my config has:

$dbhost = "localhost";
$dbuser = "###########";
$dbpass = "#######";
$dbname = "#############";

 

[tanfwc]

Shouldn't mysql_real_escape_string be place only before sending the query to the sql?

Maybe you can understand better with this documentation...

http://sg.php.net/mysql_real_escape_string

 

[Kate]

There must be something wrong with your authentication credentials above.
Also the error you pasted says

Warning: mysql_real_escape_string(): Access denied for user: 'ovfactor@localhost' (Using password: NO) in /home/ovfactor/public_html/view.php on line 43

Perhaps your password is not set. Check & echo the variable...

 

[killaklown]

now that i look at the error, shouldnt ovfactor@localhost be the username of the database?

 

[Dan]

That should be the username.

 

[killaklown]

what would be making it say "ovfactor" instead of "ovfactor_theusername"?

because the username in config is "ovfactor_theusername"