[SOLVED] Cron Job Help

[sdevaney]

I cant figure out why this cron job will not run and no errors display. Any insight is greatly appreciated. Thanks a lot in advance!

 

<?
error_reporting(E_ALL);
ini_set('display_errors', '1');

include ("system/dbconnect.php");

$sth1 = mysql_query("select HeartID, RunEvery, RunTime, ModCode from heartbeat where Enabled = 'Y'") or die ('Error: '.mysql_error ());

while($datab = mysql_fetch_array($sth1))
{
$time = $datab['RunTime'];
$time = $time-1;

if ($time <= 0) 
{
	$runcode = $datab['ModCode'];
	eval($runcode);
	$time = $datab['RunEvery'];
}
$sth2 = mysql_query("update heartbeat set RunTime=$time where HeartID=".$datab['HeartID']."");
}

?>

[landavia]

$sth1 = mysql_query("select HeartID, RunEvery, RunTime, ModCode from heartbeat where Enabled = 'Y'") or die ('Error: '.mysql_error ());

u have problem in here

you should type

$sth1 = mysql_query("select HeartID, RunEvery, RunTime, ModCode from heartbeat where Enabled like '%Y%'") or die ('Error: '.mysql_error ());

 

[sdevaney]

$sth1 = mysql_query("select HeartID, RunEvery, RunTime, ModCode from heartbeat where Enabled = 'Y'") or die ('Error: '.mysql_error ());

u have problem in here

you should type

$sth1 = mysql_query("select HeartID, RunEvery, RunTime, ModCode from heartbeat where Enabled like '%Y%'") or die ('Error: '.mysql_error ());

 

I am afraid that did not fix it. Thank you though.

[sdevaney]

OK after doing a little more digging I have found that it runs once but it wont run again and I have it set to run every 5 mins. So does that mean there is a problem with my servers cron daemon or could it be something in my db? I am at a loss here so any information is appreciated. Thanks!

[ashishag67]

IF you can tell how have you scheduled your cronjob? what control panel has the server provided?

[sdevaney]

I have it set up to run every 5 mins. I used the Cron Job tab in Cpanel to set it up. If you need any other information feel free to ask. I thank you for the help.

[sdevaney]

I have solved the issue by using this command.

 

/usr/local/bin/php -f /home/deltoria/public_html/runcron.php