Anidazen Posted January 20, 2007 Share Posted January 20, 2007 Hello.I'm running a script which I'm having some incredibly unusual problems with - in that, unlike pretty much every other PHP script I've ever encountered, the results simply aren't consistant even with the [i]exact same[/i] paramaters.It's very difficult to work on, as the script successfully loads the majority of times, and then goes into errors the rest - so diagnosing it is a real pain. It also takes a while to run, compounding the issue.Anyway, to try and catch this out I've done several rounds of diagnosis, etc. etc. - it's a complicated creation. Anyway - it seems SQL queries in the script sometimes randomly fail. Even, like I said, given the exact same input. It's totally random.I set up the script to actually mail me when there was an error, and it turns out I keep getting one of these two errors: - Lost connection to MySQL server during query. - MySQL server has gone away.The first seems a little more common.Anyone have any idea how to fight this? Quote Link to comment Share on other sites More sharing options...
printf Posted January 20, 2007 Share Posted January 20, 2007 What driver version are you using? Is this a ODBC data source, and if it is, where is it running from (User or System) DSN? Can you show the script?printf Quote Link to comment Share on other sites More sharing options...
Anidazen Posted January 20, 2007 Author Share Posted January 20, 2007 It's on a hosted site with 1&1 internet.I can show the script if it will help. One thing about it that might be relevant is that I connect at the beginning and some queries can occasionally be a good 20 seconds after the initial connection, I guess that could be part of the problem.I'm afraid I don't 100% understand everything you're asking. :( Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.