Lost connection / server has gone away.

[Anidazen]

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?

[printf]

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

[Anidazen]

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. :(