Forum Moderators: bakedjake
But I've recently had a programmer write a php script that is reading an external xml file into my database and it just isn't executing with my cron job.
If I trigger the php file through IE it runs no problem.
So I'm wondering are their any limitations in php if it is executed through a cron tab?
I was thinking script size?
database calls?
reading external xml files?
As you can probably tell I'm not the programmer but without any cue I'm kind of stuck between my host and programmer who are blaming each other.
thanks
You may look (or let your programmer look) at these things systematically:
-- did the program start at all: is everything spelled correctly in the crontab? (possible errors: wrong or incomplete path, the cron job may have a different environment than you, so the path to the script should be specified completely as /path/from/root/to/script).
-- Could the program find the external xml file? (possible errors: wrong or incomplete path, see above; to be fixed either in the cron statement if specified as argument, or within the program if hardcoded there)
-- Could the program read the file? (possible error: insufficient file permissions, the cron job may run under another user context than you locally)
-- Could the database be connected (there always is a database return codes for this)?
-- was the SQL accepted (again a database return code)?
-- are there other things to note?
Kind regards,
R.