vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - vbStopForumSpam (https://vborg.vbsupport.ru/showthread.php?t=230921)

howard007 06-06-2010 04:09 AM

I've been running this fine and all of the sudden:

All of the sudden I get these errors and I've been running vbstopforumspam for a couple months. How do I fix?


Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked,
userhash) VALUES (now(), '91.121.85.126' , 'larrypae@gmail.com', 'Unregistered',
'Result on field username - Unregistered [REMOTEERR] Unverfied but allowed by
policy', 0, '677850e24e7b5900768632062e50c3f7');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, June 6th 2010 @ 12:55:52 AM
Error Date : Sunday, June 6th 2010 @ 12:56:59 AM
Script : http://www.website.com/forums/register.php?do=addmember
Referrer : http://www.website.com/forums/register.php
IP Address : 91.121.85.126
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Fireagle 06-06-2010 12:17 PM

Log sort by IP:

Quote:

Datenbankfehler in vBulletin 4.0.3:

Invalid SQL:

SELECT * FROM vb_vbstopforumspam_log AS logs

ORDER BY ip ASC, date DESC
LIMIT 0, 15;

MySQL-Fehler : Unknown column 'ip' in 'order clause'
Fehler-Nr. : 1054
Fehler-Zeit : Sunday, 06.06.2010 @ 15:16:20
Datum : Sunday, 06.06.2010 @ 15:16:20
Skript : http://*********/admincp/vbstopforum...erby=ip&page=1
Referrer : http://*********/admincp/vbstopforum...sername&page=1
IP-Adresse : ************
Benutzername : Fireagle
Klassenname : vB_Database
MySQL-Version : 5.0.83-log

howard007 06-08-2010 12:34 AM

Is there any way that I can whitelist an IP? If I was a coder, I'd do it. :)

Can't we have an over ride option to enter an IP? PLEASE???

Thanks

Mrdby 06-08-2010 02:53 AM

well i added it and seems to be fine for now.

JHUMON 06-08-2010 10:33 AM

hm working well

Mrdby 06-11-2010 12:29 AM

diamonds sparkles 2010-06-10 12:52:28 ******@hotmail.com 96.50.97.44 Allowed registration

It allowed her, but she still was rejected because of the spam policy. why is that?

All other members that were allowed are now on the site and their name is clickable when i run this log report except for her.

Dragonsys 06-13-2010 02:31 PM

Quote:

Originally Posted by Mrdby (Post 2051797)
diamonds sparkles 2010-06-10 12:52:28 ******@hotmail.com 96.50.97.44 Allowed registration

It allowed her, but she still was rejected because of the spam policy. why is that?

All other members that were allowed are now on the site and their name is clickable when i run this log report except for her.

maybe because of the space in her name? Check your username Regular expression and see if spaces are allowed.

Mrdby 06-14-2010 09:22 AM

Quote:

Originally Posted by Dragonsys (Post 2052974)
maybe because of the space in her name? Check your username Regular expression and see if spaces are allowed.

where do i find that? I want to change people from adding spaces or certain characters when joining my site.

fxwoody 06-14-2010 03:29 PM

Tks for the plugins! Will make us feel safer :)

Mrdby 06-14-2010 07:45 PM

same problem with somone else but they were allowed and still is not a registered member.

Unregistered 2010-06-14 15:24:05 thelordof.the.rings2k@gmail.com 85.186.255.233 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 15:05:42 gogogogoass@gmail.com 94.19.191.183 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 14:43:54 neltocount@land.ru 91.212.226.15 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 14:04:15 afd-4444@yandex.ru 91.214.44.233 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 08:59:56 mail@sextoys-diskret.com 79.237.89.141 Result on field username - Unregistered - Spammer and rejected by policy
rosieado 2010-06-14 08:57:08 rosieado@yahoo.com 71.179.101.243 Allowed registration
rosieado 2010-06-14 08:56:32 rosieado@yahoo.com 71.179.101.243 Allowed registration
rosieado 2010-06-14 08:55:37 rosieado@yahoo.com 71.179.101.243 Allowed registration


All times are GMT. The time now is 04:40 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.01511 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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