https://vborg.vbsupport.ru/showthread.php?t=248042
use this one

This is the best. Simple and does what is says. Thanks

Just got denied registration on my test account.
Running 4.1.10
Checked against database and no ip entry or email as i just made the email address for the test.
Is this a common problem?
Uninstalled until further notice.

Dedicated server with lots of resources, RAM, disk space, and bandwidth.

Three vBulletin 4.1.10 forums running, two with vbstopforumspam installed.

ONLY ONE of these (and not the most active one) has lately been throwing frequent errors like the following (these started just 2 or 3 weeks ago - prior to that, all was fine):

Normal registrations are still succeeding on that forum and as noted it is not a very active forum as yet. All of the errors are for usernames that look spammy but I have it set so that only email and IP are checked against the database, so it's not the username that's triggering this.

Also, despite the "MySQL server has gone away", there are no MySQL errors coming from several other sites on that server using MySQL incoluding at the same time that these errors are appearing, so the error seems to be misleading, i.e., it seems it's the invalid SQL statement that is throwing the error, not MySQL crashing.

Any idea what is causing this?

I know why you get database errors....

Lets say a new member (or hacker) tries to register...

• The register vB PHP script opens the database (with a (say) a 30 second time out (wait_timeout=30) set in MySQL my.cnf)
• The SFS plugin then goes off to check the credentials against the remote SFS service (3 times) using curl in my case
• SFS is either very slow or offline
• SFS plugin times out, then then retries using another method (silly really)
• The retry also times out
• The total SFS time out is > 30 seconds
• The plugin tries to update the database, which has 'disappeared' due to its own 30 second time out, and vB traps it as a DB error

So I've fixed the problem by ...
a) when using cURL not failing back to file access
b) changed the cURL time out to 8 seconds
c) changed to cURL time out from string to integer (time outs were not working at all)
d) also... changed split to explode for PHP 5.3 compatibility

Replace the functions_vbsfs.php file with the one attached here.

Enjoy! (permission given for the code to be added to the main product)

Kym

Hello,

It 's ok for vbulletin 4.1.1.1 ?

having the same problem with 4.1.12, disabled for now =(

Can anyone currently running 4.1.11 confirm this?

I've been getting lots of emails lately with new registration problems - seems like way too many emails are being flagged as spam. Going to look for another solution.

Disabled due to same reason above.