Given today's date, the settings for $mintime and $maxtime yield a span of about 28 months (from April 3 2005 to Aug. 8 2007), or about 850 days, give or take. In your "for" loop, which iterates over that span one day at a time, there is a "sleep(1)" (very polite).
Does the script run for nearly 15 minutes and produce no output whatsoever? Or does it run for a very short time?
Apart from that, the use of a module called "Mysql" seems outdated. You should be using a module called DBI, which in turn uses a "driver" module called DBD::mysql.
As for the "save_to_db" module, that's not on CPAN, and the only people who have encountered it are probably people who have read that same "Safari book called Baseball Hacks". The problem might be in that module, but you haven't shown it here (and I don't have a copy of that book).
There is a print statement that precedes the for loop, and if you are not seeing a line like "iterating from Sun Apr 3 00:00:00 2005 to ...", then the script must exiting before it reaches that print statement. (This would also suggest that the script is exiting very quickly, rather than running for 15 minutes.)
You could try stepping through it with the perl debugger; run it at the command line like this:
You'll be prompted by the debugger for things to do; you can start with "h" to see a brief summary of debugging commands (like "s" to step, "b line#" to set a breakpoint, "c" to continue execution, etc.) You might also find it worthwhile to read the output of "perldoc perldebug". You'll get copious warnings and diagnostics as you step along this way, and you can look up messages you get in the perldiag manual.perl -d name_of_script
In reply to Re: Blank result but no error
by graff
in thread Blank result but no error
by nase
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |