View Single Post
  #3469  
Old 12-11-2017, 06:03 PM
postcd postcd is offline
 
Join Date: Feb 2012
Posts: 319
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Skip this message, my problem. Solved

Hello, i am getting following error many times, and i am getting it only regarding this vB module, and from multiple vB forums hosted on same server of mine:

Quote:
Invalid SQL:
INSERT INTO glowhostspamomatic_log(`date`, `ip`, `email`, `username`, `message`, `is_blocked`, `user_hash`) VALUES (now(), "85.174.*.*", "*@yandex.ru", "*", "Spam-O-Matic Tagged email - *@yandex.ru Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at \'StopForumSpam: Query Connection Errors\'", "0", "**long*string*here");;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, December 11th 2017 @ 10:41:15 AM
Error Date : Monday, December 11th 2017 @ 10:42:26 AM
Script : http://mysitehere.com/register.php?do=addmember
Referrer : https://mysitehere.com/register.php?do=addmember
IP Address : 85.174.*.*
Username : *usernamehere*
Classname : vB_Database
MySQL Version :
MySQL server also gone away everytime i try to report spammer using this vB module (Glowhost spam-o-matic)

It do not appear like stopforumspam banned my server IP:
Quote:
curl http://api.stopforumspam.org/api?username=spammer&json^C
[1]+ Done curl http://api.stopforumspam.org/api?username=spammer
root@host1 [/]# curl "http://api.stopforumspam.org/api?username=spammer&json"
{"success":1,"username":{"frequency":0,"appears":0 }}r
I can login my SFS account, no problem.
UPDATE: i found these timeouts happening only from time to time. And during one timeout i tried to run this command on my hosting server: wget -O /dev/null stopforumspam.com and it timeout and shown SFS IPs and i searched logs for these IPs and also firewall and found these SFS IPs was banned on my firewall because somehow ended up in abuseipdb and stopforum spam blocklist, it could be also my fault.

Skip this message, my problem. Solved
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01085 seconds
  • Memory Usage 1,768KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete