[djbaxter]

Originally Posted by ForceHSS

Talk to your host about this problem "MySQL server has gone away"

Not that simple. I'm getting similar errors with the other mod from which this was derived:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '216.244.87.218' , 'dmmt347ewq@hotmail.com', 'zeeukslzdx', 'Result on field ip - 216.244.87.218 [REMOTEERR] Unverfied but allowed by policy', 0, 'f3c419d6641f368fc5888e9c4a81d2be');;

They usually also say

MySQL server has gone away

but that's a red herring. I'm on a dedicated server and that is the ONLY time I'm getting these errors. There are no other MySQL issues at the times these occur and it happens on two different 4.2.2 forums.

It's the Invalid SQL error that needs attention. Note the double occurrence of ";;" at the end. That looks malformed to me.

It may well have to do with upgrading to PHP 5.4.20 after the vBulletin 4.2.2 upgrade. I'm not certain.

A satisfactory workaround for now I think would be to turn off logging since the rest of the functions seem to be still working. There is no option to do that in vbStopForumSpam and I don't recall such an option for this mod either (I found it to be overkill for my needs so I reverted to the simpler version).