Certainly - that's the way I have it set up.

AdminCP >> Settings >> Options >> Registration Options

Moderate New Members
Allows you to validate new members before they are classified as registered members and are allowed to post.

Set to Yes.

Eh, thanks, but no.
This is the way I have it set up too, but new registrations are not sent for moderation. I posted about this on the forums, and ended up raising a ticket on vb.com support. They said GlowHost was the problem; they confirmed I had my vb admincp settings correct for moderating new registrations, but that GlowHost Spam-o-Matic was preventing this from happening.

The way I see it at the moment you have two possible options

1 set up spam-o-matic to moderate the first post/ posts of new users using keywords (the downside is you will still have to approve some posts or get a moderator to)

2 use it in conjunction with this mod-

https://vborg.vbsupport.ru/showthread.php?t=271057

then if new users do make any spam posts they can be dealt with in one click

Well it works for me. But I only have GlowHost blocking registrations - I don't use it for moderating posts because I found that feature to be unreliable. That's probably why it isn't working for you.

I am not using it to moderate posts.

Thanks, but that is not what I want. And adding yet another spam killer I do not think is going to alleviate a moderation issue on spam-o-matic.

What are your GlowHost settings? As I said, it's working perfectly for me.

There are a lot of settings, which ones specifically?

If you read the intro, it appears as this is default (that there is no moderation queue ability);
"If a spammer is able to sneak past the first line of defense, and manages to post, then there are secondary, tertiary, and, uh...4th level protections too!"

So it seems GlowHost assumes that anyone that passes their filters, is ready to post.

It sounds to me like you did not follow instructions completely. I know that there are several steps to take and a lot of settings, but you can create a new usergroup with limited permissions, and set how many posts that you want to be moderated by SOM. There are a few things that the utility doesn't do, but for the most part I find it to be a great defense against spam.

Again, thank you, but you as others miss what I want.
I do not want to have post moderation. I want registration moderation.

If they can't post, what's the difference?

Can you post a screen shot of your settings? Also one of the names of any other add-ons you have installed?

I don't understand what you are trying to say. SOM does prevent known spam from registering. You do not have to moderate the first post if you do not want to primarily because it doesn't work perfectly, but it does work. Every post is moderated and has to be approved before it is posted. The problem is that you and the mods have to pay attention to all new registrations. That is an easy fix, just have new registrations sent to the mods, and yourself if you wish.

For some reason you have to pay attention to the threads in question because moderated threads do not show up in the way they should. Having a new post mod resolves this issue, unless they register and never post! I only moderate the 1st post because of a couple of problems with SOM.

1) you do not have the option to submit new spam IP's and e-mails to stopforumspam. In order to do this you have to manually go to SFS and enter the information.

2) Do not check user names! This is a big drawback, but if you check user names you will have a lot of people blocked for the site even though they are not spammers.

3) Many people have issues with the database, and there are so many times that it's mentioned how to fix it in the thread, but with over 120 pages of posts it is difficult to find. They end up not using it because they do not know how to fix the error.

4) If you just want to cover registration, there are many other options to use. I use a mod created by BOP5 that is great. Here is the link: No Spam Image Enhancement Link

That mod stops bot registration pretty well because you can use multiple images that you find and set up.

As djbaxter mentioned a screen shot of your settings may help us out with your current situation.

If you don't want post mod then turn it off I had it turned off when I had forums just go to the settings and disable the option

I love people that say "Do it my way". The reason is because some registrations stand out as being spam, and I want to stop them from posting anything. Some spammers are clever and will post a few "real" messages and then insert some spam signature. Please do not tell me to get this add-on and that add-on. I simply want all registrations to be sent to me for approval AFTER spam-o-matic has blocked the obvious ones.

Again, thanks, but you are missing the point.
I do not want this.
What I want is for new registrations that clear Spam-o-Matic to come to me for final approval.

Great, superb. How does that give me what I want? I never posted about wanting or not post mod. You and others have suggested it. I have kept saying I do not want it, and then you tell me to turn something off I never had turned on in the first place!

Thanks, but I think this is a bit too much for me to put up on this forum. I will ask the developer. But, truly, thanks for trying.

You can add the option to submit a spammer to the database by creating a small plugin to add the feature to the user profile in your AdminCP:

See https://vborg.vbsupport.ru/showpost....postcount=1821 and https://vborg.vbsupport.ru/showpost....postcount=1826 in this thread.

Have you even took the time to look at the settings and not just the settings of this mod

Your smarmy comments are sure to inspire all of us to come to your aid...

That said, at no point did I mention any additional addons.

Antique Swords,
Turn off the moderation option in SOM.
Go to User Registration Options and find a line that says, "Email Address to Notify About New Members" and place your e-mail in there.

You did not come to my aid. You made a curt response. And you inspired me to respond as I did.

Hi
Thanks. But isn't this only turning off post moderation functions? I have looked and it seems so. I presume you mean Auto-Moderation: Enable? If so, all of the things it turns off are to do with posting, not registration.

I also emailed the developer, and it appears (I think, from what he said), that it is not possible to do what I want. So I guess I must moderate the posts of Newbies, which is not what I want to do.

But thanks to those that tried to help.

Yes, thank you. I have been through this on the forums on vb.org and filed a help ticket with vb.com. So I have done everything. It simply is not possible to have Spam-o-Matic moderate registrations to remove the known spam and then have the remainder come to me for final approval.

Because I have set up various mandatory questions (spammers always answer off topic or badly), country flags (spammers tend to select no fag / the default flag), etc., I easily see the spammers that get past Spam-o-Matic. I MUCH prefer this.

Good. Then it's settled. SOM won't do what you want. Let's all move past this now.

@Antique-Swords

I agree with Syxguns, BUT you also need to tick 'yes' to Moderate New Members and tick 'no' to Verify Email address in User Registration Options.

You will receive an email for new registrations and you can validate the new registration from the ACP and send a manual approval or denial letter to new registered member awaiting approval.
Also go into usergroups/Users Awaiting Moderation and setup the group to allow user his/her permissions until approved by you.

I've used this setup before with SOM and it works fine. SOM would have to be recoded in order to do what you want it to do, so this is the best work around fix for what you are wanting to do.

Good luck...

Thanks for all your "help"

I'm always glad to help. Have a great week!

Can you not just place approved members to the "awaiting moderation" group instead?

I get this error when I try to install :

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

Using VB 4.2 MySQL Version : 5.5.24-cll

Any suggestions ?

Change all occurence of

to

in the XML and that will solve the DB Errors.

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_remotecache`(
`date` DATETIME NOT NULL,
`field` VARCHAR(20) NOT NULL,
`is_spambot` INT NOT NULL,
`data` VARCHAR(255) 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 6
Error Number : 1064
Request Date : Wednesday, August 8th 2012 @ 03:02:34 PM
Error Date : Wednesday, August 8th 2012 @ 03:02:34 PM

IP Address : 94.59.232.82
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll

i have same problem ,, i change this code to xml file

but same problem

You have missed some

missed from where .. that xml file .

can u tell me how to get stopforumspam key ..

U will find a link in the settings near where u input the key

Another member said that you can change the "TYPE=MyISAM", to "ENGINE=MyISAM" but I just removed the items. It shows up 3 times. If you want to see the link where I first made the correction it is located here: https://vborg.vbsupport.ru/showpost....postcount=1639

It's really clear as I have highlighted in RED the 3 places to make changes.

Would rather not remove better to just change them. Don't understand why some are having this problem in the first place

When I first had the problem I did a little research to find that the newer versions of MySQL had tighter security and did not support some of the older commands.

By reading this information again, I guess I could have changed it to ENGINE instead of TYPE, but I didn't. The mod works so that is all I need! The problem is many people do not understand how to track down the errors they receive in the database. But regardless of that we still have some people that just don't bother to read! There are a lot of little steps in setting this mod up and people just want to install and it run 100% without even looking in the AdminCP!