vb.org Archive - Anti-Spam Options

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)

Quote:

Originally Posted by hmdyilmaz (Post 2443366)

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum...=1376921314163

https://vborg.vbsupport.ru/showthrea...38#post2439738

Quote:

Originally Posted by TheLastSuperman (Post 2443418)

Hmm without access its hard to tell however... try this stop forum spam mod - https://vborg.vbsupport.ru/showthread.php?t=239307 then reply back here and let us know it the other mod works, if so we can surely then say it was this mod conflicting with something else on your site. That's a quick way to test imo.

Quote:

Originally Posted by hmdyilmaz (Post 2444571)

Try reading the reply you received above before re-posting the question.

Since upgrading to vBulletin 4.2.2 and then PHP 5.4.20, I'm getting errors like this:

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:

INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '216.244.87.218' , 'dmmt347ewq@hotmail.com', 'zeeukslzdx', 'Result on field ip - 216.244.87.218 [REMOTEERR] Unverfied but allowed by policy', 0, 'f3c419d6641f368fc5888e9c4a81d2be');;

They usually also say

Code:

MySQL server has gone away

Similar errors are being reported for the Glowhost version, where the response was this:

Quote:

Originally Posted by ForceHSS (Post 2455508)

Talk to your host about this problem "MySQL server has gone away"

But it's not that simple. The "gone away" error is, I think, a red herring. I'm on a dedicated server and that is the ONLY time I'm getting these errors. There are no other MySQL issues at the times these occur and it happens on two different 4.2.2 forums.

It's the Invalid SQL error that needs attention. Note the double occurrence of ";;" at the end. That looks malformed to me.

It may well have to do with upgrading to PHP 5.4.20 after the vBulletin 4.2.2 upgrade. I'm not certain.

A satisfactory workaround for now I think would be to turn off logging since the rest of the functions seem to be still working. There is no option to do that in vbStopForumSpam and I don't recall such an option for the Glowhost mod either (I found it to be overkill for my needs so I reverted to the simpler version).

Try this - don't know if it will make any difference but see if it does:

Find in functions_vbsfs.php:

Code:

[REMOTEERR]

Change to:

Code:

REMOTEERR

i.e., remove the square brackets.

No idea if this is creating a problem or not but try it.

I'm also working on some other strategies for tracking this down.

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

Quote:

Originally Posted by BlueScion (Post 2458723)

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

Quote:

Originally Posted by djbaxter (Post 2458823)

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

Oh ok. :)

im getting db errors on install. Any fix for this.

Quote:

Originally Posted by stemmy (Post 2459977)

im getting db errors on install. Any fix for this.

me too ?

Quote:

Originally Posted by stemmy (Post 2459977)

im getting db errors on install. Any fix for this.

Quote:

Originally Posted by webmastersitesi (Post 2470526)

me too ?

Open up product-vbstopforumspam.xml

Replace TYPE with ENGINE on line 22, 35, 45

Hope this helps.....

Itworx4me

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01671 seconds Memory Usage 1,750KB 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 (4)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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
Messages: