vBulletin Mods

db error

let me get my mind reading cap on

I cant get API key :(

How do I change these sentences?

you need to go to the correct forums and sign up to get it
http://www.stopforumspam.com/forum/register.php
https://akismet.com/signup/#free

since update to 4.1.11 patch level 1 we have problem with this plugin , the moderator's option to which shall delete all users posts seems not work properly

it mark the user, claims report it to stopforumspam etc.

the user gets banned but (banned group seems weird)
yet associated posts aren't removed etc.

when i use manual moderator ban then put's the users into correct usergroup

the number setting of banned usergroup ID is correct in SOM's settings

Well when i click Post and i got this happen http://screensnapr.com/e/fR3BLQ.jpg any help pleasE? Thanks!

disable all plugins and then turn each one on testing new reply to see what one is causing the error

Before I install this, can someone confirm it works on 4.1.12?

it does

Works on my 4.1.12 forums :cool:

Thanks, I went ahead and installed it as well. I had an issue with having to hack the xml to fix mysql table create error. I read the solution elsewhere in this thread. It works great and I am looking forward to using it.

that would depend what settings you have

StopForumSpam: Username Check = Disabled

Got database errors

Thanks for all that valuable information that you just shared with us!! If we do not know what the error is then we can not help you fix it. Did you read the thread? There are a number of places where we have helped people with errors.

you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

I'm on the fence about this, it's an internal message that only moderators will see. This is a free mod, that boy does help when fighting spam, and is almost necessary.

Giving you the optional ability to remove credits in the footer is something other authors don't do.

So I wasn't hurt by it, what ticks me off are straight out advertisements stuck in my footer by authors, that kinda stuff is nuts (which this mod doesn't do)

You're always welcome to make your own. If you don't want to put your advertising it, let me know when you post it.

I removed all that crap long ago

Does anyone know how do I remove homepage statistics like these

Spam-O-Matic Statistics
22 Spammers Denied Registration
12 Spammy Posts Automatically Moderated

Thanks

check options you will find it there

The problem i have is the huge graphic advertisement (with coupon and referral code) were not disclosed. I don't like surprises when I ad something to a forum. I was made to think the options in the admincp turned those off.. it doesn't mention that even if you turn it off, there's another giant ad. Also, every single post you get rid of will have an ad in the deletion comment as well (visible only to mods).

why dont you remove it then from the files

Its in the XML.

I do agree with vissa. As this hides from the admin, this secret advertisement of hosting to moderators is plain spam. It seems intended for moderators to start a competing forum, which would be simply malicious.

I find this very ironic for an addon that is supposed to fight spam. This should be clearly stated in the description of this addon.

Upgraded my test board to 4.1.12 and so far this mod seems to work 100% with no issues yet found!

Is there any particular reason why all moderators seem to have full access to spam-o-matic's permissions?

I cannot for the life of me find a way to stop certain mods from being able to use this. Even the lowest-tier mod with 1-2 permissions in one subforum can use Spam-O-Matic to hard delete posts from existence.

Even if this is only on "new" users I'm seriously concerned about the idea.

We are on 4.1.12 and are having the same problem, plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

Well it's pretty natural for that to happen since this plugin, like the other StopforumSpam one hasn't been updated in more than a year, and well things have changed and are changing in vB.

lucky you I can't even get installed when I attempt to upload/install the xml file I get a mysql error :'(

I am not having that issue, but am doing some testing to see if I have the first issue you listed.

Nope, all works like I think it should.

Spam-O-Matic has performed the following actions:
Selected users were removed
33 posts were removed permanently
5 PMs were removed

I confirmed in the logs and in the fourm that what I asked it to do, was in fact done.

post error

SteveLV702.
Try this, it was posted a few pages back.

Hello, I'm trying to register a friend from my pc and i get this message:

Registration denied, this forum runs an active policy of not allowing spammers. Please contact us via the "Contact Us" page link if you believe this is in error

to that is?

disable username

hi..

is it possible to make the Statistic only show to admin / moderator only?

i'm sure that i only need to put an if condition in the plugin manager -> Stats render, and before this:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

could someone please help

thanks

any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

why not disable blog for normal users

Is there anyway I can submit users through their profile if they haven't post anything?

Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

Exactly. If someone hasn't spammed, why would you submit them to a spam database? If people start doing that, the spam database becomes useless.

90% of the spammers that I get don't get the chance to post because they don't seem to get past the advanced forum rules check that I have. This is site wide and no one can post until they accepted these rules.

This option would be userful to me, but I have not pushed for it because I can see how it could be abused.

If they post spam but the post is moderated, then submit them to the database. If they don't get a chance to post at all, they're not spammers (yet) and should not be submitted.

I personally disagree. And I think this states the obvious:

And I have over 100 more accounts like these. Plus their profile information (URL, etc) are showing all kinds of advertisement links.

With other anti-spam methods I installed, they can't even post. But that doesn't stop them in registering. Spam-O-Matic, or in this case stopforumspam isn't 100% bot-stop-proof and I'd like to submit them to stopforumspam (the easy way) but I can't because they haven't posted.

hi..

i think it will be great if "when submit post to spam o matic", it have an option to give the Infraction point, not permanent ban.

I hope you do realize that the Spam-O-matic is meant to perm ban bots. Why would you want to Infract those AI? (Artificial Intelligence). Bots are not real humans, they are programmed to spam (usually advertisements) on other people's forums. There is no point in Infracting bot users.. They are meant to be banned and or removed entirely.

I do agree that sometimes the email address or member name is a giveaway that might warrant submitting to the database.

Try this...

1. Admin CP >> Plugins & Products >> Add New Plugin

2. Product = vBulletin

Hook Location = useradmin_edit_column1

Title = Submit to StopForumSpam.com

Execution Order = 5

Plugin PHP Code:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Plugin is active = Yes

3. Save

Thanks for that, will give it a try, I have 30+ spam registrations a week, below is a typical selection. Everyone of those is a bot of some sort and whilst the majority don't post, they are still spam.

It would be really nice to have a form for new users like the one shown in the image, but with tick boxes on the right for banning and submitting to the database.

I've done some searches in this post, but so far I can't find the answer ...

I'd like our moderators to be able to see the Spam-o-Matic logs so they can check if they get an email from someone claiming they were rejected at registration as being a spammer.

Currently, they don't see those logs, so is there a way of turning on an option so they can?

Thanks for any feedback ... :)

Regards,
Doug

For spambots, I identify the IP address and block them as IP ranges at the server level: xxx.xxx.xxx.0/24 - otherwise, it's way too much work trying to keep up with them.

BadgerDog,
There is a way to do it, but I would not suggest it. You would be giving the moderator a little too much access to the administrator panel, where damage could be done. You don't even want SuperMods to have that kind of access.

Thanks.. appreciate the feedback .. :)

I wonder if there's a way of getting the code to output a text file so the mods can download and check it that way?

Regards,
Doug

I keep getting a user reporting that they are blocked from registration because they are spam...Is their user agent or something causing it? Any ideas?

First make sure that you are not blocking username in the AdminCP. A lot of us learned that with that feature on, many legitimate submissions were being blocked. Also check the log file to see if it tells you why they are being blocked. If it is an IP conflict, then the only thing you can do is register for them, unless you want to turn off SOM temporarily.

That was enabled. Turned it off and I'll send him an email to try it again. Hopefully that fixes it :)

as it blocked his name in the first place it will have that name in glowhostspamomatic_remotecache table you will need to remove his name from that table if he still cant register

Thanks! However:

In the users (bot) AdminCP profile menu. While my spam-O-matic "StopForumSpam: API Key" options has already a key filled in.

hi..

i found that the auto-ban user just wont work in here..

Easy Cleanup: Enable
Easy Cleanup: User Action - Ban User
Easy Cleanup: Banned UserGroup ID - 14 <- 14 is the usergroup ID that i already created

The post / thread is moderated, i saw the soft / hard delete also works.. but the Ban wont work, the user still not banned.

could someone help?

thanks

Database error in vBulletin 4.1.12:

Invalid SQL:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

It was back a number of pages when I had this error. Here is a link to the thread #1639

http://www.vbulletin.org/forum/showp...postcount=1639

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: http://www.vbulletin.org/forum/showp...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.

http://www.vbulletin.org/forum/showp...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:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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 - http://www.vbulletin.org/forum/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 [email protected] 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.

http://www.vbulletin.org/forum/showt...top+forum+spam

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

to

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

in the XML and that will solve the DB Errors.

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