DELETE FROM humanverify WHERE hash =

[citricguy]

Ok, I'm stumped. I keep getting the following error. The only constant is the Script and Referrer, the link is always the same (hundreds if not thousands of errors have been emailed to me over the last week or so). I have tried everything from disabling all hooks/plugins (though I have them re enabled now) and changing from ReCaptcha to Image and nothing seems to fix it.

I'm running vBulletin 3.7.1pl2

I'm thinking I should just delete that post or something? It seems to be the only problematic page.
Database error in vBulletin 3.7.1:

Invalid SQL:

DELETE FROM humanverify WHERE hash = 'b7xxxxxxxxxxxxc0b6ac4a24ad53fe8a3' AND answer = '';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, June 24th 2008 @ 01:08:44 AM
Error Date : Tuesday, June 24th 2008 @ 01:10:48 AM
Script : http://www.recognizedexpert.com/expert/newreply.php?do=postreply&t=130
Referrer : http://www.recognizedexpert.com/expert/newreply.php?do=newreply&t=130
IP Address : xx.xx.xx.xx
Username : EndutnupUttep
Classname : vb_database
MySQL Version :

EDIT: Also, I installed this patch http://www.vbulletin.com/forum/project.php?issueid=25734#note64870

It fixed the issue with ReCaptcha not working, but it did not solve the error above. I can also not reproduce the error on my own (haven't figured out how) but I am getting a steady stream of error emails still.

[derfy]

Please see this doc (http://dev.mysql.com/doc/refman/5.0/en/gone-away.html).

[Wayne Luke]

In your Admin CP go to Maintenance -> Diagnostics -> Server Variables -> MySQL Variables. Run that and scroll to the bottom. What does it say for wait_timeout?

If it isn't at least 120 then you need to increase that.

[citricguy]

Well after trying everything from upgrading to 3.7.2 to upgrading my PHP from 4 to 5 I decided to just delete and recreate that one troublesome post. And it fixed it!

So just in case anyone else gets the same error I did I wanted to leave this fix.

I guess the only thing that made my problem different than the other "Server has gone away: error 2006" issues is that the referring script was always the same. Problems were generated by different users from different IP's on different days, but it was always the exact same post that was causing the error. I hope this helps someone :D