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)

skippybosco 03-15-2009 03:18 AM

I used the current version of this plugin (.61) on 3.6.0 for a while with no issues..

Alfa1 03-15-2009 02:57 PM

A lot of registrations are blocked because they seem to be using the name 'unregistered'. But it seems to be 1 in every 10 registrations. Something seems wrong. Do you have any idea what could be the problem?

Sym0n 03-15-2009 05:34 PM

Quote:

Originally Posted by Alfa1 (Post 1768737)
A lot of registrations are blocked because they seem to be using the name 'unregistered'. But it seems to be 1 in every 10 registrations. Something seems wrong. Do you have any idea what could be the problem?

I've not had this on the forum I admin. :confused:

Alfa1 03-15-2009 06:09 PM

Maybe its a conflict between this and vMail ?

jwocky 03-18-2009 04:17 PM

Quote:

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT HIGH_PRIORITY IGNORE INTO vbstopforumspam_remotecache (date, data, spambot, field) VALUES (now(), 'tvgxi489i@moreprobe.com', '0', 'email');;


MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, March 18th 2009 @ 06:10:18 AM
Error Date : Wednesday, March 18th 2009 @ 06:10:55 AM
Script : http://www.com/forums/register.php?do=addmember
Referrer : http://www.com/forums/register.php?do=register
IP Address : 116.32.228.134
Username : V4ibWDcO
Classname : vB_Database

I got this SQL error today.

Is there a possible SQL injection vulneralbility with this mod or an error with the code?

skippybosco 03-18-2009 10:19 PM

We've seen that error in the past:

Quote:

Originally Posted by pedigree (Post 1738844)
Im guessing that mysql is closing pages due to the unsually long period of time that its taking to query lookups due to the slow remote database server. If youre using cUrl for your lookups, try lowering the timeout period so that mysql doesnt close its connections or increase the timeout period for mysql.


pedigree 04-01-2009 09:44 PM

As the API is becoming very popular, more and more people are writing interfaces to it and some are very very bad. As some of the implementation do no caching, the API is getting hammered by some forums.

Because of this, we have had to add rate limiting (currently 1000 per day but thats not set in stone). This hasnt gone live yet but I will be checking how the mod will handle this.

Read more here http://www.stopforumspam.com/forum/t573-Rate-Limiting

Alfa1 04-03-2009 06:07 AM

I tried to update from 0.60 to 0.61 by uploading the product. This is the error that I got:
HTML Code:

Database error in vBulletin 3.8.2:

Invalid SQL:
ALTER TABLE vb5_usergroup ADD vbstopforumspamviewpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'vbstopforumspamviewpermissions'
Error Number  : 1060
Request Date  : Friday, April 3rd 2009 @ 09:00:57 AM
Error Date    : Friday, April 3rd 2009 @ 09:00:57 AM
Script        : /forum/admincp/plugin.php?do=productimport
Referrer      : /forum/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : Alfa1
Classname    : vB_Database
MySQL Version : 5.0.77


pedigree 04-03-2009 10:10 AM

You need to uninstall and reinstall the mod. Prior to 0.61, there is no upgrade path without a reinstall Im afraid.

You could edit the XML file and remove the line of code that does the sql query directly under that if you wish to maintain you logs. You dont need to upgrade from 0.60 to 0.61 unless you manually editted your templates to include the faulty vB conditions.

peterle1 04-03-2009 08:26 PM

Installed this as 0.61 but it only shows up as 0.6.
It doesn't seem to work with 3.8.1. Log is empty and today the first mail adress mentioned in the blacklist came through.

Any hints would be nice. Thanks.


All times are GMT. The time now is 10:40 PM.

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.03037 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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