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.
Any ideas?
Thanks!
