cron jobs error no such file or directory

Question

I setup a Cron job on my web hosting which runs my code every minute. but I still got an error that I cannot run the script. I do not know whether my command is wrong. here I have attached the coding and the error I got.

below is my PHP code.

$select_user = mysql_query("SELECT * FROM users");
while($row=mysql_fetch_array($select_user)){
    $normal_w = $row['normal_wallet'];
    $interest_w = $row['interest_wallet'];
    $normal_w = $row['normal_wallet'];

    $run_interest = ($normal_w + $interest_w)*0.02;

    $update = mysql_query("UPDATE users SET interest_wallet=interest_wallet-'$run_interest' WHERE status='active'");

}   ?>

The command I use:

my command

The error I get from the email:

error

Can someone help me?

why i need to stop choosing mysql_* ? how can i select my db ? — ppf papafarmer, Feb 18 '17 at 07:58
apokryfos is saying to use `mysqli_*` or `PDO` , `mysql` is removed from latest version — Niklesh Raut, Feb 18 '17 at 08:00
Does this answer your question? [CronJob not running](https://stackoverflow.com/questions/22743548/cronjob-not-running) — tripleee, Jan 20 '21 at 08:17

score 0 · Answer 1 · answered Feb 18 '17 at 07:59

0

You need to use php -q to run php file

so it would be your command

php -q /home/ppfpapaf/public_html/cron_jobs/cron_jobs.php

answered Feb 18 '17 at 07:59

Niklesh Raut

34,013
16
75
109

score 0 · Answer 2 · answered Feb 18 '17 at 08:01

Hope Something wrong with your command. Thats the reason your cron cannot find a file directory.

Try something Like this in your Command Field:

/usr/local/bin/php /home/ppfpapaf/public_html/cron_jobs.php

Or

/usr/bin/php /home/ppfpapaf/public_html/cron_jobs.php

cron jobs error no such file or directory

2 Answers2