Re: mySQL Times Out / Disconnects

You're missing a lot of pertinent code.

It would help to see what &Execute looked like, and when you're dumping MySQL/DBI errors, it's best to do so like this:

sub SQL {
$dbh = DBI->connect("DBI:mysql:DBname","$un","$pw") ||
 Terminate('Sorry, Disconnecting' . $DBI::errstr); # Prints error . $_
+[0]
} # END SQL
[download]

Other than that, this sounds like a time out issue if there aren't any errors being thrown by DBI like you say. Update your node and I'm sure we can solve this problem without too much trouble.

meh.

Comment on Re: mySQL Times Out / Disconnects Select or Download Code

Replies are listed 'Best First'.
Re^2: mySQL Times Out / Disconnects by CountZero (Bishop) on Oct 01, 2007 at 08:02 UTC
Unless the OP has been tinkering with the MySQL parameters, it seems unlikely to be a time-out issue as --IIRC-- the time-out value of an "out-of-the-box" MySQL is something like 8 hours. CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James	[reply]
Re^2: mySQL Times Out / Disconnects by JayBee (Scribe) on Oct 03, 2007 at 10:21 UTC
I've tried this and it failed without returning anything for the `$DBI::errstr` at all.	[reply] [d/l]