vb.org Archive - Anti-Spam Options - [GlowHost] Spam-O-Matic

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

If you get error for TYPE=MyISAM you must

Find TYPE=MyISAM in XML and replace it with ENGINE=MyISAM

Skyrider

06-02-2012 08:15 AM

For some reason, bots register on the site regardless. I've checked the logs:

2012-06-02 09:46:55

199.167.146.114
loans_Canada12 isaacroberts270@yahoo.co.uk Passed StopForumSpam checks.

Sent to vBulletin Registration System.

While clearly a lot of bots on that IP are on StopForumSpam database..

Any idea what might be up?

Syxguns

06-02-2012 02:38 PM

Quote:

Originally Posted by FF|Skyrider (Post 2335734)

It should be stopping them, but for some reason if it is not able to you still have the new usergroup that you created, so they will be banned anyway before a post is ever seen.

The other thing that you can do as Admin is go into Settings > Options > User Banning Options. There you may ban the IP address and the e-mail address.

Skyrider

06-03-2012 08:05 AM

That's the thing Syxguns. The IP & E-Mail is selected. Just not the usernames. Though I recently have been given a hint to decrease the database date check from 60 to 30 days.

Syxguns

06-03-2012 08:15 PM

Quote:

Originally Posted by FF|Skyrider (Post 2336055)

That's the thing Syxguns. The IP & E-Mail is selected. Just not the usernames.

The setting you changed should help, but what I was talking about was the User Banning Options within vB settings. The reason I use this option if I need to is because I have mine set to allow registration if StopForumSpam is down, or not able to retrieve the information. The member is allowed to register, but then are placed in the New Member category that I created.

New Member: Not able to post URL's, can not use signature, can not post pictures, have access to see blogs, but can not leave comments. I have this set to 2 on post count before they become a registered member. S-O-M should automatically moderate the post for me, but if for some reason it doesn't then I have the logs and can ban the e-mail, and or IP address in vB if I have to. So far I've only had a couple of spammers get through on my test site.

PBRiot

06-08-2012 02:38 PM

Hi there, I've got Auto-Moderation: Enable set to "Disabled" and yet I am still getting new users who post links in their posts moved to auto-moderation. I would like to avoid that from happening - any assistance? Thanks!

Syxguns

06-09-2012 12:54 AM

Quote:

Originally Posted by PBRiot (Post 2337758)

Well, I don't have full information on your settings to be able to really help you out.

1) Did you create a new members group and if you did do you allow for URL's and pics? Those are part of the permissions that need to be adjusted. However, if you are not placing anyone in a new member group then make sure that Newbies Manager: Put New User Into Newbies Group? is set to NO.

2) I haven't ever tried it but maybe set Newbies Manager: Promotion From Post Count
to 0 and have them moved directly into the registered member area.

To be hones you may not want to use this modification. You would probably like vBStopForumSpam. It does not have built in auto moderation, it is just for registration. It is reported to work with vB 4.

https://vborg.vbsupport.ru/showthrea...top+forum+spam

GameOverViper

06-09-2012 02:04 PM

I uploaded everything onto a new forum of mine, then went to install and it gives me this error.

HTML Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(

                                                                `date` DATETIME NOT NULL,

                                                                `ip` VARCHAR(15) NOT NULL,

                                                                `email` VARCHAR(255) NOT NULL,

                                                                `username` VARCHAR(255) NOT NULL,

                                                                `message` VARCHAR(255) NOT NULL,

                                                                `is_blocked` TINYINT NOT NULL DEFAULT "0",

                                                                `user_hash` VARCHAR(50) NOT NULL,

                                                                `user_id` INT NOT NULL

                                                         ) TYPE=MyISAM;;



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

Error Number  : 1064

Request Date  : Saturday, June 9th 2012 @ 10:02:54 AM

Error Date    : Saturday, June 9th 2012 @ 10:02:54 AM

Script        : http://playstation3clans.net/admincp/plugin.php?do=productimport

Referrer      : http://playstation3clans.net/admincp/plugin.php?do=productadd

IP Address    : **.***.*.**

Username      : P3C VIPER

Classname     : vB_Database

MySQL Version : 5.5.23-55

ForceHSS

06-09-2012 02:29 PM

1 Attachment(s)

Quote:

Originally Posted by Americanbang (Post 2338113)

I uploaded everything onto a new forum of mine, then went to install and it gives me this error.

HTML Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(

                                                                `date` DATETIME NOT NULL,

                                                                `ip` VARCHAR(15) NOT NULL,

                                                                `email` VARCHAR(255) NOT NULL,

                                                                `username` VARCHAR(255) NOT NULL,

                                                                `message` VARCHAR(255) NOT NULL,

                                                                `is_blocked` TINYINT NOT NULL DEFAULT "0",

                                                                `user_hash` VARCHAR(50) NOT NULL,

                                                                `user_id` INT NOT NULL

                                                         ) TYPE=MyISAM;;



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

Error Number  : 1064

Request Date  : Saturday, June 9th 2012 @ 10:02:54 AM

Error Date    : Saturday, June 9th 2012 @ 10:02:54 AM

Script        : http://playstation3clans.net/admincp/plugin.php?do=productimport

Referrer      : http://playstation3clans.net/admincp/plugin.php?do=productadd

IP Address    : **.***.*.**

Username      : P3C VIPER

Classname     : vB_Database

MySQL Version : 5.5.23-55

run this

All times are GMT. The time now is 03:01 AM.

Page 179 of 350

179

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04557 seconds Memory Usage 1,769KB 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 (2)bbcode_html_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: