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)

Lee G 02-07-2009 08:37 AM

This has got to be one of the very best anti spam features to add on to any vb forum.

I cant believe how many spammers this stops each day.

Keep up the good work

Chicago_VLNU_4s 02-07-2009 10:05 PM

works like a charm on 3.5.4

skippybosco 02-09-2009 01:31 AM

Host recently upgraded PHP and MySQL and I've started to receive these errors (removed real user info)

Quote:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '000.000.000.000' , 'spammer@email.com', 'username', 'Result on field username - username [REMOTEERR] Unverfied but allowed by policy', 0, '1484b1f7391c8014a25bb68602e0819b');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Any ideas?

kylek 02-09-2009 02:57 AM

I am getting the same thing on 5 sites I have this installed on. Just started getting the errors today.

skippybosco 02-09-2009 03:04 AM

Mine just started today as well..

I tested the SQL in phpMyAdmin and it is valid. No other MySQL errors show in the VB logs.

I'm running VB 3.7.5.

pedigree 02-09-2009 03:15 PM

Whats the exact version of php and mysql so that I can install both and test it.

Sym0n 02-09-2009 03:35 PM

pedigree, is SFS under heavy load at the moment or a DDOS attack? As I've had a lot of '[REMOTEERR] Unverfied and rejected by policy' results today and the load times are quite slow for the site at the minute.

Just thought I'd ask in case you weren't aware.

Ta

Sy

pedigree 02-09-2009 03:36 PM

Can you try this

includes/functions_vbsfs.php

go to line 165 (ish) that reads

$logresult = $vbulletin->db->query($sql);

and change it to

$logresult = $vbulletin->db->query_write($sql);

does that fix its behavior?

pedigree 02-09-2009 04:08 PM

Doesnt look like a DoS, just the mysql server is dead slow to respond. The server load is 3, which is next to nothing.

pedigree 02-09-2009 04:32 PM

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.


All times are GMT. The time now is 02:39 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.01874 seconds
  • Memory Usage 1,735KB
  • 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_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