First let me say that you do not need to create a banned usergroup, vB default banned usergroup ID: 8

There are a couple of things that you need to check.
1) Create a new group for newly registered members, you can set the number of post they have to have before using pictures, URL's, etc. Read about it here: New Members Create Link

2) Make sure you have your API keys.
3) Don't check User Names, just IP and E-Mail
4) Create a longer list of bad words you can find a bunch here: Bad Words list to copy and paste

That might fix your problem, if not give us a little more detail on why they are not being banned. Have you checked the IP's at http://stopforumspam.com/ ?

Thanks it seemed to install ok after the changes thanks for your help big time. ill let you know if anyproblems come up :up:

Tried to install on vb 4.2.0

Getting error

Did you temporarily disable the Mod before the upgrade? It is working on my 4.2.0. Maybe try to remove SOM and install it again.

I never had it installed previously, what should I do from here?

What version of MySQL are you running? If it is the newer version 5.1 or up then you need to first remove a line of code in the XML file for it to function. Read this: https://vborg.vbsupport.ru/showpost....postcount=1639 and give it a try. Maybe that will fix the problem. If not then let me know and we will try something else.

That link says file not found?

Let's try again. If it doesn't work it is post #1639 four pages or more back.

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

Is there a way to show the logs to users who are moderators / have access to the MODCP or maybe get those to be posted in a thread automatically at all?

Is this 4.2 compatible?
Thanks

Yes it is, just be sure to read at least the last couple of pages for basic instructions.

This mod has been very helpful for my forum since I've launched my site.

Stats So Far
5162 Spammers Denied Registration
224 Spammy Posts Automatically Moderated

However, lately I've been getting lots of spam bots signing up and getting by the mod and posting blog posts on my board.

What can I do to combat this? Have these bots found a way past the mod? Any plans to update the mod?

It has been mentioned several times in this thread, however, there are a lot of pages to read so I'll go ahead and say it again. vB has usergroup permissions. If you are using S-O-M and have created a new members group for moderation, then just change the permissions for blogs. Only allow registered members to post blogs. Don't give permission to newly registered members, make them go through the auto moderation before they can post on a blog. Also remove the ability for them to post links, and pics, signatures, etc. You get the idea! Just use forum permissions for these settings. For the most part this mod will probably never be updated, but with a few of the tweaks that we have posted, there is really no need for it!

Just tried to update to the latest version of Spam-O-Matic on vB 4.2 and get a Database error when importing the xml.

This is what I get:

Any help appreciated, please. I love this product :) :) :)

molieman, a couple of things I noticed:

As I have mentioned before for those that don't like to read!! A couple of corrections have been made throughout this thread. and I'm going to repeat them here.

1) Make sure that you DISABLE check username, let me reapeat, do not engage check username!! There are many reasons to do this but for example if a spammer decides to use my username, then I would be blocked from registering on your site.

2) Make sure to get your API keys and use them.

3) increase the amount of words on your Bad Words list. I could give you a link to GlowHost that has a list, but I will just present it to you here to copy and paste:

4) If you are running a newer version of MySQL it has a much more strict usage and this mod as well as a few others are not allowed to make tables in the database. This is primarily because the newer versions of MySQL is enabled with strict_mode ON.

There are two ways to make this work, however, option one you may have to contact your provider to do unless you have direct access to the "my.ini" inside the MySQL installation directory. Turn Off MySQL Strict Mode

Another way to do it is withing the XML file of GlowHost S-O-M. I placed this post back a number of pages and a number of members found it useful. I will repost it again here.

{Quote from post #1639 in this thread}

Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

For anyone that has a Database error that looks like the following example this is how I corrected it.
Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:
There may be a couple of other changes that I can not think of off the top of my head, but this should get it working for you. Yes it works in vB 4.2.0!:D

A few more items to remember to do for your forums using GlowHost S-O-M.

Some of these are decisions based on each individual Admin, but these are the basics that I follow.

Remember: Bold is the title in S-O-M, also I'm not going in order for a reason that will be listed last.

Q: StopForumSpam: Query Connection Errors
A: Allow Registration

Why you may ask. If for some reason the StopForumSpam site is down, I do not want to block the registration of the user. As I will explain in just a little bit, they will be placed in auto-moderation anyway.

Q: Auto-Moderation: Enable
A: Yes
This is where your list of Bad Words, and New Member Group come in to play. It will be explained.

Q: Auto-Moderation: Post Action
A: Moderate Post
With this utility you have the option to ban the user, and remove the post before anyone other than Mods, and Admin can see it. It is located in the Moderation Tools under the Post called of course Spam-O-Matic!

Q: Auto-Moderation: Apply Auto-Moderation To Newbies only?
A: Yes
As stated earlier this will be explained and you MUST follow through for it to be effective.

Q: Auto-Moderation: Minimum Post Count
A: This depends on the Admin. I personally think that withing the first 3 posts that I will know if the member is a spammer or not. I set mine to 3, and for good reason that you will see here shortly.

Q: Auto-Moderation: Bad Words
A: Listed in my post above, just copy and paste

Q: Auto-Moderation: URL Count
A: You may set this to any number you desire. Remember that this only applies to your new user group that we have not mentioned yet. You may not want them to post any URL's so you may set it to 0.

Q: Easy Cleanup: Banned UserGroup ID
A: By default the Banned User ID in vB is 8.
I mention this only because a user created a new banned user group for this mod which is not necessary. Just use the default Banned User ID. If you want to double check you may select AdminCP > Usergroups > Manage Usergroups and you will see the ID next to Banned Users.

The rest of the questions are pretty much self explanatory, however, if you have a question feel free to ask. Now we are going to talk about creating a new usergroup. Instead of giving you a URL, I will just post the information here.

Q: Newbies Manager: Put New User Into Newbies Group?
A: Yes

Note: as you create a new usergroup remember that the next question is:
Q: Newbies Manager: Newbies Group ID
A: Only the creator of the group will know the ID.

After creating the usergroup take note of the ID and place it in S-O-M as stated above.

Feel free to ask question if you have any. Also remember that these are the types of settings that I use. Each person is going to have different perspectives. Only use this as a guide when getting your feet wet for the first time.:)

I cannot begin to tell you how much I love this mod. 305 Spammers Denied Registration in 6 weeks and a huge headache removed for me.

try this :D - https://vborg.vbsupport.ru/showthread.php?t=283722
Minimum Post Count Required To Post Blog Entries

For various reasons we uninstalled this Glowhost mod after using it for almost 2 years. The new version is bad, has less features and blocked a lot of real human registrations and posts, the author also hasn't updated it in a long time. Now we use vB Q&A as the Human Verification system.

No workie....

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 : Thursday, May 31st 2012 @ 06:58:19 PM
Error Date : Thursday, May 31st 2012 @ 06:58:19 PM

Check post 1775 for fix

Thanks !!!!

If you get error for TYPE=MyISAM you must

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

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?

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.

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.

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.

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!

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

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

run this

Any chance we can get a blog spamming feature? I have spamomatic installed but just got 3900 spammy blog posts over the past day.

Make a new user group that has access to blog posting and don't let normal users post to the blog then you can set it that after x amount of posts they get auto moved to the new group you can also make it that the first post is modded this way it will stop all spammers. On another note if spammers are registering then I would look at your Spam O Matic settings and see why.

Ok call I did this and still get Database error as above

MySQL Version : 5.5.23-55 I would say this is your problem needs to be downgraded

Ok thanks for the answer unfortunately that isn't gonna happen so I will wait till there is an upgrade to support 5.5.23-55 but I will keep this is mind

Mate I have MySQL Version : 5.5.23-55 and I have no problem running this mod.

as you dont have all the same things he has or the same hosting does not mean it will work even if you do have the same mysql version

I'm having a weird problem with this mod.

When I have it enabled, any time I try to save anything on the admin site (not just within this mod, but anywhere) it will time out. As soon as I disable this mod, the problem goes away.

Here is what my host said about the issue. Again this seems to go away when I disable this mod...

Your problem is not MySQL but the code.

Change all occurence of

to

in the XML and that will solve the DB Errors.

Thanks for that it fixed it had to change it in the product xml