Page 1 of 1

Setting up a cron job in phpMyAdmin

Posted: Fri Nov 09, 2007 3:33 am
by aceconcepts
Hi,

I've setup a cron jobwhich is intended to execute a php script.

I get the following message emailed to me when the job is run:

line 1: ?: No such file or directory
line 2: syntax error near unexpected token `"localhost",'
line 2: `$dbh=mysql_connect ("localhost", "uname", "pword") or die ('I cannot connect to the database because: ' . mysql_error());'

The script is supposed to insert some data into a table.

Any ideas?

Posted: Fri Nov 09, 2007 3:41 am
by s.dot
Yes. You probably have only entered the path of the script into the crontab program. It needs two parts:

Code: Select all

/path/to/php /path/to/script
So, a sample crontab command would be:

Code: Select all

/usr/bin/php /home/scott/cron/myscript.php

Posted: Fri Nov 09, 2007 3:51 am
by aceconcepts
Oh I see. I will give it a go.

Thanks.

Posted: Fri Nov 09, 2007 3:59 am
by aceconcepts
Hi,

I included the php path and now I get this message:

Status: 404
X-Powered-By: PHP/4.4.4
Content-type: text/html

No input file specified.

Does this mean that I have entered an incorrect file path?

Posted: Fri Nov 09, 2007 11:42 am
by John Cartwright
Yes

Posted: Fri Nov 09, 2007 12:35 pm
by aceconcepts
Thanks for confirming.

It's all working now.

Thank for your help.