Re: php script fails when run from cron

blackwater dev wrote:

I have a script which runs fine from the command line but when I try to run it via cron, it seems to fail when the db class is instatiated, here is some code: $yesterday = date("Y-m-d",mktime(0, 0, 0, date("m") , date("d")-1, date("Y"))); $file=fopen("/usr/local/apache2/htdocs/core/logs/import.log","a"); fwrite($file,"---------DATE:".date("Y-m-d")."---------\n"); fwrite($file,"Starting:".date("H:i:s")."\n"); include("/usr/local/apache2/htdocs/includes/lib/ms_db.class.php"); include("/usr/local/apache2/htdocs/includes/lib/database.php"); fwrite($file,"got two classes:".date("H:i:s")."\n"); $ms_sql= new ms_db(); $my_sql=new Database(); fwrite($file,"got 1:".date("H:i:s")."\n"); The code then goes on to move some data from a remote SQL Server db to the local mysql. When finished, the log stops at "got two classes". I am trying to debug now to see which of the two classes it seems to be failing on. I don't have anything in the php error log. The MSSQL connection uses freetds so I am not sure if it is something there but again this script runs fine with just php myfile.php.

Do you have multiple php versions installed (one has freetds support, one doesn't) ? How are you running it from cron? Maybe the cron job is picking up a different php? Turn up error_reporting and see what messages you get.. -- Postgresql & php tutorials http://www.designmagick.com/