The last fired date and the next execution date is ok, i didnt have problems with the installation but things that are suposed to happen with my script does not happening (sorry for my english im from india) my script look some like this:
<?php
mysql_connect("localhost","user","password") or die("error conection");
mysql_select_db("database")or die("no database");
$importar = ' LOAD DATA LOCAL INFILE "somefile.csv" REPLACE INTO TABLE estadisticas FIELDS TERMINATED BY "," LINES TERMINATED BY "\n"';
mysql_query($importar) or die(mysql_error());
echo "done";
?>
i dont know if some can help me, i'll be really glad
almost work, theres no effect of my script on my site
-
- MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
- Posts: 1809
- Joined: Mon Oct 25, 2004 8:20 pm
- Location: Huddersfield, UK
- Contact:
Hi,
Try adding this to your page:
It will email you when it runs (change: you@yourdomain-com to your own email address).
You should also check that MySQL is not terminating the script due to an error, try capturing any MySQL errors and email them to yourself too! For how to do it see:
http://uk2.php.net/mysql_error
Hope that helps
Dave.
Try adding this to your page:
Code: Select all
mail("you@yourdomain-com",
"testing phpJobScheduler",
"just ran",
"From: you@yourdomain-com\nReply-To: you@yourdomain-com");
It will email you when it runs (change: you@yourdomain-com to your own email address).
You should also check that MySQL is not terminating the script due to an error, try capturing any MySQL errors and email them to yourself too! For how to do it see:
http://uk2.php.net/mysql_error
Hope that helps
Dave.
Return to “phpJobScheduler [forum]”
Who is online
Users browsing this forum: No registered users and 1 guest