[SOLVED] cronjob help?

[darkfreaks]

ok i have never done anything wiith cronjob before. the cronjob wont execute  right.tpl.

 

here is the full path:

 

/home/soutlnet/public_html/main/right.tpl

 

it is not executing the file and in the file i put a query :

 

<?php

$result[0]= mysql_query("DELETE todayview FROM videos");
?>

 

is there something that is causing it not to execute the cron ???

[discomatt]

It doesn't seem like PHP is executing that script.

 

http://htmlcenter.com/blog/running-php-scripts-with-cron/

[darkfreaks]

would chmoding it to 777 make it execute or do i need to do something code wise ???

[discomatt]

Did you read the article I posted? If you did, you would have a better understanding of how cron jobs work, and would be able to diagnose the problem on your own.

 

The issue is you're not using PHP to parse the file.

[rarebit]

mmm

php /home/soutlnet/public_html/main/right.tpl

[rarebit]

or if it's not local I use 'wget'...

[discomatt]

Or take the easy way out and use rarebit's solution

 

You should read the article regardless... and for sure if the above poster's solution doesn't work.

[darkfreaks]

according to my host they changed it to the correct path. however i put the cronjob in a PHP file and put permissions to 755 so it would execute and it still has not. ???

[rarebit]

What full options have you used with cron?

 

 

 

I'd personally use wget over lynx because you can craft cookies and forms etc...

[darkfreaks]

i setup a cronjob in cpanel to execute the file every other minute  :-\

[jonsjava]

What full options have you used with cron?

 

 

 

I'd personally use wget over lynx because you can craft cookies and forms etc...

wget=uber power.  So many switches and abilities, it's crazy.

[DarkWater]

Paths don't matter right now.  You NEED to tell cron to run that script with the PHP binary, not /bin/sh.  Okay?  Please, at least TRY to do what we're telling you to do before you dismiss it and try to explain why we're wrong.

[rarebit]

For this type of thing i'll generally just dump something to a log file.

 

Since your using cpanel i'd suggest using wget...

[darkfreaks]

my question is shouldnt it be executing the file and executing the query ???

[jonsjava]

ok i have never done anything wiith cronjob before. the cronjob wont execute  right.tpl.

 

here is the full path:

 

/home/soutlnet/public_html/main/right.tpl

 

it is not executing the file and in the file i put a query :

 

<?php

$result[0]= mysql_query("DELETE todayview FROM videos");
?>

 

is there something that is causing it not to execute the cron ???

Is that all that's in the file? if so, you're missing the part where it executes it.

adding

if ($result[0]){
//do something
}
[code]
or something like that. If you do execute it, and we just aren't seeing it, sry.

[/code]

[darkfreaks]

ok i put if result to run the query else to error. would that run it ???

[rarebit]

what happens when you call the page normally?

[darkfreaks]

my code:

 

<?php

ini_set('error_reporting',E_ALL);
$result[0]= mysql_query("DELETE todayview FROM videos")or die(mysql_error());


if ($result[0]){
mysql_query("DELETE todayview FROM videos")or die(mysql_error());
echo "query successful!";

}




?>

[DarkWater]

I don't think that you understand what he said before. =X  You don't need that if () if you're not running any more code.

[jonsjava]

I'm guessing you also have your db connection stuff, but are leaving it out for security reasons.

Here's a simpler code.

<?php
if (mysql_query("DELETE todayview FROM videos")){
     echo "query successful!";
}
?>

[darkfreaks]

yeah i dont need any more queries.

 

i just want to know why it wont execute the cron :-\

[DarkWater]

yeah i dont need any more queries.

 

i just want to know why it wont execute the cron :-\

 

What EXACTLY do you have as your cronjob?

[darkfreaks]

*/2 3 ***

[jonsjava]

cron job to run:

*/2 * * * * php /home/soutlnet/public_html/main/right.tpl &1>/dev/nul &2>/dev/nul

it will run it every 2 minutes, and discard any screen output (send it to /dev/nul)

[DarkWater]

Make the output redirect to /dev/null, not /dev/nul. =P