DBD execute Failure - need assistance plz
A cgi script that I've been using for years no longer works properly on my new server... The error, as far as I can track it down in the cgi scripts error logs, is that execute failed:
::mysql:
t execute failed: MySQL server has gone away at /home/sexinfo/public_html/cgi-bin/am/AdDb.pm line 58, [GEN1] line 1As far as I can see, execute in this script is used to do perform a simple select query.
I've updated DBD to the newest version, but this has not had an effect on the problem...
-------
My guess is that there is something interfering with the database connection when the script tries to run in daemon mode... so the simple select statement is failing because the connection isn't open / working. When the program is set to work in brute mode (ie a new connection every time), it works fine... just hogs all the cpu.
What is confusing me the most here is that the problem got worse with time... It started out working, then started acting up... ie it would fail on occasion... then it stopped working completely. I've tried several reinstalls using a fresh zip of the program, but it made no difference.
-------
I am using a server management company, but the ticket is now on day 7... and they haven't made any progress...
Can anyone point me in the right direction on what I can do to debug this?
I've read that DBD has a debug mode that may be able to provide more information, but i'm unsure of how to activate it / view it...
