Cron MYSQL Link Problem.

[DesignLoft]

I have finally sorted out the "Access Denied" problem relating to the MYSQL login. Now the problem is the mysql links. As an example this is hospital.php, ( the error is happening with all the cron php's)

Error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/home/ben/public_html/mafia/SuPerdupercronSZ/are/not/4u/hospital.php on line 5

 

the line is:

mysql_query("UPDATE users set hospital=hospital-1 WHERE hospital>0",$c);

 

any ideas how to sort this out? :?

[Decepti0n]

Re: Cron MYSQL Link Problem.

delete the ,$c bit

[DesignLoft]

Re: Cron MYSQL Link Problem.

But then if i delete that will the

 

global $c;

 

still work as i have deleted the $C from the mysql query,

Also with braveupdate and the other crons they have more than 1 ,$c

shall i delete all of them that i see? :?

[Decepti0n]

Re: Cron MYSQL Link Problem.

did you include the mysql.php page?

the ,$c part is optional anyway, its not needed for the query to run. without it, it just uses the last connection opened with mysql_connect(). and since its a warning, it generally doesn't do much to interfere with the running of the script

also, im pretty sure you don't need global $c anywhere, except inside functions.

[DesignLoft]

Re: Cron MYSQL Link Problem.

right thanks, I'll delete them.

Yes the mysql.php is included in all the crons. And the mysql connectoin as just beeen corrected,

[DesignLoft]

Re: Cron MYSQL Link Problem.

I still keep getting

 

curl: Permission denied

 

the mysql is fine, cron locations everything.