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

I'm confused...is Easy Clean up something we are able to run manually? If so, how? Our site has been hit pretty hard by spammer registration (almost 100 a day, which is the reason I set up this mod) and I'd like to have them removed if they match anything in the StopForumSpam DB.

Any help would be immensely appreciated!

This mod as great as it is will not help you with the clean up of already registered members to the site.

This is what I do for registration:

I have this mod set to check new registration e-mail, and IP address. I also have it set to auto moderate the first post only, in case someone gets past the mod. The only problem with this is that you have to pay attention to the post to see if it's been moderated, and then allow access manually.

The second thing that I do is use another mod I use is NoSpam!Image Enhancement by BOP5 I'm not really suppose to talk about other mods on this thread, but with the two combined I have few to no spammers.

Manual clean up is required for you at this point. However, with the use of this mod it may take a little time but you can not only clean but you may also submit the spammers when doing so.

GlowHost.com

11-17-2012 02:43 AM

Hi All-

We will have a fix for the MySQL ENGINE/TYPE bug that is repeatedly reported very soon.

Also, a couple other common problems, plus a new feature (well, maybe a couple small ones too) is being added which has been requested many times over. Not telling what they are but this will be ready soon for your holiday present from GlowHost. :)

We are not doing anything major here, mainly code cleanup and bug fixes, because of the need for a vB5 version.

Stay tuned!

PS a big thanks to djbaxter, TheSupportForum, ForceHSS and I am sure I missed a few for your great help and support of this mod.

DannyITR

11-17-2012 10:38 AM

Can someone PLEASE tell me how to fix the problem of posts that cannot be approved. The only solution is to physically deleted them and that's not a solution.

osayidan

11-17-2012 01:24 PM

Quote:

Originally Posted by GlowHost.com (Post 2381783)

Hi All-

We will have a fix for the MySQL ENGINE/TYPE bug that is repeatedly reported very soon.

Is that referring to the database error when installing the product?
In the past couple of days I've had more spammers than the rest of my forum's history combined, so this is the first place I came to but I can't seem to install it :(

Code:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbb_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

bzcomputers

11-17-2012 02:19 PM

Quote:

Originally Posted by osayidan (Post 2381900)

Answer is just a page away...

https://vborg.vbsupport.ru/showpost....postcount=2199

mrfarb

11-17-2012 04:04 PM

This is the bomb (I'm so old). Installed, and nominated for MOTM.

SRobbins1977

11-17-2012 07:35 PM

Hello,
Im getting the following error:

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, November 17th 2012 @ 02:33:17 PM

Error Date    : Saturday, November 17th 2012 @ 02:33:17 PM

Script        : http://mydomain.com/admincp/plugin.php?do=productimport

Referrer      : http://mydomain.com/admincp/plugin.php?do=productadd

IP Address    : 0.0.0.0

Username      : Administrator

Classname     : vB_Database

MySQL Version : 5.5.23-55

PLEASE HELP!

Alibass

11-17-2012 07:48 PM

Read the posts...

https://vborg.vbsupport.ru/showpost....postcount=2199

gajinoz

11-17-2012 08:08 PM

I'm about to install this mod and I see there is a DB error when installing and a fix for it.

What I'd like to know is: Should I do this fix before installing it for the first time or just install it and see if I need the fix?

bzcomputers

11-18-2012 12:14 AM

Quote:

Originally Posted by gajinoz (Post 2382034)

MUST be changed before it will install correctly,

All times are GMT. The time now is 08:38 PM.

Page 224 of 350

224

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10026 seconds Memory Usage 1,756KB 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_code_printable (4)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: