vb.org Archive
Page 111 of 123 « First 1161101109110 111 112113121 Last »
Show 40 post(s) from this thread on one page

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)

SamirDarji 03-12-2011 07:10 AM
I don't have this installed, but it looks like the ip column isn't be found in the log table. Go into phpmyadmin and see what the table structure looks like. Either the clause could be incorrect or the table is missing information (which I highly doubt since it seems you can see the ip addresses).

thbertram 03-14-2011 01:20 PM
Quote:
Originally Posted by rob4448585 (Post 2172480)
Added this mod to my 3.8.1 board.

Everything works great, catches and logs spammers trying to sign up.

Only issue I have is when I go into the log and sort it by IP address it throws a database error

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:

                SELECT * FROM vbstopforumspam_log AS logs
               
                ORDER BY ip ASC, date DESC
                LIMIT 0, 15;

MySQL Error  : Unknown column 'ip' in 'order clause'
Error Number  : 1054
Request Date  : Saturday, March 12th 2011 @ 12:22:11 AM
Error Date    : Saturday, March 12th 2011 @ 12:22:11 AM
Script        : http://forums/admincp/vbstopforumspam.php?do=view&pp=15&orderby=ip&page=1
Referrer      : http://forums/admincp/vbstopforumspam.php?do=view
IP Address    :
Username      :
Classname    : vB_Database
MySQL Version : 5.1.49-log

Any help with getting this resolved?
Something is wonky here... the column name in that table is 'ipaddress.' This error is occurring from the Log Viewer?

rob4448585 03-14-2011 05:19 PM
Quote:
Originally Posted by thbertram (Post 2173215)
Something is wonky here... the column name in that table is 'ipaddress.' This error is occurring from the Log Viewer?
yes only when i go into the log viewer and sort by ip address

SamirDarji 03-15-2011 01:23 AM
Sounds like something is wrong in the query. Does anyone else have this same problem?

Phaedrus 03-18-2011 10:55 PM
*edit: Sorry, posted in wrong thread.

steven s 03-27-2011 04:44 PM
Where has the instructions to submit spammers to the database gone?
The link in the first post no longer works.

Simon Lloyd 03-27-2011 08:04 PM
http://www.stopforumspam.com/ works fine for me just like in the first post :)

steven s 03-27-2011 08:12 PM
Quote:
Originally Posted by Simon Lloyd (Post 2178091)
http://www.stopforumspam.com/ works fine for me just like in the first post :)
It works fine for me too.
I am looking for the additional mod to submit spammers to the [stopforumspam] database.

For code to submit spammers to the database, check this post for code changes
https://vborg.vbsupport.ru/showpost....&postcount=288 is a dead link.

newguy 03-28-2011 12:23 AM
Just installed and two were blocked with in 10 minuets, although I only have the "test IP address against the ban list", since so many legit people use numbers in there user name on my site.

I tested registering with a few numbers in the user name and I used a legit email address, I was blocked due to the user name, that was reason in the log file anyway.

rob4448585 03-28-2011 12:56 AM
Quote:
Originally Posted by newguy (Post 2178160)
Just installed and two were blocked with in 10 minuets, although I only have the "test IP address against the ban list", since so many legit people use numbers in there user name on my site.

I tested registering with a few numbers in the user name and I used a legit email address, I was blocked due to the user name, that was reason in the log file anyway.
I have had mine installed for 16 days and it has blocked 2,019 entries.

SINGLE best mod for Vbulletin


All times are GMT. The time now is 12:01 AM.
Page 111 of 123 « First 1161101109110 111 112113121 Last »
Show 40 post(s) from this thread on one page

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.02316 seconds
  • Memory Usage 1,745KB
  • 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_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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