vBulletin Mods

The Official vBulletin Modifications Site

HMBeaty 29 Nov 2011 23:10


Originally Posted by ForumUserStarte (Post 2273182)
The first time I tried, I got this "Importing Product, Please Wait..." and waiting for hours without completion

the second time I tried it, I got this error

Database error in vBulletin 4.1.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vb_glowhostspamomatic_log`(
`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

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 : Wednesday, November 30th 2011 @ 12:21:08 AM
Error Date : Wednesday, November 30th 2011 @ 12:21:08 AM
Script : http://www.speaklogic.org:88/forum/a...=productimport
Referrer : http://www.speaklogic.org:88/forum/a...?do=productadd
IP Address :
Username : admin
Classname : vB_Database
MySQL Version : 5.5.8

The fix for this has already been provided many times throughout this thread, check the last few pages or so.

(COPPA) Users Awaiting Moderation
by vivaciti
30 Nov 2011 15:51

Since installing this mod every time a user joins up (if not spammer) it says "Sent to vBulletin Registration System" but the user is then sat in the (COPPA) Users Awaiting Moderation primary usergroup rather than registered user. Am I missing some config for this mod as I can't see anywhere in the mod to alter the group it places users in.

Cheers in advance.

ForceHSS 30 Nov 2011 17:39

check coppa settings in mod and normal settings in options

vivaciti 01 Dec 2011 17:01

Cant see anything in the options for this, we dont even use COPPA in VB and its turned off.

Any other ideas, dont want to dump it if I can help it.

ForceHSS 02 Dec 2011 06:01


Originally Posted by vivaciti (Post 2273732)
Cant see anything in the options for this, we dont even use COPPA in VB and its turned off.

Any other ideas, dont want to dump it if I can help it.

have you checked the settings in this mod as you have it turned on some where

Alfa1 02 Dec 2011 23:21

Please consider to add Bad Behavior to SOM.

Its the one thing that is missing. vB BB works well, but the developer doesn't have the time to keep it up to date.

Vick98 03 Dec 2011 08:36

Excellent mod! Works for 4.1.8.

MXjunk127 04 Dec 2011 11:35

So, I cannot absolutely attribute this to your mod, but I installed it on 4.1.8 a few days ago and some of my new users are not being registered correctly...Infact, they are showing up as guests...However, guests are not supposed to be allowed to post (per permissions), and although their user names show in the newbies usergroup via the adminCP, none of their info (even email or username) is viewable in the user view of the adminCP....Kinda not good on my live forum...

The users that show of as guests show they cleared the system and got sent to registration, and they show as recently registered...

"Passed StopForumSpam checks. Sent to vBulletin Registration System."

Other Products installed:

Auto Database Backup
Change Author And Date
GlowHost - Spam-O-Matic
Make Prefixes Clickable to Filter Forumdisplay
Members who have Visited
Min Post Count / Days Registered to Use Polls BOP5
More Share Options for VB4 by BOP5 Light
One Touch Ban & Cleaner
Prevent Double Posts
Save Users' Old Email Addresses
Separate Sticky and Normal Threads
Social Networking in Postbit & Profile

Any Help would be appreciated, thanks!

GTX2 04 Dec 2011 22:51

I've noticed a problem, what happens to Users Waiting Email Confirmation usergroup !?
I no longer can see which users have confirmed their email or not....
is there any way to put this mod working only after user confirms email and not right after registering !?!?

Edit: sorry, saw someone earlier found this issue... it would really be great to still be able to have users confirming their email, just for validation as i receive many many registrations with wrong/invalid email.

tkr reptiles 05 Dec 2011 02:29

Is this going to be updated for 4.1.7 and 4.1.8? After upgrading to 4.1.7, this doesn't work half as good as it did on 4.1.5...


vivachina 05 Dec 2011 23:48


I think there is an small bug. When settings default usergroup for newbies.

Newbies Manager: Newbies Group ID
The group ID that new users will be put into immediately after successfully registering.

What is successful registration?
I have set email verification as first step.
So, my successful registration comes when the newcomer confirms his email.

But Spam-O-Matic moves the newcomer to Newbies Group ID without waiting for email confirmation. And should have move after email confirmation.

My mistake. This was reported several. Any fix or workaround?

watty005 06 Dec 2011 17:56

How do I delete those 'web hosting' links in the footer of my forum??

ForceHSS 06 Dec 2011 19:06


Originally Posted by watty005 (Post 2275228)
How do I delete those 'web hosting' links in the footer of my forum??

remove them from the stop o matic options

Froberg 08 Dec 2011 16:53

.. Considering I currently have 2000+ posts awaiting moderation, I'd say that the effectiveness has fallen dramatically.

Anyone else experiencing this? :)

Oh, should mention.. this accumulated over a few days. Even had to ban newbies from commenting on blogs since they can't be spam-o-matified, and the bots were posting there...

bcilloniz 09 Dec 2011 00:49

Seems to be working ok... żAnyway to see the: "15 Spammers Denied Registration"?

I leave one web hosting link on my footer

Thanks for this mode.

All times are GMT. The time now is 21:13.

Powered by vBulletin® Version 3.8.14
Copyright © 2023, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.