Certain php functions + CRON?

[Michdd]

I was wondering if there would be a problem using an include(); function to include a connection to  a database when using CRON. I'm trying to use CRON jobs to run a script every 12 hours that dumps all the values from a certain row in my database, when I run the script myself it works perfectly, but when I use CRON it doesn't work.

 

Only thing I can think of is that CRON jobs has a problem including the connect.php file, anyone know why it isn't working?

[flyhoney]

include() should definitely work in a CRON job.  I would imagine the problem lies elsewhere.

[Michdd]

include() should definitely work in a CRON job.  I would imagine the problem lies elsewhere.

Any idea where? I've used CRON on other things before, and it surely works. Just not with this..

[Mark Baker]

Check the path.

In fact, check the php.ini file that you're using for command line PHP scripts.

[trq]

Are you using absolute paths within your include?

 

Cron doesn't run from where the actual php file is located so relative paths won't work.

[Michdd]

Are you using absolute paths within your include?

 

Cron doesn't run from where the actual php file is located so relative paths won't work.

Thanks a lot, I believe you solved this, I'll just write in the connect information in the file instead of including it, I'll try that right now.

[Michdd]

That didn't work, the code in the file is this:

 

<?php

--Connect information--

$result = mysql_query("UPDATE pets SET ips=''") 
or die(mysql_error());  

?>

 

It works perfectly when I just run it normally, but not when I use CRON :|

[Mark Baker]

Check the version of php that's being run from the command line (php -v), and that mySql is enabled for that version