vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=248042

fly 04 Aug 2012 15:50

Quote:

Originally Posted by Antique-Swords (Post 2354368)
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.

Alibass 04 Aug 2012 19:30

Quote:

Originally Posted by Syxguns (Post 2354117)
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.

@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...

vb50kgpoo 05 Aug 2012 15:21

Quote:

Originally Posted by fly (Post 2354376)
Good. Then it's settled. SOM won't do what you want. Let's all move past this now.

Thanks for all your "help"

fly 05 Aug 2012 16:12

Quote:

Originally Posted by Antique-Swords (Post 2354667)
Thanks for all your "help"

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

Froberg 06 Aug 2012 15:28

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

salar007 08 Aug 2012 15:34

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 ?

ForceHSS 08 Aug 2012 17:19

Quote:

Originally Posted by salar007 (Post 2355534)
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


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.

pbforum 08 Aug 2012 20:00

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

ForceHSS 08 Aug 2012 20:10

You have missed some

pbforum 08 Aug 2012 20:14

missed from where .. that xml file .

pbforum 08 Aug 2012 20:19

can u tell me how to get stopforumspam key ..

ForceHSS 08 Aug 2012 20:30

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

Syxguns 09 Aug 2012 00:06

Quote:

Originally Posted by pbforum (Post 2355618)
missed from where .. that xml file .

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

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

ForceHSS 09 Aug 2012 02:41

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

Syxguns 09 Aug 2012 03:17

Quote:

Originally Posted by ForceHSS (Post 2355702)
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.

Quote:

MyISAM is the default storage engine. It is based on the older (and no longer available) ISAM storage engine but has many useful extensions.

To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option.

Normally, it is unnecessary to use ENGINE to specify the MyISAM storage engine. MyISAM is the default engine
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!


All times are GMT. The time now is 04:04.

Powered by vBulletin® Version 3.8.14
Copyright © 2022, 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.