vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations (https://vborg.vbsupport.ru/showthread.php?t=176481)

watchxchange 04-23-2012 01:30 AM

My forum suddenly stop new member registration by VBStopForumSpam. Registration resume when I temporarily turned off the Plugin. If I turn on, there are lots of spam posting on the forum.

It affects all registrations. I have tried turning on and off several times to test the registration and therefore confirmed this is the case.

What can I do? Why it happen suddenly?

Forum version: vBulletin 4.1.9 Admin Control Panel

Appreciate your advise.

edie 04-23-2012 08:32 PM

I am having the same problem. No one can register. But when I turn off Glowhost, they can register now.

I had TONS OF MALWARE on my site.. it was all over my Forum, and Google displayed that my site was "not safe". Freaks me out that you guys posted here that VBStopForumSpam is the culprit.

Anything being done about this guys?
- Super Concerned. :(

ozmazdaclub 04-30-2012 10:22 PM

how can i report a spammer directly from the product instead of manually having to go and enter their details in.

DAMINK 04-30-2012 10:32 PM

The coder has not been on since last year so i suspect this mod will be getting uninstalled on many forums.
Sucks really as its a damn good mod.

hotshot 05-28-2012 09:08 PM

Does it still work?

rob4448585 05-29-2012 12:07 AM

Quote:

Originally Posted by hotshot (Post 2334043)
Does it still work?

yes works great

cronjob78 06-12-2012 09:30 AM

A lot of genuine users are getting rejected lately so I am considering disabling this plugin, even though it has served the forum well for a few years.

Our forum is a local one so ideally I'd like to block the usual suspect countries.

pmkb 07-03-2012 03:03 PM

Quote:

Originally Posted by JamesC70 (Post 2165430)
AdminCP -> Statistics & Logs -> vbStopForumSpam Logs -> Delete

It's directly below the option where you view the SFS logs. :up:

Excellent. Anyone know if it is possible to have vB automate the log pruning? I've had this mod running for a few years now and just checked the log today to find over 100K entries.

b3zra1y 07-10-2012 04:00 AM

So.... the upshot of recent posts on this plugin suggest that it can no longer be relied on as a stable plugin.

Which begs the question... what are vBulltin customers supposed to do to keep out the 'bad guys' ???

rob4448585 07-10-2012 04:10 AM

Quote:

Originally Posted by b3zra1y (Post 2346575)
So.... the upshot of recent posts on this plugin suggest that it can no longer be relied on as a stable plugin.

Which begs the question... what are vBulltin customers supposed to do to keep out the 'bad guys' ???


Works fine for me. Haven't had an issue for years.

Barteh 07-10-2012 04:57 AM

No issues here either. Pulled the stats, and of our last 1000 reg attempts, 94.5% are obvious spammers and get rejected by vBSFS right away. Remaining regs are predominantly repeat attempts by the same two spambots tripping over my other measures. The result is that of the succesful regs that arrive in my new user moderation queue, only very few are spammers.

*EDIT*

Heh, one attempt even has "[c:\one.112233445566@gmail.com.txt,5,l]" as the email address :rolleyes:

desmomax 09-13-2012 11:34 AM

very nice mod! thanks..

i saw a pic of log file in your post.. where can i found the log file in my admincp?

rob4448585 09-13-2012 12:45 PM

Quote:

Originally Posted by desmomax (Post 2365086)
very nice mod! thanks..

i saw a pic of log file in your post.. where can i found the log file in my admincp?

https://www.sugarsync.com/piv/D9679127_69674693_6969748

desmomax 09-13-2012 01:24 PM

I cant see this voice in my log menu

desmomax 09-13-2012 02:03 PM

I followed the install instruction and the mod look like working fine but i see no log menu option.
thanks for your reply

rob4448585 09-19-2012 03:38 AM

Quote:

Originally Posted by desmomax (Post 2365111)
I followed the install instruction and the mod look like working fine but i see no log menu option.
thanks for your reply

You didn't install it correctly.

desmomax 09-19-2012 07:49 AM

yes, solved. thanx

st.charles 09-20-2012 04:44 PM

I'm trying to reinstall the vbstopforumspam mod after an upgrade from vbulletin 3.86 to 3.87.

After the upgrade, the database was throwing errors and I repaired it by removing some plugins.
vbstopforum spam was one of the plugins removed.
I reinstalled the other plugins and they're working fine.

When I go to import the new plugin after re-uploading the files correctly I get this MySQL error in the admincp backend:

Quote:

Database error in vBulletin 3.8.7:

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, September 20th 2012 @ 12:35:57 PM
Error Date : Thursday, September 20th 2012 @ 12:35:57 PM
Script : http://__mysite__/admincp/plugin.php?do=productimport
Referrer : http://__mysite__/admincp/plugin.php?do=productadd
IP Address : __my ip
Username : __my username
Classname : vB_Database
MySQL Version : 5.5.25-cll
For obvious reasons I replaced my site, username and ip above with "__my ip" etc.
Is it just not confirmed working with vb3.8.7?
Or am I missing something obvious in the plugin xml I can fix.

Thanks in advance to the thread contributors for ideas and help. :)

desmomax 10-09-2012 07:06 AM

After a while testing this mod i can say it works great. It happens that few real users are rejected by the mod. What shall i do in this case? is it possibile to bypass certain ip address?
thanx

mattballew 11-08-2012 05:42 PM

Im getting this error when i try to install.. http://puu.sh/1nTWu Anyone else have this issue?

SRobbins1977 11-17-2012 04:59 PM

hello, I am getting this error:

Quote:

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 : Saturday, November 17th 2012 @ 11:55:32 AM
Error Date : Saturday, November 17th 2012 @ 11:55:32 AM
Script : http://mydomain.com/admincp/plugin.php?do=productimport
Referrer : http://mydomain.com/admincp/plugin.php?do=productadd
IP Address : 74.101.113.163
Username : Administrator
Classname : vB_Database
MySQL Version : 5.5.23-55
Please help!

zylstra 11-28-2012 07:16 AM

Replace all
Code:

TYPE=MyISAM
with
Code:

ENGINE=MyISAM
in the xml file.

ApexSpeed 12-20-2012 01:34 AM

I am getting a similar error, but not exact:

Code:

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT DATEDIFF(NOW(), '2012-12-20 02:18:04') AS DAYS;;

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 '(NOW(), '2012-12-20 02:18:04') AS DAYS' at line 1
Error Number  : 1064
Request Date  : Wednesday, December 19th 2012 @ 09:21:31 PM
Error Date    : Wednesday, December 19th 2012 @ 09:21:32 PM
Script        : http://www.apexspeed.com/forums/register.php?do=addmember
Referrer      : http://www.apexspeed.com/forums/register.php?
IP Address    : 195.190.13.102
Username      : rchuano130
Classname    : vB_Database
MySQL Version :


Everything is working VERY well other than the db error e-mail for every spam registration, which is at anywhere between 300-400 a day now.

Same or similar fix?

ApexSpeed 12-20-2012 01:40 AM

Ahhh, I just realized my server is running MySQL V 4.0.27. Guess this isn't going to work after all... :(

ApexSpeed 12-20-2012 08:56 PM

A nightmare to get the MySQL updated in the past 24 hours that led to 2,451 database errors in my Inbox at lunchtime today, but we finally got it updated to 5.0.+ MySQL version to run this plug-in. And I have to say, it's been 100% effective already blocking 44 spam user account registrations and allowing 3 legitimate users to register.


THANK YOU FOR THIS PLUG-IN! It's fantastic so far and relatively easy to install. Nice work! :up: :up:

ApexSpeed 12-27-2012 02:16 PM

Everything is updated on the server, we're running vB 3.8.0 and while the plug-in is working, we are still getting about 20-30 very strange database errors per day. When the plug-in is shut off, it all stops, so it's something being driven by vbStopForumSpam.

Code:

MySQL Error  : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number  : 1267
Request Date  : Thursday, December 27th 2012 @ 06:29:06 AM
Error Date    : Thursday, December 27th 2012 @ 06:29:07 AM
Script        : http://www.apexspeed.com/forums/register.php?do=addmember
Referrer      : http://www.apexspeed.com/forums/register.php?
IP Address    : 176.53.43.226
Username      : ****
Classname    : vB_Database
MySQL Version : 5.0.51a-log

They all have the "Swedish" and "Latin" notes in the errors, and we can't figure out what is causing them. I'm going to attempt to find 3.8.7 forum software when I get a chance today, but their current system for older software updates leaves me itch, so we'll see what I can come up with. It might help the issues with the database errors.

If anyone else notices something obvious, I'd appreciate any input.



doug

jimsflies 01-02-2013 11:22 PM

At some point in the past couple days (since 12/28) guests have not been able to register because they are apparently being tagged as a spammer. I confirmed this by trying to register myself and also was denied.

Has anyone else had this problem in the past couple days?

I checked my info against stopforumspam.com database and it is not in their database. So registration should be allowed.

kapoor22 01-12-2013 11:06 PM

Could anyone please let me know how to access vbStopForumSpam Log Viewer page shown in this image (below)?

https://vborg.vbsupport.ru/attachmen...2&d=1208476300

Thank you!

ApexSpeed 01-12-2013 11:15 PM

It the Admin Control Panel, go to Statistics & Logs --> vbStopForumSpam Logs

Still getting loads of vB database errors mentioning Swedish & Latin language issues. Anyone?

kapoor22 01-13-2013 02:39 PM

Quote:

Originally Posted by ApexSpeed (Post 2396537)
It the Admin Control Panel, go to Statistics & Logs --> vbStopForumSpam Logs




Still getting loads of vB database errors mentioning Swedish & Latin language issues. Anyone?

Thanks ApexSpeed! This is helpful.

Wish I could have assist with the vb DB errors issue.

Lpspider 01-25-2013 04:37 AM

How are you guys dealing with members contacting you saying they're not spammers but can't sign in? Obviously they were banned elsewhere, but I'm afraid I'm missing out on many members because of this.

abhimation 02-02-2013 11:30 AM

Ive been using this wonderfully with one of my VB 3.8.2 forum. But facing lot of spammers still finding ther way in my other VB 4.1.10. Am I missing out something? Please help..

http://img717.imageshack.us/img717/1801/vbstop.jpg

steven s 02-02-2013 01:10 PM

Quote:

Originally Posted by abhimation (Post 2401276)
Ive been using this wonderfully with one of my VB 3.8.2 forum. But facing lot of spammers still finding ther way in my other VB 4.1.10. Am I missing out something? Please help..

I noticed the same thing beginning last week.
I installed spam-o-matic thinking something was wrong.
Same results with that.

It just seems that these new registrants are not listed in the sfs database yet.

rharbison 02-02-2013 03:29 PM

If you're running VB4, what you're missing is Spam-o-Matic. Works great, adds an excellent ban and report button to the forum, and is currently supported.

I definitely would (and do) choose it over this one if you're running VB4.

fworth 02-04-2013 12:26 AM

i'M getting this error:

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

Nevermind i got it working.

jdrakopo 03-24-2013 03:52 AM

Does this plugin work with VB version 4.1.9 ?

gabrielt 04-25-2013 08:35 PM

Hi guys,

I created a plugin for this product in order to manually report a user from inside the admin control panel, while seeing the user's full profile/editing screen.

I needed that in order to manually report offenders that were blocked by the Multiple Account Registration Prevention product and automatically moved to the "Users Awaiting Moderation" group.

I hope this little add-on is useful for other user who need a reporting tool inside the admin CP.

PS: You need to import this file as a PLUGIN and not as a product.

Thanks.

ApexSpeed 04-25-2013 09:06 PM

Nice addition... instead of just deleting the users that make it through the filters, we can add them. Excellent.

Now, all we need is a way to whitelist those users who are trying to register and can't because their preferred username is on a blacklist somewhere keeping them out.

hotshot 04-28-2013 09:07 PM

This blocks too many legitimate users. Unfortunate. The User Agent block works the best by blocking IE6 and below and well as other bot spiders.

ETDC 04-28-2013 10:19 PM

Quote:

Originally Posted by hotshot (Post 2418997)
This blocks too many legitimate users.

Only if you have 'User Names' enabled. Otherwise, it denies registrations from people on the SFS spammers database - what is there not to like?


All times are GMT. The time now is 04:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02562 seconds
  • Memory Usage 1,832KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete