vbStopForumSpam

[cryptodan]

I have upgraded to the latest and greatest VB, and I no longer see my submit to stopforum spam in the search for user section in Admin CP under the user's profile. What happened?

[GamerPerfection]

Were you having it screen for user name?
When I first installed this mod I have it check username, email and IP. I soon found out that even normal usernames were on the stopforumspam database so I disabled username checks. The username check is pointless anyway because with emails it is unique to someone and so can IP in a lot of cases. Whereas username is not unique to anyone.

However, having said that, I have not had a single spam bot join my site for a long long time since installing this mod. But.... and there's always a but.... I had a suspicious account register the other day and it had a .ru email. I later manually checked the stopforumspam site and the email and IP is on the database but it appeared on there AFTER it registered on my site. Then today I get another strange username register, but with a .com email. It's not currently on the stopforumspam database, but when I search the email on google I found it on another forum where it registered yesterday with a different but again odd username so I suspect it is also a spam bot.

So after all this time I now start getting spam bots register.

I like the sound of the "bad behaviour" and "VSA advanced permissions" mods. I might check those out.

[clarkstoncracke]

This is the best fricken thing EVER to be offered for vbulletin. Absolutely amazing. In the last 16 hours (since I installed it) It has prevented 212 people from registering, allowed 47 people to register, and after hand checking all 47, only two were spam. Amazing. Sending donation now.

This mod, used in combination with the geographical ip prevention is wonderful. I can block all of asia. My life is back to normal again!!

To the people who say their worried about blocking legit people, I can only say that I don't care. Spending hours a day filtering through new registrations vs having a few legit people per day blocked is not even a question of being a problem for me.

[denman75]

it is great ,having it since it was available ,amazing to see how it is working ,loving to browse true the logs ,lots of .ru spam last months
but im glad this mod is here ,its one of the best mods for VB

[Savage Circuits]

I have two suggestions based on the SMF mod that uses StopForumSpam's database to filter spammers. The SMF version as I recall had another option besides just deny or allow registration on match.

I would suggest a third option...allow registration and put the regsitrant in the moderation queue. Also, if the database can't be reached for whatever reason a similar approach should be taken to ensure valid registrants aren't tagged as spammers just because they couldn't be checked.

As a note I am impressed with the fact that this mod still works on V4.1 considering no updates for quite some time. I would be willing to donate if the mod could be rounded out and provide more options on how to handle things.

[djbaxter]

if the database can't be reached for whatever reason a similar approach should be taken to ensure valid registrants aren't tagged as spammers just because they couldn't be checked.

There is already the option of allowing registrations if the database can't be accessed.

[polle]

Can anyone confirm its ok to install in VB 4.1.1 ?

Thanks.

[GlowHost.com]

Can anyone confirm its ok to install in VB 4.1.1 ?

Thanks.

You can, but the facebook integration does not work.

Try Spam-O-Matic (https://vborg.vbsupport.ru/showthread.php?t=248042) as an alternative which has a few more features and works in a similar fashion.

Pedigree and the StopForumSpam website say that the mod in this thread is no longer being developed.

[Drake Splinter]

I can confirm that this does work on 4.1.1

[k1klass]

You can, but the facebook integration does not work.

Try Spam-O-Matic (https://vborg.vbsupport.ru/showthread.php?t=248042) as an alternative which has a few more features and works in a similar fashion.

Pedigree and the StopForumSpam website say that the mod in this thread is no longer being developed.

cheers for the info, as i had a bot sign up tonight that's listed about 10 times on the stopforumspam website, and everything had been running sweet till now, only by chance that i checked it out.

[HP10T]

I can't seem to find where the logs are kept similar to the screen shot on the first page of this mod that shows the checks that were done etc..?

[cnredd]

I installed on my forum (3.8.2), but I get a blank page when I click to check the logfile (all white next to the menu)...

I've seen where a couple of people got blank pages when they attempt to submit, but I don't even get that far...

https://vborg.vbsupport.ru/external/2011/01/4.jpg

[zygote]

We have used this for a year with no spam, now we are starting to get spammed.
please can anyone update or will it just die out?

[HP10T]

I installed on my forum (3.8.2), but I get a blank page when I click to check the logfile (all white next to the menu)...

I've seen where a couple of people got blank pages when they attempt to submit, but I don't even get that far...

https://vborg.vbsupport.ru/external/2011/01/4.jpg

Perfect thank you very much :)

[cnredd]

Perfect thank you very much :)Perfect????

I'm pointing out that my logpage is blank...I need a fix for it...

[Stefan118]

Does anyone know how to erase the data?
I installed this mod last night, and allready there are 317 log entries!

Is there a simple way to delete this data from the database?

[kylek]

Go to admincp > Statistics and Logs > vbStopForumSpam Logs

You can prune the logs using the Remove Entries Older Than (Days) section.

[fixbug]

I can confirm that this does work on 4.1.1

And on 4.1.2 too.

[Stefan118]

Go to admincp > Statistics and Logs > vbStopForumSpam Logs

You can prune the logs using the Remove Entries Older Than (Days) section.

Ehhh, WHERE do i find te remove entries option?
Added an image of what I see.

Edit:
Ok i found it.
Had to log in with the admin account instead of my own account.

[Crossbow]

Installed. Thank you.

[MHC]

Ehhh, WHERE do i find te remove entries option?
Added an image of what I see.

Edit:
Ok i found it.
Had to log in with the admin account instead of my own account.

Sorry I just can't see where I can prune log entries (and do I ever have a lot of them!) and I am in the Admin account. I'm in the vbStopForumSpam Logs (vbStopForumSpam Log Viewer).

I can sort the entries by username, email addies. When I ask to sort them by IPs, I see a Invalid SQL error message but the server is kept under wraps by the owner and I don't want to go there.

Besides, there must be an easier way of pruning these entries? Maybe I missed some button in the interface, a link or something? :confused:

[Delphiprogrammi]

Sorry I just can't see where I can prune log entries (and do I ever have a lot of them!) and I am in the Admin account. I'm in the vbStopForumSpam Logs (vbStopForumSpam Log Viewer).

I can sort the entries by username, email addies. When I ask to sort them by IPs, I see a Invalid SQL error message but the server is kept under wraps by the owner and I don't want to go there.

Besides, there must be an easier way of pruning these entries? Maybe I missed some button in the interface, a link or something? :confused:

that is a bug see this for a fix https://vborg.vbsupport.ru/showpost.php?p=2117909&postcount=234

[MHC]

that is a bug see this for a fix https://vborg.vbsupport.ru/showpost.php?p=2117909&postcount=234

Thank you, thank you, thank you! :up: :up:

[AndrewRich]

Installed on newly-upgraded to 4.1 mousepad.mouseplanet.com. Unfortunately the "submit spammer to database" code is broken in 4.1; just shows some PHP errors in the AdminCP user page instead of showing the custom fields.

[steven s]

Also looking for this. Have spent over an hour reading forum posts trying to find a valid link to something that shows how. Frustrating. The software works brilliantly so having this last bit of information somehow hidden is sad.My last update wrote over this code. I surely do miss it.

[zushiba]

This mod is flagging internal network IP's as spam IPs. Is there any way to configure this to ignore certain IP's or the entire 192.168.0.0/16 range of IPs?

[Carlos X]

4.1.3 user here, wanting this update.

[djbaxter]

4.1.3 user here, wanting this update.

It already works with 4.13

[blacksurfer]

It's flaggin Facebook connect users as spam. Please advise.

[GlowHost.com]

It's flaggin Facebook connect users as spam. Please advise.

Try this one which works with Facebook:
https://vborg.vbsupport.ru/showthread.php?t=248042

[motorola]

I plan to uninstall this and I want to know if there are any files that i should remove ?

[Alan_SP]

For this, always look what you installed. If you uploaded some files, you can remove them. Or not...

[edie]

You wrote:
Issues are
"- The usergroup permissions / view details etc DONT work. I jumped the gun and put the permissions controls in there before I put the code in. Please delete the includes/xml/bitfield_vbstopforumspam.xml file and rebuild your postbit"

Do I do this before or after I upload the files to the root?
Why is this message emitted from installation instructions that came with the download installation?

- confused.

thx!

- Edith Williams

[Delphiprogrammi]

You wrote:
Issues are
"- The usergroup permissions / view details etc DONT work. I jumped the gun and put the permissions controls in there before I put the code in. Please delete the includes/xml/bitfield_vbstopforumspam.xml file and rebuild your postbit"

Do I do this before or after I upload the files to the root?
Why is this message emitted from installation instructions that came with the download installation?

- confused.

thx!

- Edith Williams


1) delete the mentioned file
2)login to your admincp
3) type index.php?do=buildbitfields
4)done

[Delphiprogrammi]

I plan to uninstall this and I want to know if there are any files that i should remove ?

yes all files used by the modification

[Dozer826]

Is there a way to add usernames or IPs to a safelist? I'm getting a few random people contacting me saying that they are being marked as spam.

[Sc00by22]

I am getting a MySQL error when trying to import the plugin, my MySQL version is 5.5.11

Invalid SQL:

CREATE TABLE IF NOT EXISTS `fl_vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4


EDIT

I fixed it myself TYPE=MyISAM had to be ENGINE=MyISAM

[pedigree]

Sorry about the delays in responding. I spend most of my spare time on the stopforumspam.com site improvements. Glowhost is working on improvements to the source (and god knows it needed it!)

I hope to, one day, upgrade some of the code with requests but I just dont have much in the way of spare time given the ongoing requirements in just keeping stopforumspam.com running. I hope you all understand. Maybe once its all working just the way I want it, then Ill start coding mods for all the blogs and forums that I can (legally) for my hands on.

[washingtonboise]

For improving the database, spammers have to me manually reported, one at a time. Sounds like a losing war. They automate, so should we. Any reason not to other than the 1% chance that someone is marked as a spammer when they weren't and that prevents them from easily going to other forums?

[Paul.]

Hi Pedigree, I've installed this on three forums we have. No idea if it's working, but we'll see!
Getting a lot of ''thanks for post, great post'' or similar.

But, is there a way I can see logs of what has been rejected?


Edit: 24 hours later.. not one spam post has been made.. which is technically a record.

I've had about 3 in total for our three forums.. :cool:
How can I mark some as Spammers, and mark others who aren't that have been mistook as spammers?

[Computer Ninja]

StopForumSpam is not working. The site is down, and I'm getting mysql errors on my site when people try to register. (Probably because the service is down).

[djbaxter]

Set the options to allow (or reject if you prefer) registrations if the site cannot be contacted. Then check new registrations manually until the site is back up.

[kylek]

http://twitter.com/#!/stopforumspam

Posted on his twitter:

working on getting a temp fix up and running until the morning.

website just died. typical when leaseweb have just gone home and 15 minuets after they would charge me 149 euro to answer the phone :(

[skubaman]

Set the options to allow (or reject if you prefer) registrations if the site cannot be contacted. Then check new registrations manually until the site is back up.

My vB is quitting whether I set the option to accept or block on connection errors. I think we need to completely disable the mod.

Thanks

[SamirDarji]

http://twitter.com/#!/stopforumspam

Posted on his twitter:

working on getting a temp fix up and running until the morning.

website just died. typical when leaseweb have just gone home and 15 minuets after they would charge me 149 euro to answer the phone :(Any idea when you'll be back online? I only use the site manually, but it's a terrific resource. :)

[Kaspersku]

why the author did not update to 4.1.x
I really like your mod but can not be used, I regret

[pjgauthier]

Installed and great mod! www.StopForumSpam.com has been down for a few days and unavailable.

[ablaye]

I have enabled facebook connect to allow my users to connect with their facebook accounts. However, this mod is blocking all facebook logins. Help!

[marvel79]

why the author did not update to 4.1.x
I really like your mod but can not be used, I regret

Works fine for me on 4.1.2.

Great plugin, I really needed this, thanks!

[chrisxp]

Hi there,

since updating to 4.1.4, the "Add Spammer" box doesnt show on editing users..

could this be updated, or tell me how to?

thanks,

chrisxp

[mavortium]

Same problem here.

Hi there,

since updating to 4.1.4, the "Add Spammer" box doesnt show on editing users..

could this be updated, or tell me how to?

thanks,

chrisxp

[odie3]

hope this MOD keeps running cause it has blocked 80+ registrations! My forum is made up of a old gaming team and we hardly get new registrations anymore but it's nice to have registration enabled again in case we get a someone that needs to register.

[businessmeet]

awesome plugin ..

[Abfabmedia]

to install on my forum at http://www.plymouthbuzz.co.uk

I have a small budget

David

[misericorde]

Please Uptated for vb 4.1.7

[djbaxter]

Please Uptated for vb 4.1.7

It works fine in 4.1.7.

[ngocol]

thanks installed

[ffaat]

Currently, only Admins can access the vbStopForumSpam Logs in the back end.

Is there any way I can add this to Moderators as well?

Thanks,

-Rob A>

[motorola]

How to uninstall this mod ?

[Toshinobu]

I'm getting the following error message when I try to import the product XML file:

Database error in vBulletin 4.1.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064

Any help would be appreciated, thanks. I looked at the SQL script it's complaining about and it looks fine.

**EDIT**
Replace the word TYPE with ENGINE on lines 22, 35, and 45 and product imported successfully :)

[ForceHSS]

I'm getting the following error message when I try to import the product XML file:

Database error in vBulletin 4.1.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064

Any help would be appreciated, thanks. I looked at the SQL script it's complaining about and it looks fine.

**EDIT**
Replace the word TYPE with ENGINE on lines 22, 35, and 45 and product imported successfully :)

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

[WillisB]

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

[DAMINK]

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.

[djbaxter]

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):

Database error in vBulletin 4.1.10:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '91.207.5.126' , 'kinotru@gmail.com', 'UsasseSaf', 'Result on field ip - 91.207.5.126 [REMOTEERR] Unverfied but allowed by policy', 0, 'b70728cf449d36b0ad5f2f7f713814ec');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 27th 2012 @ 08:35:37 AM
Error Date : Monday, February 27th 2012 @ 08:36:07 AM
Script : http://domain.com/register.php?do=addmember
Referrer : http://domain.com/register.php
IP Address : 91.207.5.126
Username : UsasseSaf
Classname : vB_Database


Database error in vBulletin 4.1.10:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message,
blocked, userhash) VALUES (now(), '72.64.146.136' , 'sunnie2088@gmail.com',
'usbflashdriveppx', 'Result on field ip - 72.64.146.136 [REMOTEERR]
Unverfied but allowed by policy', 0, '781be45ede1bf941343ca68fd875b7ec');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 27th 2012 @ 05:53:45 AM
Error Date : Monday, February 27th 2012 @ 05:54:15 AM
Script : http://domain.com/register.php?do=addmember
Referrer : http://domain.com/register.php
IP Address : 72.64.146.136
Username : usbflashdriveppx
Classname : vB_Database


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?

[AusPhotography]

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

[alhidaya]

Hello,

It 's ok for vbulletin 4.1.1.1 ?

[Eq4bits]

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.
having the same problem with 4.1.12, disabled for now =(

[Sage Knight]

Hello,

It 's ok for vbulletin 4.1.1.1 ?

Can anyone currently running 4.1.11 confirm this?

[N75]

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.

[vidmarc]

Disabled due to same reason above.

[BrightStar]

I still use it on my forum 4.1.12 and didnt notice these issues. I do keep an eye on the log system to see if legit users are being denied registration.

[kylek]

Use it on 4 forums and have no problems. But we have it set to not check usernames which can block a lot of newbies registering.

[CarterMarkham]

VB 4.1.10 Not working, I get this error...

Database error in vBulletin 4.1.10:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `wrx_vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Sunday, April 22nd 2012 @ 07:25:09 PM
Error Date : Sunday, April 22nd 2012 @ 07:25:09 PM
Script : http://www.wrxnation.com/admincp/plugin.php?do=productimport
Referrer : http://www.wrxnation.com/admincp/plugin.php?do=productadd
IP Address : 74.78.40.34
Username : WRXNation
Classname : vB_Database
MySQL Version : 5.5.19-55

[HHelp1]

VB 4.1.10 Not working, I get this error...

Database error in vBulletin 4.1.10:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `wrx_vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Sunday, April 22nd 2012 @ 07:25:09 PM
Error Date : Sunday, April 22nd 2012 @ 07:25:09 PM
Script : http://www.wrxnation.com/admincp/plugin.php?do=productimport
Referrer : http://www.wrxnation.com/admincp/plugin.php?do=productadd
IP Address : 74.78.40.34
Username : WRXNation
Classname : vB_Database
MySQL Version : 5.5.19-55
Do you have MySQL 4.1.1+ or greater?

[kermit2]

Do you have MySQL 4.1.1+ or greater?

He's on 5.5

Try editing product-vbstopforumspam.xml, and replace TYPE=MyISAM with ENGINE=MyISAM, that should fix it

[alhidaya]

Hello,

Sometimes it prevents members to register with the notification message that is spam. I also did the test and beugue parfoirs. Soon it would be to update it.

[Chadi]

Getting this error (using vb 4.2.0)

Warning: file_get_contents([path]/includes/database_error_message.html) [function.file-get-contents]: failed to open stream: No such file or directory in [path]/includes/class_core.php on line 1149

Warning: file_get_contents(/home/user/public_html/includes/database_error_page.html) [function.file-get-contents]: failed to open stream: No such file or directory in /home/user/public_html/includes/class_core.php on line 1256

[alhidaya]

Hello,

Is what you can do an update because they block some of the members for registration when they are not spammers.

[alhidaya]

Excuses me

CAN YOU UPTADE PLEASE FOR VB 4.2.0 Because sometimes there is a failure when people register

[JaBBeD]

Anyone else encounter an error with ALL facebook registrations?
It denies them all

[stationar]

I receive a lot of emails from users trying to register (including facebook registration). Turned the product off.

[DAMINK]

There has been no reply for months from the creator and its clearly failing.
Why is this mod not in the graveyard?

[kylek]

Because it works fine for most people.

[GamerPerfection]

Clearly failing? Don't be daft.

Are you sure you two don't use the "test username" option? Because if you do that's just as daft.

[MagiKelly]

There has been no reply for months from the creator and its clearly failing.
Why is this mod not in the graveyard?

Working fine for me too. Getting new members without problem and dramatically reducing the amount of spammers. I simply can't imagine going back to the days before this mod.

[djbaxter]

There has been no reply for months from the creator and its clearly failing.
Why is this mod not in the graveyard?

It's not failing. It's working fine for most people. And why on earth would it be moved to the graveyard?

[dmm2020]

Using it on 4.2 pl2 and it seems to work so far. Question though is where does log write to? Where do I read the log at?

[kylek]

Using it on 4.2 pl2 and it seems to work so far. Question though is where does log write to? Where do I read the log at?

Go to your Admincp - down close to the bottom on the left side > Statistics & Logs > you should see vbstopforumspam logs.

[dmm2020]

Go to your Admincp - down close to the bottom on the left side > Statistics & Logs > you should see vbstopforumspam logs.

Found it shortly after I posted the question. Thanks.

[GamerPerfection]

Mark as installed on 4.2.0.

I use this setting :
Test IP address : disabled
Test User name : disabled
Test Email Address : enabled
Query Connection Errors : allow registration
Similar to my settings but I have IP test enabled and connection errors to block registration.

Is it recommended to allow registration if it times out?

[pedigree]

I am still here but I really don't have the time to fully support the mod. Glowhost took the code and added to it for Spam-o-matic, which will provide protection for vb4+, and if there are any show stoppers, then I can provide some support for it on the stopforumspam.com website which I run.

Most of the issues are around no open_url and/or curl access, which I've really answered to death.

The good news is that I will be releasing this for vb5 when its released. I'm just waiting for some code to be made available.

[pedigree]

@semprot thats up to you, you can let them register or you can block it. The stopforumspam servers are up and working and the error means that your server cannot contact the stopforumspam.com servers via file_get_contents and/or curl.

[dmm2020]

One suggestion to save answering your favorite question to death is in the settings in the admin panel, put a bold red warning when open_url and/or curl access is not available. That's what I do on my arcade script I am releasing. Of course cURL is hard to detect on some servers.

[pedigree]

when I do the next version, for vb5, then I will include this and a lot more. memcache / redis and APC detection and caching, form validation and reporting.

[KProjects]

Awesome - glad to see you are still actively developing this!

[GamerPerfection]

Good work!

[GamerPerfection]

I just had a new user sign up using the IP 173.213.108.208. Looking at it on stopforumspam there are 13 entries for it in Feb and Mar yet the registration was allowed???

[khronos_group]

I've noticed that a lot of the users registering on our forums have banned IP addresses on stopforumspam. About 2/3rds of the signups are now successfully getting banned, but I would estimate that more like 4/5ths of the signups should be banned. The most recent IP address allowed to signup is 199.87.229.22. Its in the stopforumspam database several times, including 5 days ago.

Is there an adjustment I need to make to ensure that all IP addresses that appear in the stopforumspam database get banned from signing up on our forums?

Suggestions are welcome. We are running the latest 4.2 install of VB.

Thank you.

[GamerPerfection]

This mod is breaking. It's letting registrations through when IPs and emails are listed on the StopForumSpam database.

[khronos_group]

We since switched to Glowhost Spam-o-matic. It also uses the stopforumspam db, and works with registration, posts and much more. We are on 4.2.x

[MagiKelly]

This mod is breaking. It's letting registrations through when IPs and emails are listed on the StopForumSpam database.

Are you sure they are not being added to the database after they have registered with your forum but before you check? If you are one of the first forum you start on this can be the case.

[GamerPerfection]

Are you sure they are not being added to the database after they have registered with your forum but before you check? If you are one of the first forum you start on this can be the case.I am sure. There were a couple of instances where it was added to the database approx 5 days before registering on my site.

It's only happened on two occasions in the past few weeks and all the others are getting blocked. I just find it odd that these two have got through.

[GamerPerfection]

I have Query Connection Errors set to Block Registration.

And I didn't say mine wasn't working properly, but some odd ones are getting through.

See this for example:

AssassinKn 2012-07-23 08:31:09 a.r.m.a.v.ir.75.643@gmail.com 46.118.123.98 Result on field ip - 46.118.123.98 - Spammer and rejected by policy
Objelssef 2012-07-23 08:27:38 lesliewalshe1982@yahoo.com 1.161.155.243 Result on field ip - 1.161.155.243 - Spammer and rejected by policy
LawerenceA 2012-07-23 05:30:28 Thresawcfdooasqx@hotmail.com 94.46.240.203 Allowed registration
jeawncini 2012-07-23 05:26:42 sff8a5aeses@gmail.com 91.236.74.194 Result on field ip - 91.236.74.194 - Spammer and rejected by policy
Dersalure 2012-07-22 22:28:26 intensityasdz@gmail.com 117.26.202.173 Result on field ip - 117.26.202.173 - Spammer and rejected by policy

[datoneer]

Tagged!

[jancarlo]

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Thursday, August 30th 2012 @ 10:22:05 PM
Error Date : Thursday, August 30th 2012 @ 10:22:05 PM
Script : http://++++++++.++++.com/admincp/plugin.php?do=productimport
Referrer : http://++++++++.++++.com/admincp/plugin.php?do=productadd
IP Address : ++.+++.++.+
Username : ++++++++ ++++++++
Classname : vB_++++++++
MySQL Version : 5.5.23-55

I vBulletin: (vBulletin 4.2.0 Patch Level 2) ... help me? thanks

[jacksonweb]

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Thursday, August 30th 2012 @ 10:22:05 PM
Error Date : Thursday, August 30th 2012 @ 10:22:05 PM
Script : http://++++++++.++++.com/admincp/plugin.php?do=productimport
Referrer : http://++++++++.++++.com/admincp/plugin.php?do=productadd
IP Address : ++.+++.++.+
Username : ++++++++ ++++++++
Classname : vB_++++++++
MySQL Version : 5.5.23-55

I vBulletin: (vBulletin 4.2.0 Patch Level 2) ... help me? thanks

open the product xml and change TYPE to ENGINE save and import again

[Gecuba]

...but some odd ones are getting through.I have had the same problem when intalled spamomatic instead of stopforumspam. As a result - 1-2 allowed spammer registrations per day :mad: and 10-15 rejected... I just tired of spammer-hunting and istalled keycaptcha plug-in. And now I have a crystal-clear log of registrations in logs - real only.

[warlord0]

Liking this so far. So annoyed lately with the amount of spammers. vb is binning them as duplicate ips for existing banned accounts, but I'd really rather they didn't even get registered. So this is very useful.

[warlord0]

Hmm, ok some oddness

ferrywoop 2012-09-03 23:05:15 ferrywoop@hotmail.co.uk 90.216.10.165 Allowed registration
ferrywoop 2012-09-03 23:04:34 ferrywoop@hotmail.co.uk 90.216.10.165 Allowed registration
ferrywoop 2012-09-03 23:03:38 ferrywoop@hotmail.co.uk 90.216.10.165 Allowed registration

But ferrywoop isn't a registered user.

[Snowhog]

I like the idea of this MOD, and I want to install it. I am however, not well versed in vBulletin, even though I am an Administrator on our Forum.

Your Install instructions say to upload the contents of the Upload folder to the 'root of your server'. I'll beg indulgence and plead ignorance, but what is the root of our server??

Our Forum is installed on /srv/www/kubuntuforums.net/public_html

"Be kind to newbie Admins"

[Sage Knight]

I like the idea of this MOD, and I want to install it. I am however, not well versed in vBulletin, even though I am an Administrator on our Forum.

Your Install instructions say to upload the contents of the Upload folder to the 'root of your server'. I'll beg indulgence and plead ignorance, but what is the root of our server??

Our Forum is installed on /srv/www/kubuntuforums.net/public_html

"Be kind to newbie Admins"

That is the root mate (public html)

Just copy and paste the whole folder. And make sure to test things first on your test board before going live with it :)

[Snowhog]

That is the root mate (public html)
Thank you. Much appreciated.

Added:
Can I simply upload the vbstopforumspam.php file to the admincp folder, and the cpnav_vbstopforumspam.xml to the includes/xml folder and then add/import products and select the product-vbstopforumspam.xml file, or do both .xml files need to be imported?

[Ohmer]

The site Stopforumspam is not working. It's getting an internal error? Hope it comes back up.

[Arie]

Looking at my logs, they have been down since 19:30 CT, so over 6 hours :(

I got 17 spam registrations and 3 valid ones. I hope they get back online fast.

[Sage Knight]

Thank you. Much appreciated.

Added:
Can I simply upload the vbstopforumspam.php file to the admincp folder, and the cpnav_vbstopforumspam.xml to the includes/xml folder and then add/import products and select the product-vbstopforumspam.xml file, or do both .xml files need to be imported?

I'm on a iPad right now so can't say for sure what are the exact files or comfirm yours, just make sure to keep the directory structure intact, if you're using fille zilla you shouldn't have any issues uploading and maintaing structure.

After uploading the files just install the addon by importing the xml, like you do with any addon.

Only the install file needs to be imported, leave the other xmls in their proper folder as it is.

[hoplomachus]

Just got home to find out that our site has stopped getting memberships due to the website being down ... I also hope this is sorted fast.

[rickm]

Just got home to find out that our site has stopped getting memberships due to the website being down ... I also hope this is sorted fast.

Has been almost a months since this last update


Was this ever corrected?

Does everything seem to be working well?

[bzcomputers]

It was down for about 12 hours about a month ago. They have made changes to the backend of their system so that the issue that caused the extended downtime should not happen again. There hasn't been any issues since.

You can read about it on their web site if you want further details.
http://www.stopforumspam.com

[tambo]

What's the situation on v0.7?

Both this mod and Spam-O-Matic lack a whitelist. The author of Spam-O-Matic has stated that they don't see a need for it (despite tonnes of requests for it to be developed).

Is there any chance that the 0.7 version of this mod (in which whitelist was indicated would be included) will ever make a public release, or has the development ground to a halt?

[djbaxter]

What would be the purpose of a whitelist?

[tambo]

Based on testing that I've done with this and other boards, the false-positive rate is a little too high (somewhere in the region of 20-25% of all flagged email/IPs). These figures were ascertained by conducting a cohort study where we tested people's IPs/emails and allowed them to register anyway, extracted the logfile, then followed them to see if they were ultimately banned for spamming. Obviously, your mileage may vary according to your users, but that is our experience.

If we implemented this mod on a reasonably busy board (100-150 registrations per day), we would expect to have a significant number of genuine people denied registration to our site. While the benefits may lead some to conclude that it's a sacrifice worth making, I'm a little less willing to break more eggs than necessary when making this omelette.

As a matter of good 'customer service', we would be prepared to whitelist IPs and emails from people who got in contact with us, then instruct them to try again.

I realise that others have suggested manually creating user accounts for people who fail the SFS check, but on a busy board that would eat up any labour-saving efficiencies that this mod brings. It's also impractical to be disabling and re-enabling the mod to permit people to get through.

I'm not the only one asking for this, which leads me to believe that either we're all misunderstanding the nature of the mod or that we're all seeing a fairly obvious gap - as did the original author when coding for v0.7.

[TheSupportForum]

Based on testing that I've done with this and other boards, the false-positive rate is a little too high (somewhere in the region of 20-25% of all flagged email/IPs). These figures were ascertained by conducting a cohort study where we tested people's IPs/emails and allowed them to register anyway, extracted the logfile, then followed them to see if they were ultimately banned for spamming. Obviously, your mileage may vary according to your users, but that is our experience.

If we implemented this mod on a reasonably busy board (100-150 registrations per day), we would expect to have a significant number of genuine people denied registration to our site. While the benefits may lead some to conclude that it's a sacrifice worth making, I'm a little less willing to break more eggs than necessary when making this omelette.

As a matter of good 'customer service', we would be prepared to whitelist IPs and emails from people who got in contact with us, then instruct them to try again.

I realise that others have suggested manually creating user accounts for people who fail the SFS check, but on a busy board that would eat up any labour-saving efficiencies that this mod brings. It's also impractical to be disabling and re-enabling the mod to permit people to get through.

I'm not the only one asking for this, which leads me to believe that either we're all misunderstanding the nature of the mod or that we're all seeing a fairly obvious gap - as did the original author when coding for v0.7.

the problem is if you think there are false positives, then report them to their DNSBL provider, the IP address can be removed but it takes 24hr to propagate for removal
this mod is not responsible for the false positives, its the users reporting them to SFS

[ShannonA]

Turned this on yesterday and it's blocked over 15,000 registrations in something less than 24 hours. (I assume many of these would have been blocked already with our human verification options, but many would have gotten through too, so this is a big plus.)

However, we've also had one real user (presumably) mail us saying he couldn't create an account. So what do you do to get a real user access?

[TheSupportForum]

Turned this on yesterday and it's blocked over 15,000 registrations in something less than 24 hours. (I assume many of these would have been blocked already with our human verification options, but many would have gotten through too, so this is a big plus.)

However, we've also had one real user (presumably) mail us saying he couldn't create an account. So what do you do to get a real user access?

its easy to get their IP removed, first of all i can help you with that PM me and i'll send you details on how to get his IP unblocked

[ShannonA]

Great! Will do. (I'm currently waiting to get info on who he is back, so I can correlate that with the blocking info in the log.)

[Ski4People]

Turned this on yesterday and it's blocked over 15,000 registrations in something less than 24 hours. (I assume many of these would have been blocked already with our human verification options, but many would have gotten through too, so this is a big plus.)

However, we've also had one real user (presumably) mail us saying he couldn't create an account. So what do you do to get a real user access?

I think you should use just the IP and email check, no username check, it works for me

[djbaxter]

I think you should use just the IP and email check, no username check, it works for me

Yes. You will get a LOT of false positives if you enable name check.

[GamerPerfection]

I agree, only use IP and email check. never use username check.

[ShannonA]

Well, things worked great for a bit less than 4 days, then I started getting:

Result on field email - XXXX@gmail.com [REMOTEERR] Unverfied but allowed by policy

And all the spam is flooding in again. What happened!?

[TheSupportForum]

Well, things worked great for a bit less than 4 days, then I started getting:

And all the spam is flooding in again. What happened!?

you need to update the api address from stopforumspam.com to api.stopforumspam.com the aapi is no longer updated from stopforumspam.com

[ShannonA]

Do you mean in the Options page for the add-on? api.stopforumspam.com doesn't seem to exist.

[djbaxter]

Well, things worked great for a bit less than 4 days, then I started getting:

And all the spam is flooding in again. What happened!?

That means you were unable to connect with the SFS database at the time. It may have been down temporarily or undergoing maintenance - this happens from time to time.

you need to update the api address from stopforumspam.com to api.stopforumspam.com the aapi is no longer updated from stopforumspam.com

The original seems to be working just fine for me.

[Ski4People]

you need to update the api address from stopforumspam.com to api.stopforumspam.com the aapi is no longer updated from stopforumspam.com

Mine is not having any problem, and I didn't update any API...

[TheSupportForum]

Do you mean in the Options page for the add-on? api.stopforumspam.com doesn't seem to exist.

please read
http://www.stopforumspam.com/forum/viewtopic.php?id=4653

it clearly states they migrated to api.stopforumspam.org in 2012
sorry i did put .com before

[ShannonA]

Huh. I seem to be getting "rate limit exceeded". I guess they're not actually reliable for a large forum.

[TheSupportForum]

Mine is not having any problem, and I didn't update any API...

read this post
http://www.stopforumspam.com/forum/viewtopic.php?id=4653

[djbaxter]

Well, things worked great for a bit less than 4 days, then I started getting:

And all the spam is flooding in again. What happened!?

you need to update the api address from stopforumspam.com to api.stopforumspam.com the aapi is no longer updated from stopforumspam.com

read this post
http://www.stopforumspam.com/forum/viewtopic.php?id=4653


That doesn't tell me much and looking further into the SFS forum seems to imply that the api is for SUBMITTING spam data rather than checking existing entries in the database?

[TheSupportForum]

That doesn't tell me much and looking further into the SFS forum seems to imply that the api is for SUBMITTING spam data rather than checking existing entries in the database?

the plugin does that, as long as you update the api link to submit it will work alot better, and this version isnt as reliable as glowhosts version which this developer did contribute work towards developing which is designed to look at the api once they attempted to register

[djbaxter]

the plugin does that, as long as you update the api link to submit it will work alot better, and this version isnt as reliable as glowhosts version which this developer did contribute work towards developing which is designed to look at the api once they attempted to register

Actually, I was using Glowhost and came back to this one because this one works better for me.

[ShannonA]

Huh. I seem to be getting "rate limit exceeded". I guess they're not actually reliable for a large forum.

Turns out that this is a feature:
http://www.stopforumspam.com/forum/viewtopic.php?id=573&p=1

I've queried the folks running the site, since as far as I know we were making pretty normative use of things for a large site (albeit under a particular spam attack this morning).

[TheSupportForum]

i currently have a script i developed which i can integrate this into its
Re-usable Code so it fits nicely with my newest mod which automatically blocks site access and registration attempts, i have already implemented projecthoneypot with it

[ShannonA]

The folks at SFS report that one of the problems I'm hitting is that vBSFS tries to get info on blank email addresses:

2840 /api?email=

Could this be addressed in a future update?

[TheSupportForum]

The folks at SFS report that one of the problems I'm hitting is that vBSFS tries to get info on blank email addresses:

Could this be addressed in a future update?

that's due to the wrong variable, it might not be registered in the php file correctly
but if i integrate this script into mine i will fix issues like this

justing looking at it, its not even used properly

it should be api?email=$email

[ShannonA]

Based on the logs, the emails and user names getting reported seem really flaky. Lots of repeats and those blank emails. This is how they're accessed in the code:

$username = $vbulletin->userinfo['username'];
$email = $vbulletin->GPC['email'];

Have they changed by vb4.2?

Edit: That's called in register_addmember_process

[TheSupportForum]

Based on the logs, the emails and user names getting reported seem really flaky. Lots of repeats and those blank emails. This is how they're accessed in the code:

Have they changed by vb4.2?

Edit: That's called in register_addmember_process

you need to call the php variable for email which is $email

where is says

Remote URL to the www.StopSpamLinks.com website for testing an email address


you replace :
http://www.stopforumspam.com/api?email=
with
http://www.stopforumspam.com/api?email=$email

[ShannonA]

you replace :
http://www.stopforumspam.com/api?email=
with
http://www.stopforumspam.com/api?email=$email

Maybe I'm misunderstanding you, but the code certainly seems to add the email address all on its own:


$spambot = getSFSXML($vbulletin->options['vbstopforumspam_url_check_' . $field] . urlencode($data));


In this example, $field would be email and $data would be $email.

The problem is that sfsProcess() seems to be getting really weird results from the two variables I noted:

$username = $vbulletin->userinfo['username'];
$email = $vbulletin->GPC['email'];

Including blanks for $email, or at least that's what it's logging.

[ShannonA]

It looks to me like all those variables are set right and being passed right, but the problem is that vbStopForumSpam sends out those requests even before the spammer has been let in to register. Thus, if they haven't set an email and would be rejected, it checks their email anyway. If they fail at the human question, it checks anyway, sometimes again and again ...

[TheSupportForum]

Maybe I'm misunderstanding you, but the code certainly seems to add the email address all on its own:



In this example, $field would be email and $data would be $email.

The problem is that sfsProcess() seems to be getting really weird results from the two variables I noted:

Including blanks for $email, or at least that's what it's logging.

change



global $vbulletin, $userdata;

$ip = $vbulletin->session->vars['host'];
$username = $vbulletin->userinfo['username'];
$email = $vbulletin->GPC['email'];
if (($email == '') && (isset($userdata))) { // hook for new FB Connect procedures
$username = $userdata->fetch_field('username');
$email = $userdata->fetch_field('email');
}

$message = ' GPC_user: '.$vbulletin->GPC['username'].' GPC_email: '.$vbulletin->GPC['email'];
$message .= ' Data_user: '.$userdata->fetch_field('username').' Data_email:'.$userdata->fetch_field('email');
$message .= ' Info_user: '.$vbulletin->userinfo['username'].' Info_email: '.$vbulletin->userinfo['email'];
$message .= ' REQ_username: '.$_REQUEST['username'].' REQ_email: '.$_REQUEST['email'];

if (($username != '') && ($username != 'Unregistered')) { //disable check if not set
$result = VBSFSSpam($username, 'username');
if ($result !== VBSFS_NO_TEST) {
VBGHSFS_Action('username', $username, $username, $email, $ip, $result);
}
}

if ($email != '') { //disable check if not set
$result = VBSFSSpam($email, 'email');
if ($result !== VBGHSFS_NO_TEST) {
VBGHSFS_Action ('email', $email, $username, $email, $ip, $result);
}
}

$result = VBSFSSpam($ip, 'ip');
if ($result !== VBSFS_NO_TEST) {
VBGHSFS_Action('ip', $ip, $username, $email, $ip, $result);
}

[TheSupportForum]

Maybe I'm misunderstanding you, but the code certainly seems to add the email address all on its own:



In this example, $field would be email and $data would be $email.

The problem is that sfsProcess() seems to be getting really weird results from the two variables I noted:

Including blanks for $email, or at least that's what it's logging.


change


global $vbulletin;

$ip = $vbulletin->session->vars['host'];
$username = $vbulletin->userinfo['username'];
$email = $vbulletin->GPC['email'];

// todo handle the null error results.
$result = checkSFSSpam($username, 'username');
if ($result !== VBSFS_NO_TEST) {
sfsActions('username', $username, $username, $email,$ip, $result);
}

$result = checkSFSSpam($ip, 'ip');
if ($result !== VBSFS_NO_TEST) {
sfsActions('ip', $ip, $username, $email, $ip, $result);
}

$result = checkSFSSpam($email, 'email');
if ($result !== VBSFS_NO_TEST) {
sfsActions ('email', $email, $username, $email, $ip, $result);
}
to



global $vbulletin, $userdata;

$ip = $vbulletin->session->vars['host'];
$username = $vbulletin->userinfo['username'];
$email = $vbulletin->GPC['email'];
if (($email == '') && (isset($userdata))) { // hook for new FB Connect procedures
$username = $userdata->fetch_field('username');
$email = $userdata->fetch_field('email');
}

$message = ' GPC_user: '.$vbulletin->GPC['username'].' GPC_email: '.$vbulletin->GPC['email'];
$message .= ' Data_user: '.$userdata->fetch_field('username').' Data_email:'.$userdata->fetch_field('email');
$message .= ' Info_user: '.$vbulletin->userinfo['username'].' Info_email: '.$vbulletin->userinfo['email'];
$message .= ' REQ_username: '.$_REQUEST['username'].' REQ_email: '.$_REQUEST['email'];

if (($username != '') && ($username != 'Unregistered')) { //disable check if not set
$result = VBSFSSpam($username, 'username');
if ($result !== VBSFS_NO_TEST) {
sfsActions ('username', $username, $username, $email, $ip, $result);
}
}

if ($email != '') { //disable check if not set
$result = VBSFSSpam($email, 'email');
if ($result !== VBGHSFS_NO_TEST) {
sfsActions ('email', $email, $username, $email, $ip, $result);
}
}

$result = VBSFSSpam($ip, 'ip');
if ($result !== VBSFS_NO_TEST) {
sfsActions ('ip', $ip, $username, $email, $ip, $result);
}

[ShannonA]

Thanks. Running an updated version now ...

[deadlySniper]

Looks like the site is down.....

[djbaxter]

Looks like the site is down.....

Yes... for me too.

[AliMadkour]

Yes... for me too.


I think that's temporarily

[djbaxter]

I think that's temporarily

Oh of course... I assume that's the case.

[fabs23]

Looks like the site is down.....

Hi,

I'm thinking about installing this addon too. What happens in this case http://api.stopforumspam.org is down? Is the registration process on my site still working or is it reliant on the availability of the api?

Thanks for replies
fabs

[Ski4People]

Hi,

I'm thinking about installing this addon too. What happens in this case http://api.stopforumspam.org is down? Is the registration process on my site still working or is it reliant on the availability of the api?

Thanks for replies
fabs

There's an option "Query Connection Errors" with two settings: Allow registration and Block registration, I think this is what you need, but it's rare that the site is down.

[fabs23]

Hi LukeNet,

thanks for that instant answer.

fabs

[Ski4People]

Hi LukeNet,

thanks for that instant answer.

fabs

In my opinion this is a great plugin, it blocks (for my site) from about 60 to 100 spammers registration in a day, but remember, to prevent false positives, to disable "Test User name" and keep just "Test IP address" and "Test Email Address" enabled!

[TheSupportForum]

Hi,

I'm thinking about installing this addon too. What happens in this case http://api.stopforumspam.org is down? Is the registration process on my site still working or is it reliant on the availability of the api?

Thanks for replies
fabs

http://api.stopforumspam.org is not default for this script, you will need to update the string yourself
otherwise it points to http://stopforumspam.com which is their old API

[fabs23]

..., but remember, to prevent false positives, to disable "Test User name" and keep just "Test IP address" and "Test Email Address" enabled!
http://api.stopforumspam.org is not default for this script, you will need to update the string yourself
otherwise it points to http://stopforumspam.com which is their old API

Hey,

I already changed these options after reading your previous comments. =) But thanks for the advices though.

fabs

[tambo]

http://api.stopforumspam.org is not default for this script, you will need to update the string yourself
otherwise it points to http://stopforumspam.com which is their old API
What's the difference, in terms of how the plugin works?

Sorry if that's a remedial question. :D

[TheSupportForum]

What's the difference, in terms of how the plugin works?

Sorry if that's a remedial question. :D

their new API location had been migrated for load balancing, it includes more up-to-date a DNSBL list

[tambo]

Ah, OK. Will look into editing the string. Cheers.

[djbaxter]

their new API location had been migrated for load balancing, it includes more up-to-date a DNSBL list

Please point me to where at the SFS site it states this; I have been unable to find any such statement.

The old URLs work just fine for me. Additionally, the submission form at the SFS site is still located at http://www.stopforumspam.com/add

From http://www.stopforumspam.com/usage

Examples

http://www.stopforumspam.com/api?ip=91.186.18.61
http://www.stopforumspam.com/api?email=g2fsehis5e@mail.ru
http://www.stopforumspam.com/api?username=MariFoogwoogy


Multiple queries

Queries for some or all fields can be made in a single query, as here

http://www.stopforumspam.com/api?ip=91.186.18.61&email=g2fsehis5e@mail.ru

[TheSupportForum]

Please point me to where at the SFS site it states this; I have been unable to find any such statement.

The old URLs work just fine for me. Additionally, the submission form at the SFS site is still located at http://www.stopforumspam.com/add

i have already linked it to another person in a few posts back, not sure which one it is but the link is there

[djbaxter]

I posted this at the SFS forum (http://www.stopforumspam.com/forum/viewtopic.php?pid=33712#p33712) just now:

Can you clarify the status of the alternate URLs for checking and/or adding spammers to your database? I have seen posts at vBulletin.org in particular indicating that stopforumspam.com is obsolete and or that api.stopforumspam.org is more up to date.

What is the recommended URL to use

1. for checking a new registration against the database; and

2. for submitting a spammer to the database?


Here is pedigree's reply:

At the moment, they point to the same box but I hope to move the lot to api.stopforumspam.org in the near future. I have issues to iron out with DNS failover, balancing etc. You can use either but I cant 100% guarantee the road map going forward until i get these issues sorted out.

[TheSupportForum]

I posted this at the SFS forum (http://www.stopforumspam.com/forum/viewtopic.php?pid=33712#p33712) just now:



Here is pedigree's reply:

in many cases the new link has never broke, not 1 has passed

[djbaxter]

in many cases the new link has never broke, not 1 has passed

And I can verify that the same is true for the original link.

And pedigree's reply is quite clear: Both URLs point to exactly the same location. So telling people who are having problems that the fix is to change the URL is misleading at best - that won't change anything or fix any problems they may be experiencing.

In particular, your statement that the stopforumspam.org database is more up to date is clearly not true.

[TheSupportForum]

And I can verify that the same is true for the original link.

And pedigree's reply is quite clear: Both URLs point to exactly the same location. So telling people who are having problems that the fix is to change the URL is misleading at best - that won't change anything or fix any problems they may be experiencing.

In particular, your statement that the stopforumspam.org database is more up to date is clearly not true.

i have only had lets say 10 pass with that
but i can say that it has been more reliable for me

if people has been taking notice of posts here and on their forum then yes it would be more up to date

[djbaxter]

i have only had lets say 10 pass with that
but i can say that it has been more reliable for me

if people has been taking notice of posts here and on their forum then yes it would be more up to date

Sorry but that is simply not true and cannot be true. Please re-read pedigree's statement this morning:

http://www.stopforumspam.com/forum/viewtopic.php?pid=33712#p33712

At the moment, they {i.e., both URLs} point to the same box

[TheSupportForum]

Sorry but that is simply not true and cannot be true. Please re-read pedigree's statement this morning:

http://www.stopforumspam.com/forum/viewtopic.php?pid=33712#p33712

the point i am making is that api.stopforumspam.org url has not been down for me
whilst many report stopforumspam.com being down, the other is still active
so its more reliable

[djbaxter]

the point i am making is that api.stopforumspam.org url has not been down for me
whilst many report stopforumspam.com being down, the other is still active
so its more reliable

*sigh* No it's not.

[TheSupportForum]

*sigh* No it's not.how you timestamp

please read posts, many say that stopforumsspam.com api is down alot
when i check my logs i find that the api from, api. ******* . org
is still working and blocking spammers

i could show you timestamps / screenshots where people say its down and let people register, which the logs will report if it allows reg if down

as i said i havent had 1 issue with that url for the api

[djbaxter]

how you timestamp

please read posts, many say that stopforumsspam.com api is down alot
when i check my logs i find that the api from, api. ******* . org
is still working and blocking spammers

i could show you timestamps / screenshots where people say its down and let people register, which the logs will report if it allows reg if down

as i said i havent had 1 issue with that url for the api

And I have no issues with the other URL. And, for at least the third time, pedigree has stated that BOTH URLs GO TO THE SAME PLACE... same server, same site, same database.

Just because a URL is inaccessible from one geographical location or IPS does not mean that others can't reach it. That's the nature of DNS.

[Alfa1]

Please add a function to recheck accounts later if the SFS is down.

[djbaxter]

Please add a function to recheck accounts later if the SFS is down.

That seems rather impractical to me. What do you do with new registrations in the meantime? Keep them on hold? I certainly would never enable a feature like that.

[MagiKelly]

There was talk of this being updated to check the stopforumspam database again when they went to make their first post. It is often the case that spammers sign up to forums but wait a few days or weeks before starting the posting and by then they may be on the database if they were not before.

[lamur]

Sorry if this has been asked, but I can't find it. I'm on VB 4.2.x and when I go to upload this script I get this error:
***************

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Friday, November 16th 2012 @ 10:20:14 PM
Error Date : Friday, November 16th 2012 @ 10:20:14 PM
Script : http://xxx.xxx/plugin.php?do=productimport
Referrer : http://xxx.xx/plugin.php?do=productadd
IP Address : xx.xxxx.xx.xx
Username : ******mine***
Classname : vB_Database
MySQL Version : 5.5.27-cll

[GlowHost.com]

Yep it has been asked before. A lot actually.

Try this:

https://vborg.vbsupport.ru/showthread.php?p=2361418&highlight=TYPE%3DMyISAM#post2361418

[Bob_R]

There used to be something in my user manager to check users. Some sort of box to submit the name, ip, and email address to vbforumstopspam database.

I don't see it there anymore. Any ideas why?

thanks!!

[djbaxter]

There used to be something in my user manager to check users. Some sort of box to submit the name, ip, and email address to vbforumstopspam database.

I don't see it there anymore. Any ideas why?

thanks!!

I can no longer recall the source either but here's what I have, adapted for vBulletin 4.x (up to and including 4.2.0 PL3).

1. You'll need an SFS API key. Replace "1234567890abcd" in last line below with valid API.

2., AdminCP >> Plugins and Products >> Add New Plugin

3. Details for plugin

Product: vBulletin

Hook Location: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution Order: 5

Plugin PHP Code:


if (!is_member_of($user['usergroupid'], 6)) // dont ban admin account
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="1234567890abcd"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}

[Bob_R]

I can no longer recall the source either but here's what I have, adapted for vBulletin 4.x (up to and including 4.2.0 PL3).

1. You'll need an SFS API key. Replace "1234567890abcd" in last line below with valid API.

2., AdminCP >> Plugins and Products >> Add New Plugin

3. Details for plugin

Product: vBulletin

Hook Location: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution Order: 5

Plugin PHP Code:


if (!is_member_of($user['usergroupid'], 6)) // dont ban admin account
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="1234567890abcd"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}



Thanks!! :up:

[Adem GEN?]

Turkish language files

[datoneer]

Thanks great mod

[Montagar]

We have a number of registrations blocked with the following reason being given:

"Result on field username - Unregistered - Spammer and rejected by policy"

The user name listed is being attempted to register is "Unregistered".

These people are not trying to register with a user name of "Unregistered". Does anyone know what is causing this? I saw that this question was asked previously, but no answer was ever given as to the cause. Thanks.

[nhtourguide]

Does anyone know if this works on 4.1.1?

Also does it help with ddos attacks?

[DAMINK]

Any way we could get this mod to write the logs to a thread?
Perhaps daily or something??

[mykkal]

Great mod.... I recently had to switch to Spam O Matic because that mod also moderates phrases. Is it possible this plugin could offer that capability as well?

[fworth]

Awesome mod!

[GamerPerfection]

I'm testing out Google PageSpeed service to see what affect it has on speed on my site. I've had it running for a few days now, and I just noticed from a new member that joined my forum that they are coming from a Google IP because of the PageSpeed service, and therefore this made me realise that all my members, including myself are coming from similar Google IPs.

This has concerned me now that if everyone is coming from a Google IP that the StopForumSpam won't see their true IP and therefore will let all registrations through?

Does anyone have experience of this using Google PageSpeed Service and Spam Protection?

[mykkal]

I'm testing out Google PageSpeed service to see what affect it has on speed on my site. I've had it running for a few days now, and I just noticed from a new member that joined my forum that they are coming from a Google IP...

Hey how is it that the IPs are coming from Google? Why isn't your local public IP showing? I don't understand that at all.

[the1rabbits]

I have had problems with Spam O MAtic lately. Does this mod essentially do the same thing?

[djbaxter]

I have had problems with Spam O MAtic lately. Does this mod essentially do the same thing?

Yes but without and the bells and whistles that have created problems with Spam-o-Matic. I started with this mod, changed to Spam-o-Matic, and then switched back to this one.

[ikorolis]

i have installed Stop Forum Spam and still using without problems to see have it Spam O Matic

[fpiccioli]

i have this problem..... help me pls

Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4 in [path]/includes/class_core.php on line 1391

[ikorolis]

i have this problem..... help me pls

Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4 in [path]/includes/class_core.php on line 1391

check this maybe help you.

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

[fpiccioli]

thx m8 i have resolved my problem with spam-0-matic

[joe1989]

How do I submit data to the database? I have created an API and entered it in the appropriate location. Just not sure what to do now with my spammer data.

[djbaxter]

How do I submit data to the database? I have created an API and entered it in the appropriate location. Just not sure what to do now with my spammer data.

For vBulletin 4.x, create a new plugin:

Product: vBulletin (or vBStopForumSpam)

Hook: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution order: 5

Plugin code:

if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="YOUR API KEY HERE"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}


Insert your own API code where it says "YOUR API KEY HERE"

Plugin is Active: Yes

[joe1989]

Awesome! Thanks! Works like a charm

[jdrakopo]

Question y'all:
The instructions.txt file says to "Upload the contents of the upload folder into the root of your forums. DOnt upload the "upload" folder itself, just the contets of the upload folder."

Does that mean that *EACH* of the files in the sub-folders under 'Upload' (i.e., admincp, includes) should get dropped right into the root folder ? --> /public_html/staging/forums

Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes

I tried both but got 'Invalid File Specified' when I clicked 'Import' in the 'Import Product' admincp screen.

THANKS !
PS - I'm using VB 4.1.9

[bzcomputers]

Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes



It means the above.

[jdrakopo]

Thanks.
This is the error I'm receiving (below)
I must be missing something simple ?

- - -
Database error in vBulletin 4.1.9:
Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Sunday, June 30th 2013 @ 05:24:53 AM
Error Date : Sunday, June 30th 2013 @ 05:24:53 AM
Script : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productimport
Referrer : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productadd
IP Address : xxx.xx.xxx.xxx

[jdrakopo]

hey - can anybody help out here ?
Thanks.

[Jakeman]

Try finding that CREATE TABLE query in the files and change:

TYPE=MyISAM

...to:

ENGINE=MyISAM

[Rob Graves]

I am getting the exact same error:

Database error in vBulletin 4.1.12:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
Error Number : 1064
Request Date : Sunday, July 7th 2013 @ 11:00:39 PM
Error Date : Sunday, July 7th 2013 @ 11:00:39 PM

SQL version is 5.5.23-55

[Rob Graves]

Engine did it - thanks man!

[Rob Graves]

A big thanks - 133 spammers were stopped just last night!

[jdrakopo]

Yeah - big thanks to jakeman on this.

I certainly would not have picked up on the need to change TYPE to ENGINE.
Is this an issue that needs to get addressed in the next ver of this module ?

[Bernd Glasstett]

It seems, that version 0.61 doesn't work with vBulletin 4.1.11. Is there a way to get an older version, which works with that version of vBulletin 4.1?

[gsk8]

It doesn't appear to work on 4.2.1 either...

[hmdyilmaz]

It doesn't appear to work on 4.2.1 either...

Yea, Thats right.

it was my post in somewhere else :

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

[hmdyilmaz]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum...=1376921314163

[hmdyilmaz]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum...=1376921314163

upp

[hmdyilmaz]

upp

Nobody knows how to do ? :(

[ozzy47]

Have you tried registering and see if you can?

[hmdyilmaz]

Have you tried registering and see if you can?

Yea I have tried to register. But it doesnt work anymore. Nobody registered again
if I remove that file in the forum, I can register again.

:(

[hmdyilmaz]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/3989658-after-added-vbstopforumspam-v0-61-zip-and-now-not-registering-anymore?_=1376910640216&_=1376915177123&_=1376917492245&_=1376921314163

https://vborg.vbsupport.ru/showthread.php?p=2439738#post2439738

[TheLastSuperman]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/3989658-after-added-vbstopforumspam-v0-61-zip-and-now-not-registering-anymore?_=1376910640216&_=1376915177123&_=1376917492245&_=1376921314163

https://vborg.vbsupport.ru/showthread.php?p=2439738#post2439738

Hmm without access its hard to tell however... try this stop forum spam mod - https://vborg.vbsupport.ru/showthread.php?t=239307 then reply back here and let us know it the other mod works, if so we can surely then say it was this mod conflicting with something else on your site. That's a quick way to test imo.

[stevether]

4.2.1 here, doesn't seem to be working. Everything is showing up as a remote error, though the API is up at the time of the request.

https://vborg.vbsupport.ru/external/2013/09/67.png

[hmdyilmaz]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

[djbaxter]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/3989658-after-added-vbstopforumspam-v0-61-zip-and-now-not-registering-anymore?_=1376910640216&_=1376915177123&_=1376917492245&_=1376921314163

https://vborg.vbsupport.ru/showthread.php?p=2439738#post2439738

Hmm without access its hard to tell however... try this stop forum spam mod - https://vborg.vbsupport.ru/showthread.php?t=239307 then reply back here and let us know it the other mod works, if so we can surely then say it was this mod conflicting with something else on your site. That's a quick way to test imo.

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

Try reading the reply you received above before re-posting the question.

[djbaxter]

Since upgrading to vBulletin 4.2.2 and then PHP 5.4.20, I'm getting errors like this:

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

Similar errors are being reported for the Glowhost version, where the response was this:

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

But it's not that simple. The "gone away" error is, I think, 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 (https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=vbstopforumspam4) and I don't recall such an option for the Glowhost mod either (I found it to be overkill for my needs so I reverted to the simpler version).

[djbaxter]

Try this - don't know if it will make any difference but see if it does:

Find in functions_vbsfs.php:

[REMOTEERR]

Change to:

REMOTEERR

i.e., remove the square brackets.

No idea if this is creating a problem or not but try it.

I'm also working on some other strategies for tracking this down.

[BlueScion]

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

[djbaxter]

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

[BlueScion]

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

Oh ok. :)

[stemmy]

im getting db errors on install. Any fix for this.

[webmastersitesi]

im getting db errors on install. Any fix for this.

me too ?

[Itworx4me]

im getting db errors on install. Any fix for this.

me too ?

Open up product-vbstopforumspam.xml

Replace TYPE with ENGINE on line 22, 35, 45


Hope this helps.....

Itworx4me

[webmastersitesi]

Open up product-vbstopforumspam.xml

Replace TYPE with ENGINE on line 22, 35, 45


Hope this helps.....

Itworx4me

thx i :up::up:was able to import :)

[gregmlb]

Is anyone using this successfully with 4.2.2 PL1?

[Montagar]

Is anyone using this successfully with 4.2.2 PL1?
Yes, works fine for us.

[djbaxter]

Same here. Using it on 4 vb4.22pl1 forums.

[AusPhotography]

I can no longer recall the source either but here's what I have, adapted for vBulletin 4.x (up to and including 4.2.0 PL3).


I've updated this into a plugin, and fixed it for PHP 5.4 support (also vB4.2.2pl1)
Upload this via Admin CP - Plugins & Products - Download / Upload Plugins

[djvj]

I'm getting tons of emails a day on this addon and some legit users are not able to register:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '176.31.149.241' , 'kyqufijuwu72@list.ru', 'CXmu', 'Result on field username - CXmu [REMOTEERR] Unverfied and rejected by policy ', 1, '74207e52630b343fb9ff43f7cdbbfece');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, June 17th 2014 @ 06:05:12 PM
Error Date : Tuesday, June 17th 2014 @ 06:07:28 PM
Script : http://www.hyperlaunch.net/forum/regist.php?do=addmember
Referrer : http://www.hyperlaunch.net/forum/regist.php?
IP Address : 176.31.149.241
Username : CXmu
Classname : vB_Database_MySQLi
MySQL Version :

It appears to be working though:
vbStopForumSpam Log Viewer (page 1/73) | There are 1,092 total log entries.

When some users try to register, they say they get a database error.

[AusPhotography]

When some users try to register, they say they get a database error.

That happens when the connection to SFS website takes longer than your MySQL connection timeout.

We reduced the CURL timeout (8 seconds I think) in the SFS plugin code to get around it.

I assume your MySQL timeout is 30 seconds which most shared hosts setup.

[djvj]

Thanks for your response AusPhotography.

So I have since uninstalled this mod for the GlowHost version and all my db/sql errors have gone away. I still get the SBS support, so I will be sticking with that plugin.

Just for reference, I did contact GoDaddy, but they would not provide details on the server's settings and said I would need to buy a VPS service at least to get access. Obviously that's not an option as the cost is far more for that vs shared hosting.

[Paul.]

I'm getting tons of emails a day on this addon and some legit users are not able to register:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '176.31.149.241' , 'kyqufijuwu72@list.ru', 'CXmu', 'Result on field username - CXmu [REMOTEERR] Unverfied and rejected by policy ', 1, '74207e52630b343fb9ff43f7cdbbfece');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, June 17th 2014 @ 06:05:12 PM
Error Date : Tuesday, June 17th 2014 @ 06:07:28 PM
Script : http://www.hyperlaunch.net/forum/regist.php?do=addmember
Referrer : http://www.hyperlaunch.net/forum/regist.php?
IP Address : 176.31.149.241
Username : CXmu
Classname : vB_Database_MySQLi
MySQL Version :

It appears to be working though:
vbStopForumSpam Log Viewer (page 1/73) | There are 1,092 total log entries.

When some users try to register, they say they get a database error.

That happens when the connection to SFS website takes longer than your MySQL connection timeout.

We reduced the CURL timeout (8 seconds I think) in the SFS plugin code to get around it.

I assume your MySQL timeout is 30 seconds which most shared hosts setup.

I get that error, too.

AusPhotography, is that a solution to the error shown?
I have emailed to get the details checked so I can use StopForumSpam.
It's working perfectly on another forum we have.
This forum is new as the previous was messed up and got deleted. It worked there, too.

[thincom2000]

Regarding the "MySQL has gone away" errors and register.php requests being tied up for 2 minutes or more...

The CURL timeout in the plugin code is 5 seconds as far as I can tell.

I think the problem is that CURL has a connection error during that 5 seconds where it can't connect to stopforumspam.com


When this happens, it is treated as a normal CURL error and falls back to file_get_contents(url), which I don't think has a timeout. file_get_contents also has trouble connecting and waits a very long time to give up (until after the MySQL link is auto-closed).

If an attacker can detect this situation on your site, they would be able to perform an attack like Slow Loris against a vBulletin forum that uses this mod. It's actually easy to "detect" this situation. SFS limits you to 20,000 API lookups per 24 hours, then blocks your IP which will also cause a CURL connection error. Using only 14 requests per minute (so not really detectable by DOS prevention), an attacker can leverage this limit and trigger file_get_contents for every registration attempt after 20,000. Since your IP is blocked, every request will wait until PHP times out. You will run out of PHP child processes, and your forum will be inaccessible. To protect yourself, you should make the following change.

In includes/functions_vbsfs.php, find and remove all of these:
if (!($pageContent = @file_get_contents($url)))

I would suggest that the author of this mod also makes this change to prevent Slow Loris attacks, or implements stream wrappers with an appropriate timeout set if support for file_get_contents(url) is still needed.

[infnity8x3]

Installed and working as expected. vb 4.2.3. Had to do the sql syntax edit as mentioned above but that was easy. Thanks.

I was using glowhost version. But that mod added way to many (at least for me) useless options and features. I really only used it for the stopforumspam module.

I am all about a minimalist approach and this mod fits the bill.

Installed.