[GlowHost] Spam-O-Matic - Spam Firewall stops forum spam

[dougdirac]

Occasionally but not often. Everyone has maintenance to do from time to time.

I keep my registration blocked. If they are legit users they will comeback later and register. Rather loose a few than have a ton of spammers mucking up my site.

-A

This! Just looking at my stats lately, there are so many more spammers than legit users. Also if they have trouble they just use the Contact Us link, and I can sort out whatever issues.

[rinkrat]

In the last two days I've had avout 100 spammers register and this thing is suddenly not stopping them. I tried the above change to the url and it apparently did nothing because I got a boatload of them registering last night.

Help!!

[Ross L]

In the last two days I've had avout 100 spammers register and this thing is suddenly not stopping them. I tried the above change to the url and it apparently did nothing because I got a boatload of them registering last night.

Help!!

Stop Forum Spam was down for a while, hence the registrations were getting through. Stop Forum Spam is now back online, so they should get blocked.

[Alibass]

Well, after searching the db and plugin files, I realized that there's a file uploaded to includes/ that would surely have the stopforumspam URL and it does! :D

Open includes/functions_ghsom.php and find/replace every instance of www.stopforumspam.com (http://www.stopforumspam.com) with api.stopforumspam.org

Tested and works. :cool:
SFS is working on both links. I haven't had an issue with increase spammers and they're being rejected daily on my site.

[Alibass]

This! Just looking at my stats lately, there are so many more spammers than legit users. Also if they have trouble they just use the Contact Us link, and I can sort out whatever issues.
Turn on reCAPTCHA or one of the many other CAPTCHA mods out there to stop them spamming your contact us.

[bzcomputers]

During the StopForumSpan server downtime yesterday, this mod was denying all new registrations even though my setting for:

What should happen if the remote connection times out when querying the new registration? set to Allow Registration.

This is a sample of the log details:
"Spam-O-Matic Tagged email - XXXXX@XXXXX.com Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at 'StopForumSpam: Query"

It said it passed the registration attempts on, but no registrations with this type of log details ever came through.

This amounted to quite a few registration attempts over multiple hours to be incorrectly denied by what appears to be an issue with the mod.

Can anyone else confirm this issue?

I've only had this mod installed for a couple days and this is really my first experience with it ...first impressions are not so good.

[ForceHSS]

During the StopForumSpan server downtime yesterday, this mod was denying all new registrations even though my setting for:

What should happen if the remote connection times out when querying the new registration? set to Allow Registration.

This is a sample of the log details:
"Spam-O-Matic Tagged email - XXXXX@XXXXX.com Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at 'StopForumSpam: Query"

It said it passed the registration attempts on, but no registrations with this type of log details ever came through.

This amounted to quite a few registration attempts over multiple hours to be incorrectly denied by what appears to be an issue with the mod.

Can anyone else confirm this issue?

I've only had this mod installed for a couple days and this is really my first experience with it ...first impressions are not so good.

Try doing what it says on post 1999 see if that helps you

[Eslob]

Great Addon!

[cooljeba]

Just installed.. Can i totally get rid of Captcha now ?

[bzcomputers]

Try doing what it says on post 1999 see if that helps you

I will give that a shot, but without knowing exactly which urls in the file to change and which ones to leave alone I worry I might screw something up. Since the mod does seem to work correctly when their servers are up I'm not sure even changing the api address would do much to solve my original issue.

My concern still is that the issue I had really didn't revolve around whether the server could be contacted or not but rather what it did when it couldn't be contacted. When it couldn't be contacted it didn't do what it said it did nor what the settings chosen in the admincp were set up for it to do.

Is this product no longer supported by the original author? Seems like this mod has been abandoned by GlowHost.com, their last post was close to a year ago. Not really a product that many large vB forums could live without!

[ForceHSS]

I will give that a shot, but without knowing exactly which urls in the file to change and which ones to leave alone I worry I might screw something up. Since the mod does seem to work correctly when their servers are up I'm not sure even changing the api address would do much to solve my original issue.

My concern still is that the issue I had really didn't revolve around whether the server could be contacted or not but rather what it did when it couldn't be contacted. When it couldn't be contacted it didn't do what it said it did nor what the settings chosen in the admincp were set up for it to do.

Is this product no longer supported by the original author? Seems like this mod has been abandoned by GlowHost.com, their last post was close to a year ago. Not really a product that many large vB forums could live without!

As it says in that post change all of them. If it does not work you can always install the unedited one again? But if you do use this new URL you need to register with them and get a new api

[dougdirac]

My installation is working fine, and I didn't make any modifications to the code. SFS has occasionally been unreachable in the last few weeks, but has always come back eventually. I don't see what benefit there is to changing the URLs from www. to api.

[dougdirac]

Just installed.. Can i totally get rid of Captcha now ?

You should a least keep one first line of defense to weed out most of the less advanced spambots. If not a Captcha, then at least a challenge question.

[bzcomputers]

My installation is working fine, and I didn't make any modifications to the code. SFS has occasionally been unreachable in the last few weeks, but has always come back eventually. I don't see what benefit there is to changing the URLs from www. to api.

From the forum posts at StopForumSpam.com and their twitter posts it sounds like the api address at api.stopforumspam.com will be the more robust one (providing mirrors, erc.) that will allow for a lot less downtime in case of issues. The current address does not have all these capabilities and supposedly will not be getting them (from what I can tell) but still may work for some time. Currently both are working, but it is something everyone using this mod should keep on top of.

http://www.stopforumspam.com/forum/viewtopic.php?id=4653

https://twitter.com/StopForumSpam

[stalkingdatoast]

Im getting this error while trying to upload the xml file durigng installation. Please help!

[Syxguns]

@stalkingdatoast
1) Did you upload all files before trying to import the XML file?

2) Open PHPMyAdmin and make sure the have the table vb_glowhostspamomatic_log If you do not then create the table and then try it again.

[ForceHSS]

I'm getting this error while trying to upload the XML file during installation. Please help!

Here is the SQL for that table, you can add it manually from PHPMyAdmin

[SNATCH3R]

I am facing a problem when i install the mod...gives me database error.....

Database error in vBulletin 4.2.0:


Invalid SQL:
CREATE TABLE IF NOT EXISTS `abc_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 : Tuesday, September 11th 2012 @ 12:10:14 AM
Error Date : Tuesday, September 11th 2012 @ 12:10:14 AM
Script : http://www.mydomain.com/admincp/plugin.php?do=productimport
Referrer : http://www.mydomain.com/admincp/plugin.php?do=productadd
IP Address : 18.222.140.59
Username : Admin
Classname : vB_Database
MySQL Version : 5.5.23-55



Can somebody update me what could be the issue

[Syxguns]

I am facing a problem when i install the mod...gives me database error.....
Can somebody update me what could be the issue

Your MySQL Version : 5.5.23-55 doesn't recognize TYPE=MyISAM. There are 3 instances of it in the XML file. Open the XML and replace the 3 occurrences with ENGINE=MyISAM

That will fix the problem.

[fly]

vB.org REALLY needs an option for a wiki post after the OP like other sites do.

[dougdirac]

Thanks for the detail. Sounds like this mod could use an update.

I'd like the option of using Spam-O-Matic on the thread level as well as the post level.

[mark99]

Well, after searching the db and plugin files, I realized that there's a file uploaded to includes/ that would surely have the stopforumspam URL and it does! :D

Open includes/functions_ghsom.php and find/replace every instance of www.stopforumspam.com with api.stopforumspam.org

Tested and works. :cool:

Really good catch, swapped and will keep an eye on that.

[Macsee]

Well, after searching the db and plugin files, I realized that there's a file uploaded to includes/ that would surely have the stopforumspam URL and it does! :D

Open includes/functions_ghsom.php and find/replace every instance of www.stopforumspam.com with api.stopforumspam.org

Tested and works. :cool:

Can anyone confirm that this is actually a requirement i.e. that we have to change all mentions of stopforumspam.com in file functions_ghsom.php?

If that was an isolate incident with SFS going down a few days ago then ... they seem to have had another of those isolated incidents today!

[dougdirac]

I didn't do any of those changes and things are working fine for me, for now. It did set to block registrations if SFS is unavailable, however.

[djbaxter]

Can anyone confirm that this is actually a requirement i.e. that we have to change all mentions of stopforumspam.com in file functions_ghsom.php?

If that was an isolate incident with SFS going down a few days ago then ... they seem to have had another of those isolated incidents today!

No, they are not necessary at all. The issues people were experiencing had nothing to do with the specific URL but with database outages and a surge in spam in all forms over the past few days.

[MentaL]

Good mod, catches a lot but also misses a fair bit too.

[renlok]

This is honestly the greatest thing ever made.

[Snowhog]

Pardon my newbishness, but in the readme.txt is says to "Upload content of the upload folder into you forum root folder". Contained in the upload folder are the following folders:

admincp
includes

The root folder already contains a folder called includes, so I must assume that I copy the "contents of the folders" to the "designated folders" within the root folder. We don't have a folder in our root folder called admincp. We do have one called admincontrolpanel. Would that be where I copy the contents of admincp to?

[ForceHSS]

Pardon my newbishness, but in the readme.txt is says to "Upload content of the upload folder into you forum root folder". Contained in the upload folder are the following folders:

admincp
includes

The root folder already contains a folder called includes, so I must assume that I copy the "contents of the folders" to the "designated folders" within the root folder. We don't have a folder in our root folder called admincp. We do have one called admincontrolpanel. Would that be where I copy the contents of admincp to?
You have not installed many plugins just take the files and upload them to the same name folders

[bradleyj]

I got this error message...

I tried adding the tables but not sure what im doing. can someone give me a guide on what to put in here as the Mysql updated.

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 : Sunday, September 16th 2012 @ 01:17:57 PM
Error Date : Sunday, September 16th 2012 @ 01:17:57 PM
Script : http://www.topic+++++.com/admincp/plugin.php?do=productimport
Referrer : http://www.topic+++++.com/admincp/plugin.php?do=productadd
IP Address : 108.203.176.222
Username : bradleyj
Classname : vB_Database
MySQL Version : 5.5.23-55

[Syxguns]

I got this error message...

I tried adding the tables but not sure what im doing. can someone give me a guide on what to put in here as the Mysql updated.

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 : Sunday, September 16th 2012 @ 01:17:57 PM
Error Date : Sunday, September 16th 2012 @ 01:17:57 PM
Script : http://www.topic+++++.com/admincp/plugin.php?do=productimport
Referrer : http://www.topic+++++.com/admincp/plugin.php?do=productadd
IP Address : 108.203.176.222
Username : bradleyj
Classname : vB_Database
MySQL Version : 5.5.23-55

I wish there was a way to add this information in the primary post!! I won't explain in detail, but you are running MySQL 5.5 and TYPE=MyISAM is not recognized. Open the XML file with notepad++ and change the 3 occurrences of that to ENGINE=MyISAM and that will correct the problem. Don't block Username with the mod, and if you read the thread, you will see that these statements have been mentioned multiple times. :)

[dougdirac]

Feature request, or maybe someone can figure out how to do this. But I'd like better presentation of the data in the log.

I'd like to see a histogram graph of how many spammers were blocked per week, per day, per hour, etc. What caused them to be rejected. Country of origin. How many legit users made it through, etc.

That way I could get a sense of what antispam efforts are helping, etc.

Anyway to download the data as a CSV file, then I could just use Excell or Matlab or something.

[Syxguns]

Feature request, or maybe someone can figure out how to do this. But I'd like better presentation of the data in the log.

I'd like to see a histogram graph of how many spammers were blocked per week, per day, per hour, etc. What caused them to be rejected. Country of origin. How many legit users made it through, etc.

That way I could get a sense of what antispam efforts are helping, etc.

Anyway to download the data as a CSV file, then I could just use Excell or Matlab or something.

You already have two such lists available to you. The first is in the Statistics and Logs in the AdminCP, the second is in the database under the table name glowhostspamomatic_log

Date, IP address, Username, e-mail address, and a reason is given. I think that those two lists work just fine for me.

[Slugger00001]

Why is there a link under "whats going on?" that links to this vbulletin.org thread?
Can that be disabled? I already have the affiliate disabled and give thanks.

[ForceHSS]

Why is there a link under "whats going on?" that links to this vbulletin.org thread?
Can that be disabled? I already have the affiliate disabled and give thanks.

Can you show a link to this on your site and a screenshot to show what you see as I also have this installed and this is not the case with me or anyone else

[Slugger00001]

Can you show a link to this on your site and a screenshot to show what you see as I also have this installed and this is not the case with me or anyone else


attached the image.

when i click it, it takes me to this thread. Shouldn't clicking it show or hide the stats?

I see that its supposed to list who has been blocked ect ect, mine shows nothing at the moment because my forum has been turned off since i just upgraded to 4.2.0.

[Alibass]

Turn it off in your SOM settings...

[Slugger00001]

Turn it off in your SOM settings...

thanks. I overlooked it.

[Lee Roberts]

Why is there a link under "whats going on?" that links to this vbulletin.org thread?
Can that be disabled? I already have the affiliate disabled and give thanks.

Hi Slugger,

You need to look for the option that reads "Statistics: Link to Spam-O-Matic? - Link "By Spam-O-Matic" in forum statistics to vBulletin.org so others can protect their forums with Spam-O-Matic." and set this to No or Yes.

Located: Settings > Options > "Glowhost - Spam-O-Matic"

.Me

[NxT Networks]

Hello there, when I enable this: my forum throws up a 500 internal error when I try to make a new thread or reply to a post.
Any help would be appreciated! :)

[ForceHSS]

Hello there, when I enable this: my forum throws up a 500 internal error when I try to make a new thread or reply to a post.
Any help would be appreciated! :)

make sure you have the files installed in the right folders

[NxT Networks]

I'm pretty sure I do. Any help would be appreciated (:

[AFQ]

Hello guys, I really need help with this plugin. I've got my WordPress installation integrated with vB. Whenever a new thread is made in WP, its posted in a specific section in vB by a specific user but whenever i've the Spam-O-Matic enabled, it wouldnt make a new thread it vB.

This is the error it gives when I try to publish the post in WP:
Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_dm_threadpost.php(1827) : eval()'d code on line 16

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/iamextre/public_html/maximum-tech.net/forums/includes/class_dm_threadpost.php(1827) : eval()'d code on line 16

It gets published in WP but corresponding thread in vB isnt made even though it'll added that user and its user group as an exception in Spam-O-Matic's settings.

Thanks.

[shellys]

This is the best mod for vbulletin i have ever seen. Its so extensive and useful.

[naviter]

Installed on vB 4.0.2 and it works out of the box. Beautiful. Thank you guys.

[Jpolola]

Hello....
Anybody could please tell me why I received this error VIA email after uploading Spamomatic Files.

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 : Sunday, September 16th 2012 @ 07:15:11 PM
Error Date : Sunday, September 16th 2012 @ 07:15:11 PM
Script : http://www.pinoylifers.com/admincp/plugin.php?do=productimport
Referrer : http://www.pinoylifers.com/admincp/plugin.php?do=productadd
IP Address : ***********
Username : **********
Classname : vB_Database
MySQL Version : 5.5.23-55

[bzcomputers]

Hello....
Anybody could please tell me why I received this error VIA email after uploading Spamomatic Files.

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 : Sunday, September 16th 2012 @ 07:15:11 PM
Error Date : Sunday, September 16th 2012 @ 07:15:11 PM
Script : http://www.pinoylifers.com/admincp/plugin.php?do=productimport
Referrer : http://www.pinoylifers.com/admincp/plugin.php?do=productadd
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.5.23-55

Open The XML file (product-glowhostspamomatic.xml) and edit "TYPE=MyISAM" to say "ENGINE=MyISAM" in 3 places: on line 30, 38 and 47. Resave, then reimport and allow overwrite.

This is a change required for the MySQL version you have (highlighted in red above).

[Jpolola]

Open The XML file (product-glowhostspamomatic.xml) and edit "TYPE=MyISAM" to say "ENGINE=MyISAM" in 3 places: on line 30, 38 and 47. Resave, then reimport and allow overwrite.

This is a change required for the MySQL version you have (highlighted in red above).

Awesome! That fixed the Problem. Really Thank you:up:

[meditate]

Change TYPE=MyISAM to ENGINE=MyISAM in the XML file when doing a new install, and to developer please add another copy for this it would be easier. :)

NOTE: this does not affect you if you have it already installed.

[techin5]

Getting this error guys

"Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/register.php(338) : eval()'d code on line 10

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/techin52/forums/register.php(338) : eval()'d code on line 10"

Tried to reinstall everything as well. No difference. cURL is installed and the other setting is enabled too

[ForceHSS]

you have not installed the file that it is asking for

[shadz]

installed

[techin5]

you have not installed the file that it is asking for

I did as asked. Uploaded the spam o matic folder to forum root, and the xml file to the plugins manager. Am i missing something?

[ForceHSS]

you have 3 files one goes to the
admincp folder glowhostspamomatic.php the next one goes into the
includes folder functions_ghsom.php and the last one goes into
incudes/xml cpnav_glowhostspamomatic.xml
then go to admincp/Plugins & Products/Manage Products scroll down and click Add/Import Product and upload the product-glowhostspamomatic.xml

[techin5]

you have 3 files one goes to the
admincp folder glowhostspamomatic.php the next one goes into the
includes folder functions_ghsom.php and the last one goes into
incudes/xml cpnav_glowhostspamomatic.xml
then go to admincp/Plugins & Products/Manage Products scroll down and click Add/Import Product and upload the product-glowhostspamomatic.xml

Sorry, might have to spell it out for me even more.

Instructions given in note document:


2.2. Upload content of the upload folder into you forum root folder


2.3. Import product-glowhostspamomatic.xml into products (Located
at
AdminCP -> Plugin System -> Manage Products -> Add/Import Product)

That's the only 'installation' instructions of which I did both. Then what next?

[ForceHSS]

What part do you not understand from my above post. I can talk to you on skype if you need help

[techin5]

What part do you not understand from my above post

All of it? The reason I say that is because I followed the post instructions. My questions if.. since I did those two things in the instructions. The issue is WHAT do I do next, after I've done what I did.

[ForceHSS]

pm sent

[oddmud]

I see request after request after request of a whitelist option. Any news on that front? No one has a solution. I have to stop using the plugin (even though it's AWESOME) because I'm getting far to many normal people that can't register due to being listed as spammers, and they aren't.

[Budabing]

I see request after request after request of a whitelist option. Any news on that front? No one has a solution. I have to stop using the plugin (even though it's AWESOME) because I'm getting far to many normal people that can't register due to being listed as spammers, and they aren't.
I found that disabling the username check but keeping the IP and email check enabled has fixed the issue of banning genuine users while keeping all the spammers and bots at bay. Have you tried this setting yet?

[oddmud]

I found that disabling the username check but keeping the IP and email check enabled has fixed the issue of banning genuine users while keeping all the spammers and bots at bay. Have you tried this setting yet?

I had not, so right now I just changed it too IP and Email check only. Lets see how that works.

[tkr reptiles]

I have this installed, and it was working well. Lately I have been getting hammered every day with tons of spammer accounts. Is there an update for this? Will there be soon? Is there another option that will work???

[tkr reptiles]

I think I figured it out. Somehow the option of what to do when a spammer is detected got changed to allow them to register, not block registration.

[JakeSully]

Hi i installed this addon but problem is it wont display like it does on this picture https://vborg.vbsupport.ru/attachment.php?attachmentid=126506&d=1297118184 i'm ussing vbulletin 4.2.0 and all i see is title but nothing more under it :( also title is click able and it takes me to this topic so idk whats wrong :(

[bzcomputers]

Hi i installed this addon but problem is it wont display like it does on this picture https://vborg.vbsupport.ru/attachment.php?attachmentid=126506&d=1297118184 i'm ussing vbulletin 4.2.0 and all i see is title but nothing more under it :( also title is click able and it takes me to this topic so idk whats wrong :(

Yes, the title should be hyperlinked and nothing should display under it when first installed. Depending on how you set your admin settings depends on what will eventually show there. Check under statistics and logs for "GlowHost - Spam-O-Matic Logs" to see if it is running.

[JakeSully]

But on pic link i attached it shows that it should say alot of txt under name like of how meny spammers is blocked and so :/

[bzcomputers]

But on pic link i attached it shows that it should say alot of txt under name like of how meny spammers is blocked and so :/

Not until it actually blocks spammers, until then it will be blank. If you have a slow site it could be blank for awhile.

[BGN64]

Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

[bzcomputers]

Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

http://www.stopforumspam.com/add

[CharlieDelta]

Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

You can use this plugin (https://vborg.vbsupport.ru/showpost.php?p=2344079&postcount=1821) and this code change. (https://vborg.vbsupport.ru/showpost.php?p=2344884&postcount=1826)

Works for me.

[TheSupportForum]

You can use this plugin (https://vborg.vbsupport.ru/showpost.php?p=2344079&postcount=1821) and this code change. (https://vborg.vbsupport.ru/showpost.php?p=2344884&postcount=1826)

Works for me.

just do this for code






if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");
if ($vbulletin->options["glowhostspamomatic_apikey"])
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['vbstopforumspam_apikey'] . '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');

else
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');
}



all he needed to do is use the settings from the product

is the old stopforumspam setting string for the other product he is using
$vbulletin->options['vbstopforumspam_apikey']this is glowhost setting string for stopforumspam api
$vbulletin->options['glowhostspamomatic_apikey']

[ForceHSS]

just do this for code




if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");
if ($vbulletin->options["vbstopforumspam_apikey"])
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['glowhostspamomatic_apikey'] . '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');

else
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');
}
I tried that did not work you need to use the code change

[TheSupportForum]

I tried that did not work you need to use the code change

ah i just rechanged the code again i missed something

anyways it works for me on vb 4.2.0 with no issues

here is my screenshot

https://vborg.vbsupport.ru/

[ForceHSS]

ah i just rechanged the code again i missed something

anyways it works for me on vb 4.2.0 with no issues

here is my screenshot

https://vborg.vbsupport.ru/

this is the code I am using is your code the same if not post yours

if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="oysr2wv46udtbp"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}

[TheSupportForum]

this is the code I am using is your code the same if not post yours

if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="oysr2wv46udtbp"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}


yeah you are just using it as a plugin and nothing to do with the product as there are no vb variables shown for glowhost product

mine is based on [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?p=2368740#post2368740)
vb variables which is why i suggested using my code as it fits the need for the plugin addon for stopforumspam

[ForceHSS]

I am using this plugin (https://vborg.vbsupport.ru/showthread.php?t=248042)
with the above coding as
Product: vBulletin
Hook Location: useradmin_edit_column1
Title: Submit to StopForumSpam.com
Execution Order: 5
Plugin PHP Code:

then putting in the above code

If this is wrong say

[TheSupportForum]

I am using this plugin (https://vborg.vbsupport.ru/showthread.php?t=248042)
with the above coding as
Product: vBulletin
Hook Location: useradmin_edit_column1
Title: Submit to StopForumSpam.com
Execution Order: 5
Plugin PHP Code:

then putting in the above code

If this is wrong say

its fine as you are using it as a seperate plugin from this product

i just meant that the code i changed is based on the product itself thats all

[dougdirac]

This mod has been a life saver. I just want to point out, though, that I finally got around to changing my Human Verification Options from ReCaptcha to a very easy Question and Answer, and now I hardly have any spam even getting to the SFS check stage. I used to see one every few minutes, no I only have one every several hours. Pretty awesome.

[imported_dfmafia]

I lost the stats in the WGO box. whats the code to re-insert it manually?

An uninstall and install isn't working.

[Floyd R Turbo]

Newbie to forums here, I just purchased and attempted to install vB5 beta 11 and gave up after 3 installs and then realizing that it was a bad idea to try out a beta when I hadn't done anything beyond HTML in 10 years LOL, and no plug-ins were written for it yet.

Installed vB4.2 P2 with ease after the learning steps above and then installed keycaptcha (LOVE that thing!), SOM and vB Bad Behaviour, thanks to links on vbulletin.com. Got an Aksimet and StopForumSpam keys also. Also added a Q&A to the registration screen. I think with all of that, I may never have much of a spammer problem at all.

Had trouble with getting new "test" users set up, it was pegging every attempt as a spammer, turning SOM off fixed it, but I still wanted it up and running. Read the first 300 and last 200 posts on this thread (roughly) and determined that I hadn't configured it right, but there really isn't a guide for configuring. I figured out from various posts that I needed to

1) disable Akismet in vBulletin and let SOM handle it
2) decrease the SFS remote expiry from 90 days to 10 days (I believe it was this that fixed the registration problem)

Can anyone think of anything else I should consider? I do not have newbies manager on. I do have auto-moderation on, but I might shut this off unless a problem arises.

From reading what I have read on here and vbulletin.com, I am very happy to have found the tools to prevent problems from happening. Now I suppose it's a waiting game to see if the bots can break keycaptcha.

Thank you so much to the developers on this site. The installs went very smoothly...so far, so good!

[Alibass]

Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.
It's not a good idea to report someone as a spammer unless they have actually spammed your site. This can cause problems for other users who may share that IP from registering at other sites.

[Derek765]

Database error in vBulletin 4.2.0:
I uploaded all files to their right directorys then went to Import product-glowhostspamomatic.xml and got this following error.

Anyone know what this means?


Invalid SQL:
CREATE TABLE IF NOT EXISTS `MY DATABASE NAME_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

[TheSupportForum]

Database error in vBulletin 4.2.0:
I uploaded all files to their right directorys then went to Import product-glowhostspamomatic.xml and got this following error.

Anyone know what this means?


Invalid SQL:
CREATE TABLE IF NOT EXISTS `MY DATABASE NAME_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

change all instances of

) TYPE=MyISAM;;

to

) ENGINE=MyISAM; ');

in product-glowhostspamomatic.xml

[Derek765]

Alright got it installed fine and setup but now its not displaying any information in the block, a image is provided below.

Any idea?

https://vborg.vbsupport.ru/attachment.php?attachmentid=141567&stc=1&d=1349358896

[TheSupportForum]

Alright got it installed fine and setup but now its not displaying any information in the block, a image is provided below.

Any idea?

https://vborg.vbsupport.ru/attachment.php?attachmentid=141567&stc=1&d=1349358896

This means no spammers have tried to register yet

[Derek765]

Oh alright, didn't know if it would still show information with 0 spammers and ect or not.

[Harpo]

Very happy with this. saved me a lot of work.

Thanks!

[joeychgo]

I see request after request after request of a whitelist option. Any news on that front? No one has a solution. I have to stop using the plugin (even though it's AWESOME) because I'm getting far to many normal people that can't register due to being listed as spammers, and they aren't.

Yes, it would be very nice if this could work. ESPECIALLY if there was a way to whitelist for a period of time only. (ie 7 days)

Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

I catch spammers who register alot - before they post. They arent listed in the database. Its cumbersome to go to stopforumspam and add the entry as wel as manually deleting the user. It would be great if this could be a one click deal like on posts.

Also, it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

[TheSupportForum]

Yes, it would be very nice if this could work. ESPECIALLY if there was a way to whitelist for a period of time only. (ie 7 days)



I catch spammers who register alot - before they post. They arent listed in the database. Its cumbersome to go to stopforumspam and add the entry as wel as manually deleting the user. It would be great if this could be a one click deal like on posts.

Also, it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

add this if you haven't already
add this plugin

Product: vBulletin
Hook Location: useradmin_edit_column1
Title: Submit to StopForumSpam.com
Execution Order: 5
Plugin PHP Code:



if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");
if ($vbulletin->options['glowhostspamomatic_apikey'])
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['glowhostspamomatic_apikey'] . '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');

else
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');
}



http://img441.imageshack.us/img441/1892/aaa99c40a68f46289223c1e.png



this will allow you to submit them from admincp when viewing users details in admincp

[Syxguns]

it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

Here is a good website to use. Add the rules to your .htaccess file to block from countries you do not want on your site.

Of course another way to do this is within vB. Settings > Options > User Banning Options
You have the option to use "*" as a wildcard so it will take a little time to do, which is why using the .htaccess is better.

http://www.ip2location.com/blockvisitorsbycountry.aspx

[Chadi]

It would be awesome to have a convenient way to submit spam info directly from the vb admin panel to stopforumspam.com

[djbaxter]

It would be awesome to have a convenient way to submit spam info directly from the vb admin panel to stopforumspam.com

There already is. I've posted this before:

1. You'll need the SFS API key. Replace "1234567890abcd" in last line below with valid API.

2., AdminCP >> Plugins and Products >> Add New Plugin

3. Details for plugin

Product: vBulletin

Hook Location: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution Order: 5

Plugin PHP Code:


if (!is_member_of($user['usergroupid'], 6)) // dont ban admin account
{
print_table_break('', $INNERTABLEWIDTH);
print_table_header("Submit to StopForumSpam");

print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'.
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="1234567890abcd"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}

[Robbed]

Any way to view stats without showing on forum home? besides log files

[bzcomputers]

Any way to view stats without showing on forum home? besides log files

You can always add this line at the top of plugin "GlowHost - Spam-O-Matic - Stats render":

if ($vbulletin->userinfo['usergroupid'] == 6)

That will make it only visible to Admins.

[postcd]

Hi, i got error when im adding this Mod to my vbulletin. I select the xml file and click import, it shows:

Database error in vBulletin 4.1.10:

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

[ForceHSS]

Hi, i got error when im adding this Mod to my vbulletin. I select the xml file and click import, it shows:

Database error in vBulletin 4.1.10:

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
) TYPE=MyISAM;;

to

) ENGINE=MyISAM; ');

in product-glowhostspamomatic.xml

[TheSupportForum]

for those who are getting any database error just open
product-glowhostspamomatic.xml

and replace all instances of

) TYPE=MyISAM; ');

with

) ENGINE=MyISAM; ');
this has been mentioned and ask alot of this thread please ensure you all read it

[Robbed]

I'm using duplicate up report by bop5 ip and threads created with this mod are moderated. The userid and usergroup are on the whitelist.

The logs show

2012-10-10 04:13:41 Unregistered Post put under moderation based on Auto-Moderation URL count

[TheSupportForum]

I'm using duplicate up report by bop5 ip and threads created with this mod are moderated. The userid and usergroup are on the whitelist.

The logs show

2012-10-10 04:13:41 Unregistered Post put under moderation based on Auto-Moderation URL count

that has nothing to do with this mod, please post support in BOP5 thread
https://vborg.vbsupport.ru/showthread.php?t=282525

[Corrine.]

First, thank you for this add-on. In the 7 months since it was added, Glow-Host Spam-o-Matic has blocked ~1,000 spammers.

What concerns me is that for the past several days, spammers with very high reports at StopForumSpam are being passed to registration -- not all but 50+ have been passed through just the past three days. It isn't an issue with StopForumSpam being unavailable, as each as the indication, "Passed StopForumSpam checks. Sent to vBulletin Registration System."

Two examples from today:


http://www.stopforumspam.com/ipcheck/60.173.10.57 -- 60.173.10.57 appears in our database 3704 times
http://www.stopforumspam.com/ipcheck/61.191.188.49 -- 61.191.188.49 appears in our database 1058 times

None of them are over the 90-day setting, which we use as recommended. We also use the recommended 30 minute setting for "StopForumSpam: Data Fetching - Cache".

Any suggestions? (Site: Sysnative.com)

[TheSupportForum]

First, thank you for this add-on. In the 7 months since it was added, Glow-Host Spam-o-Matic has blocked ~1,000 spammers.

What concerns me is that for the past several days, spammers with very high reports at StopForumSpam are being passed to registration -- not all but 50+ have been passed through just the past three days. It isn't an issue with StopForumSpam being unavailable, as each as the indication, "Passed StopForumSpam checks. Sent to vBulletin Registration System."

Two examples from today:

http://www.stopforumspam.com/ipcheck/60.173.10.57 -- 60.173.10.57 appears in our database 3704 times
http://www.stopforumspam.com/ipcheck/61.191.188.49 -- 61.191.188.49 appears in our database 1058 timesNone of them are over the 90-day setting, which we use as recommended. We also use the recommended 30 minute setting for "StopForumSpam: Data Fetching - Cache".

Any suggestions? (Site: Sysnative.com)

ouch, well it seems china it hitting alot of vbulletin forums over the last week
i added an antispam register to my forum found here
https://vborg.vbsupport.ru/showthread.php?t=288742
if you follow it step by step, it stops the registration from spammers, harvesters etc
its somthing i added the other day to the mods

[Corrine.]

Thank you, simonhind. Believe me, China is hitting other forum software just as hard.

Since I posted earlier today, we decided to supplement with NoSpam! Image Enhancement (New version of No Spam! for Custom Image Verification) (https://vborg.vbsupport.ru/showthread.php?t=265845) and will see how that goes.

In the meantime, I'll share information about AbyssGuard with the rest of the Admin Team to consider.

[Alibass]

Thank you, simonhind. Believe me, China is hitting other forum software just as hard.

Since I posted earlier today, we decided to supplement with NoSpam! Image Enhancement (New version of No Spam! for Custom Image Verification) (https://vborg.vbsupport.ru/showthread.php?t=265845) and will see how that goes.

In the meantime, I'll share information about AbyssGuard with the rest of the Admin Team to consider.
I have been using this one and it really works well.

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

[Bluefin221]

I installed this three weeks ago after one day coming on and having over 100 pending accounts most of which were spam, in those three weeks it has stopped 6987 Spammers which is an insane number, still though 20/30 are getting through per day but as I have members on approval then we catch them away.

[onestorydown]

Running VB 4.2.0 - and am getting this error message when trying to upload the product-glowhostspamomatic.xml file:

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, October 11th 2012 @ 07:54:55 PM
Error Date : Thursday, October 11th 2012 @ 07:54:56 PM
Script : http://yyyyyyyyyyyyyyy.com/forum/admincp/plugin.php?do=productimport
Referrer : http://yyyyyyyyyyyyyy.com/forum/admincp/plugin.php?do=productadd
IP Address : 70.139.218.237
Username : HIIIIIIIII
Classname : vB_Database
MySQL Version : 5.5.20-log

Any thoughts or tips, tricks on how to get this fixed?
Thanks!!!!!!!!

[bzcomputers]

Any thoughts or tips, tricks on how to get this fixed?
Thanks!!!!!!!!

Just needed to read a few posts back...

You can find the answer to this in posts: 2047, 2049, 2083, 2096, 2097.

[onestorydown]

Just needed to read a few posts back...

You can find the answer to this in posts: 2047, 2049, 2083, 2096, 2097.

Ughhh, I can't believe I missed those. THANK YOU for helping out a fellow Texan. :) I'm multi tasked too thin since I missed all of these...

Works now!:D

[jskoh]

im getting a database error upon importing the product. what is wrong?

[Uberguilds]

Excellent MOD, I was using the previous version but after installing 2.0 I was getting MySQL errors while trying to add a new usergroup

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'

To fix this I had to remove an old file called :
?/forum/includes/xml/bitfield_glowhostspamomatic.xml
So make sure you remove this file if you are upgrading, this file is not included in the new 2.0 version.

Thanks for this, helped me out huge

[killerford]

I've just read this in the read me file

'' ==
* Please note, for this plugin to work, cURL must be installed on the server
or allow_url_fopen enable in PHP settings '' What does this mean?

[Bluefin221]

I've just read this in the read me file

'' ==
* Please note, for this plugin to work, cURL must be installed on the server
or allow_url_fopen enable in PHP settings '' What does this mean?

Its a server setting, you would need to speak with your hosts or if you run your own server you would need to make sure these settings are available.

[killerford]

Its a server setting, you would need to speak with your hosts or if you run your own server you would need to make sure these settings are available.

Thanks for the help bluefin.

[Cybex]

First of all I would like to say that this is a fantastic piece of software, thank you very much for sharing this with everybody. I installed it 1 day ago and when I tested it some more I will definitely donate to the author, much deserved!

Question: Is it possible to check the current user database to see if users match the stopforumspam database? I have a forum with over 500,000 users and I'd like to check if there are spammers amongst them.

[TheSupportForum]

First of all I would like to say that this is a fantastic piece of software, thank you very much for sharing this with everybody. I installed it 1 day ago and when I tested it some more I will definitely donate to the author, much deserved!

Question: Is it possible to check the current user database to see if users match the stopforumspam database? I have a forum with over 500,000 users and I'd like to check if there are spammers amongst them.

this is designed for new user registrations

[Cybex]

Perhaps it would be possible to add the feature I described?

[Harpo]

Its breaks my footer. I'm using pureVBs Gametime theme.

[TheSupportForum]

Its breaks my footer. I'm using pureVBs Gametime theme.

disable sponsors

[Vick98]

For some reason the spam statistics are not shown at the bottom of the forum. Any suggestions?

[TheSupportForum]

For some reason the spam statistics are not shown at the bottom of the forum. Any suggestions?

its not supposed to unless you have spammers try to register

example
http://img210.imageshack.us/img210/6155/aeb8bcf3a283470b86e05e8.png

[JakeSully]

Hi everyone idk if anyone have already found a fix for this error about TYPE=MyISAM; '); line if not to fix it just open .xml file with notepad++ and remove all the TYPE=MyISAM; '); lines you can find it should look like this

) TYPE=MyISAM; ');

remove only TYPE=MyISAM; '); leave the ) where it is then save and re-import the .xml and you will see that import will be a success :) just did that on my forum and import went through fine :P

P.S new problem doing that will not get tables created for some strange reason :/

[TheSupportForum]

Hi everyone idk if anyone have already found a fix for this error about TYPE=MyISAM; '); line if not to fix it just open .xml file with notepad++ and remove all the TYPE=MyISAM; '); lines you can find it should look like this

) TYPE=MyISAM; ');remove only TYPE=MyISAM; '); leave the ) where it is then save and re-import the .xml and you will see that import will be a success :) just did that on my forum and import went through fine :P

P.S new problem doing that will not get tables created for some strange reason :/

lol go back a few pages, which you should of done in the first place,
myself including many have already posted this info

look here
https://vborg.vbsupport.ru/showpost.php?p=2371788&postcount=2096
https://vborg.vbsupport.ru/showpost.php?p=2371793&postcount=2097

there are plenty more

[squidsk]

Incidentally, it is probably a bad idea to remove the Type=MyISM as that creates the tables using the default table type that is set for mysql, this is not guaranteed to by MyISM. The better option is to change Type=MyISM to Engine=MyISM as this removes the error and preserves the table type as the author intended.

[john_rsd]

After installing Spam-O-Matic I found that I couldn't post new threads or replies on my board.

Goes to a HTTP 500 Error.

Found that by disabling the items below I can then post OK.

GlowHost - Spam-O-Matic: Replies Control postdata_presave
GlowHost - Spam-O-Matic: AKISMET SPAM filter newpost_process
GlowHost - Spam-O-Matic: First Post/Thread Control threadfpdata_presave

Any ideas where I'm going wrong?

[My Hattiesburg]

I installed this last night, and already everyone on the board is impressed with it! Good job!

[achouza]

I installed this plugin and added a bunch of bad words that are being blocked successfully.

However when a user enters the bad words in the title of a new post (and not in the body) the plugin does not block that post.

Is this inline with everybody elses experience? Is there any way so that the bad word block also applied to the titles?
Thanks!

[ForceHSS]

I installed this plugin and added a bunch of bad words that are being blocked successfully.

However when a user enters the bad words in the title of a new post (and not in the body) the plugin does not block that post.

Is this inline with everybody elses experience? Is there any way so that the bad word block also applied to the titles?
Thanks!

use the Censorship Options for words will work better

[AlpineZone]

Does anyone get false positives on this? Is there a way to remove all US based IP's.

Also; do you need to go to a specific post and click Glowhost, or can I just "delete posts as spam" right from the main forum page?

[ForceHSS]

Does anyone get false positives on this? Is there a way to remove all US based IP's.

Also; do you need to go to a specific post and click Glowhost, or can I just "delete posts as spam" right from the main forum page?

clicking glowhost sends it to there db and in turn builds it up so it stops more spammers. Disable username so you dont get the false positives

[john_rsd]

After installing Spam-O-Matic I found that I couldn't post new threads or replies on my board.

Goes to a HTTP 500 Error.

Found that by disabling the items below I can then post OK.

Any ideas where I'm going wrong?

Anyone?

I also don't get any Glowhost details in the Statistics and I'm set as a SuperAdmin.

Tried upgrading Vbulletin to the latest version and uninstalling Spam-O-Matic then re-installing but no luck.

On a plus note I've had no spammers register (that I know of) in the past 24 hours.

[TheSupportForum]

Anyone?

I also don't get any Glowhost details in the Statistics and I'm set as a SuperAdmin.

Tried upgrading Vbulletin to the latest version and uninstalling Spam-O-Matic then re-installing but no luck.

On a plus note I've had no spammers register (that I know of) in the past 24 hours.

spammers are not going to contantly register on your sites 24/7

i get hit 2 maybe 3 a week, sometimes 7 in 1 day
it depends on bot activity too

[iputinwork]

I'm having an issue that shows glowhostspamomatic_stats table cannot be found. Error Number : 1146

I've checked the phpmyadmin and I don't see any glowhostspamomatic table either. I've uninstalled and re-installed it but no joy.

[killerford]

I think this might be blocking way to much. A lot of members that want to come in to apply for our clan seems to be getting banned or moderated also. Anyone know what the settings need to be so it's not banning or moderating everything?

[Syxguns]

I think this might be blocking way to much. A lot of members that want to come in to apply for our clan seems to be getting banned or moderated also. Anyone know what the settings need to be so it's not banning or moderating everything?

First do NOT check usernames. That will help a lot. You may still have a few that are blocked because they use a proxy. If the proxy IP is registered with stop forum spam, then your user will need to register with their standard IP address. Not having usernames selected should help.

Turn off auto moderation if you do not want posts to be moderated.:up:

[john_rsd]

spammers are not going to contantly register on your sites 24/7

Seems that no one can Register on my site, that's one way to stop the spammers. :)

It just goes to a HTTP 500 error like my message before about posting and replying, looks like I'm out, will have to uninstall this and try something else. :(

[Vick98]

For some reason newly registered users are not put in the Newbie usergroup. So they are not being moderated. Any suggestion why this may be happening?

[ForceHSS]

Seems that no one can Register on my site, that's one way to stop the spammers. :)

It just goes to a HTTP 500 error like my message before about posting and replying, looks like I'm out, will have to uninstall this and try something else. :(

looks like you have not installed in right

[ForceHSS]

For some reason newly registered users are not put in the Newbie usergroup. So they are not being moderated. Any suggestion why this may be happening?

make sure you dont let them register from facebook

[DFish]

Great mod I'm sure, but I'm getting this error:


Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions_newpost.php(532) : eval()'d code on line 11

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php5') in /homepages/0/d331508155/htdocs/SHQvB/includes/functions_newpost.php(532) : eval()'d code on line 11

Anyone know what I should do?

[john_rsd]

looks like you have not installed in right

Seems so, tried installing, uninstalling, reinstalling, updating vbulletin but all with the same result.

Not much else I can do but give up and move on..... :confused:

[ForceHSS]

Seems so, tried installing, uninstalling, reinstalling, updating vbulletin but all with the same result.

Not much else I can do but give up and move on..... :confused:

why give up, tells us what you did step by step

[ForceHSS]

Great mod I'm sure, but I'm getting this error:



Anyone know what I should do?

you need to upload the files

[john_rsd]

why give up, tells us what you did step by step

I've installed the MOD as per the instructions in the first post here.

Checked that the allow_url_fopen is active by uploading an info.php file and running this and it says its enabled.

Get the SPAM-O-MATIC option in "Control Panel, Settings, Options" and also in the Plug In manager.

No option listed under "Statistics & Logs"

There is a Stats option shown on the forum page above the Who's Online but no stats listed.

At this point no one can post new threads (goes to a HTTP 500 Error) or replies unless I disable:

GlowHost - Spam-O-Matic: Replies Control postdata_presave
GlowHost - Spam-O-Matic: AKISMET SPAM filter newpost_process
GlowHost - Spam-O-Matic: First Post/Thread Control threadfpdata_presave

Then noticed that no one could register (HTTP 500 error) unless I disabled these options too.

Don't know what else to do at this point.

One thing I was thinking it maybe could be is that the AdminCP & ModCP folders are renamed to something else on my board.

Maybe this could be something to do with it?

It's really just new registrations I'm bothered about as the forum is just used for downloading service support items, happy to moderate each registration but it would be good if the spammers were all just sent to where they belong.

[TheSupportForum]

I've installed the MOD as per the instructions in the first post here.

Checked that the allow_url_fopen is active by uploading an info.php file and running this and it says its enabled.

Get the SPAM-O-MATIC option in "Control Panel, Settings, Options" and also in the Plug In manager.

No option listed under "Statistics & Logs"

There is a Stats option shown on the forum page above the Who's Online but no stats listed.

At this point no one can post new threads (goes to a HTTP 500 Error) or replies unless I disable:

GlowHost - Spam-O-Matic: Replies Control postdata_presave
GlowHost - Spam-O-Matic: AKISMET SPAM filter newpost_process
GlowHost - Spam-O-Matic: First Post/Thread Control threadfpdata_presave

Then noticed that no one could register (HTTP 500 error) unless I disabled these options too.

Don't know what else to do at this point.

One thing I was thinking it maybe could be is that the AdminCP & ModCP folders are renamed to something else on my board.

Maybe this could be something to do with it?

It's really just new registrations I'm bothered about as the forum is just used for downloading service support items, happy to moderate each registration but it would be good if the spammers were all just sent to where they belong.

the admincp folder in GlowHost_-_Spam-O-Matic_v2.0.2_VB4\upload
all files within that should be placed in your renamed admincp folder
its common knowledge

[john_rsd]

the admincp folder in GlowHost_-_Spam-O-Matic_v2.0.2_VB4\upload
all files within that should be placed in your renamed admincp folder
its common knowledge

Many thanks :up:

Seems to have done the trick, now have Glowhost in the Status & Logs and I can post with it running.

[Krusty1231]

About Spam-O-Matic 2.0:
Spam-O-Matic 2.0 is a spam firewall for your vBulletin Forums version 4.x and later. It prevents known spammers from registering on your forums. If they can't register, they can't spam! This data comes from the stopforumspam.com spammer database.

I just wanted to ask something about this fantastic mod.

On my forum we allow unregistered guests to post in certain forums. (It uses a captcha system) and I do believe this mod is responsible for catching those spam attempts, and auto deleting them. (Even tho they are NOT registering or attempting to)

Every once in awhile we get a legit message that goes to moderation (as I want it to) but the 100's of others (all spam) never make it to moderation and are deleted automatically.

The footer stats in the WGO box indicate that:

392 Spammers Denied Registration
959 Spammy Posts Automatically Moderated

One of those unexpected happenings I noticed this mod is doing.

Fantastic work.....lol.....it is this mod doing that right?

[Vick98]

For some reason newly registered users are not put in the Newbie usergroup. So they are not being moderated. Any suggestion why this may be happening?

make sure you dont let them register from facebook




I have Facebook registration disabled. New registered user are not being moderated and placed in the newbie user group. Any suggestions?

[ForceHSS]

check custom plugins

[TheSupportForum]

I have Facebook registration disabled. New registered user are not being moderated and placed in the newbie user group. Any suggestions?

create a copy of Registered User, give slightly less permissions
then if there legit move them to registered users

spammers are using blog posts, so i suggest a newbie group with blog posting turned off

[SnaKe |WiH|]

First, Thank you for this plugin!

I have the plugin installed and set up with keys from both Akismet and Stopforum. I believe the plugin is working because I see 3 new accounts to moderate in the admincp (even though I don't have moderate users enabled in vb settings).

I don't see the stats showing up in the forums though when I look at the footer. Also, I put the "Give thanks" in the copyright, but I don't see it ( I also tried footer)....and I really want to get that in their to give thanks!

Thank you for any help
SnaKe
www.warishellgaming.com

[Jonm]

I've had over 100 new spamming members join up over the last few weeks, it seems this mod is missing quite a few now.....

www.staffs-vw.co.uk

[Sushubh]

right. same behavior here. they do not post. but tons of weird name appearing as new members:

bdizzycjniory742
agregoraspitay3555
Alencysewcesk
apittyswft3204
bolgaumaaleya5726
aamexiguoume66

most of them are using yahoo mail. i wonder what has changed!

[fly]

Weird. I barely have any spammers get through at all. Are you (hopefully) using other human verification?

[mgmuranaka]

I am getting the following error when I try to delete posts:

Parse error: syntax error, unexpected T_STRING in /home/seismi7/public_html/forum/includes/class_core.php(4637) : eval()'d code on line 4

I haven't found a solution to fix this. Any ideas?

[TheSupportForum]

I am getting the following error when I try to delete posts:

Parse error: syntax error, unexpected T_STRING in /home/seismi7/public_html/forum/includes/class_core.php(4637) : eval()'d code on line 4

I haven't found a solution to fix this. Any ideas?

disable this mod first then try again
see if you get the same error, if you do you know its not [GlowHost] Spam-O-Matic

[mgmuranaka]

Thanks for response Simon, I've tried that already and the error is definitely coming from SpamOMatic

[mgmuranaka]

Also, how do I use the Easy Cleanup tools?

[Jonm]

right. same behavior here. they do not post. but tons of weird name appearing as new members:

bdizzycjniory742
agregoraspitay3555
Alencysewcesk
apittyswft3204
bolgaumaaleya5726
aamexiguoume66

most of them are using yahoo mail. i wonder what has changed!

look similar to some of the new members I'm getting

[Meestor_X]

D) Newbies Manager
Should you decide to enable this option, you can create a new usergroup and then tell Spam-O-Matic about it. Once SOM knows about this usergroup, and once enabled, all new users will be part of the Newbies group. The idea here is that you make a Newbies group that has limited forum permissions. For example, no signatures, no BB code, no images, and etc. This group is created completely in the vB admincp. Spam-O-Matic simply makes it the graduation process to the normal Registered Users group, automatic.AFAIK, it's not possible in the AdminCP to make a usergroup that bans BB code, much as I really wish I could! It's a forum-wide setting only.
So, how can I do this?

[djbaxter]

I've had over 100 new spamming members join up over the last few weeks, it seems this mod is missing quite a few now.....

www.staffs-vw.co.uk

right. same behavior here. they do not post. but tons of weird name appearing as new members:

bdizzycjniory742
agregoraspitay3555
Alencysewcesk
apittyswft3204
bolgaumaaleya5726
aamexiguoume66

most of them are using yahoo mail. i wonder what has changed!

look similar to some of the new members I'm getting

Those are bots, either from a botnet or spoofing addresses and IPs that are not in the database.

Add the Spammers suck! (https://vborg.vbsupport.ru/showthread.php?threadid=289463) mod - it will work in tandem with SFS to stop bots even when they're not yet in the database.

[My Hattiesburg]

When the spammer's post gets moderated, it's not showing in the regular moderation queue. Does it send it to another queue that I don't know about?

[amogh]

I see that legitimate registrations are being blocked by Spam-O-Matic.

I want to undo a few actions that Spam-O-Matic has taken (I see the log and want to allow some registrations that have been blocked)

How do I do this?

Amogh

[contra88]

I have a problem
I installed spam o matic but often I find a boot with ip registered on the forums and the emails stop spam on forum.com

- I uploaded the files in the upload folder
- I installed the plugin
- I configured the options
- I put the API to stop spam forum

What did I do wrong?

[iputinwork]

I've got this error, any idea how to fix it?:

Database error in vBulletin 4.1.12:
Invalid SQL:
SELECT * FROM glowhostspamomatic_stats;
MySQL Error : Table 'iputinwork_forum.glowhostspamomatic_stats' doesn't exist
Error Number : 1146

Parse error: syntax error, unexpected T_STRING in /home/iputinwork/public_html/includes/adminfunctions_plugin.php(1097) : eval()'d code on line 17

I've tried to re-install several times and same thing happens.

[ForceHSS]

I've got this error, any idea how to fix it?:

Database error in vBulletin 4.1.12:
Invalid SQL:
SELECT * FROM glowhostspamomatic_stats;
MySQL Error : Table 'iputinwork_forum.glowhostspamomatic_stats' doesn't exist
Error Number : 1146

Parse error: syntax error, unexpected T_STRING in /home/iputinwork/public_html/includes/adminfunctions_plugin.php(1097) : eval()'d code on line 17

I've tried to re-install several times and same thing happens.

MySQL Error : Table 'iputinwork_forum.glowhostspamomatic_stats' doesn't exist can you not see this

[iputinwork]

MySQL Error : Table 'iputinwork_forum.glowhostspamomatic_stats' doesn't exist can you not see this

Yes I can see it, but how do it fix it? What is causing the table to not exist?

I thought the table would be created once installed. Sorry this is my first time using vB.

[cool_recep]

When will it support blogs?

[ForceHSS]

Yes I can see it, but how do it fix it? What is causing the table to not exist?

I thought the table would be created once installed. Sorry this is my first time using vB.

you need to install the files as it is saying you have not

[iputinwork]

you need to install the files as it is saying you have not

I've tried to install the files numerous times, and I've also given it to my webmaster and still getting an error.

cURL is installed on the server and allow_url_fopen is enabled in PHP settings

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 : Sunday, October 28th 2012 @ 11:34:38 AM

Error Date : Sunday, October 28th 2012 @ 11:34:38 AM

Script : http://www.exploregta.com/admincp/plugin.php?do=productimport

Referrer : http://www.exploregta.com/admincp/plugin.php?do=productadd

[TheSupportForum]

I've tried to install the files numerous times, and I've also given it to my webmaster and still getting an error.

cURL is installed on the server and allow_url_fopen is enabled in PHP settings

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 : Sunday, October 28th 2012 @ 11:34:38 AM

Error Date : Sunday, October 28th 2012 @ 11:34:38 AM

Script : http://www.exploregta.com/admincp/plugin.php?do=productimport

Referrer : http://www.exploregta.com/admincp/plugin.php?do=productadd

in product-glowhostspamomatic.xml change all instances of

) TYPE=MyISAM; ');to

) ENGINE=MyISAM; ');then install again

[iputinwork]

^^

Yup, I did that and then I get this after I import the .xml file :

Database error in vBulletin 4.1.12:
Invalid SQL:
SELECT * FROM glowhostspamomatic_stats;
MySQL Error : Table 'iputinwork_forum.glowhostspamomatic_stats' doesn't exist
Error Number : 1146

Parse error: syntax error, unexpected T_STRING in /home/iputinwork/public_html/includes/adminfunctions_plugin.php(1097) : eval()'d code on line 17

[iputinwork]

solved thanks to simonhind!!!

[Silver_2000_)!]

Upgraded forum to VB4 and no one can post
"fatal error: Call to undefined function clean_options_list() in /includes/functions_newpost.php(532) : eval()'d code on line 8"
the search this mod function is broken - any ideas whats wrong ?
If I disable this mod the error disappears

[ForceHSS]

Upgraded forum to VB4 and no one can post
"fatal error: Call to undefined function clean_options_list() in /includes/functions_newpost.php(532) : eval()'d code on line 8"
the search this mod function is broken - any ideas whats wrong ?
If I disable this mod the error disappears

remove xml remove all files then reinstall it again

[ilikeitlikethat]

i cant seem to get this plugin working at all, even tho ive done a fresh install and everything..

if i have it enabled, it gives me an error when i try to register a test account & also an error when i try to post..

ugh, i need this working..

[TheSupportForum]

i cant seem to get this plugin working at all, even tho ive done a fresh install and everything..

if i have it enabled, it gives me an error when i try to register a test account & also an error when i try to post..

ugh, i need this working..

do you read others posts the solution is in loads of them

in product-glowhostspamomatic.xml change all instances of

) TYPE=MyISAM; ');to

) ENGINE=MyISAM; ');

then install again

[doctorsexy]

Is there a how to set up guide to this somewhere...

and is there a way of making the Spam-O-Matic Statistics in wgo a different color .... thanks

[TheSupportForum]

Is there a how to set up guide to this somewhere...


Step 1 : install
Step 2 : Get your StopForumSpam API Key Here (http://www.stopforumspam.com/signup)
Step 3 : input key in right field

what else would you need to do other than that ?

[doctorsexy]

what else would you need to do other than that ?

Well quite alot judging from some of the posts .

[TheSupportForum]

Well quite alot judging from some of the posts .

if you come across other problems after install please post them, thats the idea just like the rest, each person may have individual issue we won't know till you install and test

[rinkrat]

Getting more and more spammers from .ch getting through this mod. It used to stop them all.

[TheSupportForum]

Getting more and more spammers from .ch getting through this mod. It used to stop them all.

they are using bots they are not real people

[smoknz28]

I am running vb v4.2.0 Level 3

Installing this mod for the first time...

1. Uploaded required files.

2. Imported file....database error and file was not imported.

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 : Saturday, November 3rd 2012 @ 02:21:55 PM
Error Date : Saturday, November 3rd 2012 @ 02:21:55 PM
Script : http://www.xxxxxxxxxxxx/forums/admincp/plugin.php?do=productimport
Referrer : http://www.xxxxxxxxxxxxxx/forums/admincp/plugin.php?do=productadd
IP Address : xxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.5.27-cll

[bzcomputers]

I am running vb v4.2.0 Level 3

Installing this mod for the first time...

1. Uploaded required files.

2. Imported file....database error and file was not imported.

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 : Saturday, November 3rd 2012 @ 02:21:55 PM
Error Date : Saturday, November 3rd 2012 @ 02:21:55 PM
Script : http://www.xxxxxxxxxxxx/forums/admincp/plugin.php?do=productimport
Referrer : http://www.xxxxxxxxxxxxxx/forums/admincp/plugin.php?do=productadd
IP Address : xxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.5.27-cll

read post 2175 on previous page

[smoknz28]

Thanks....and sorry if I didn't go through all of the posts. 146 pages and counting. I got through around 10 pages and started seeing double vision. ;)

Heading to post 2175.

Thanks

[smoknz28]

Yup, that did it. ;)

Now, off to configuring it.

Thanks Bzcomputers.

[jimmy026]

There any way for me not to moderate the new members? We have so many members and a lot of ban appeals that come in and it takes forever to go through and moderate all the post.

[DFish]

you need to upload the files

Lol, the files were the first thing I uploaded then the XML via the ACP. So yeah. Still having issues. Thanks for the help though. :up:

[ForceHSS]

Lol, the files were the first thing I uploaded then the XML via the ACP. So yeah. Still having issues. Thanks for the help though. :up:

you might have but the error is saying you have not uploaded them to the right place

[KProjects]

Is anyone else noticing people getting through with IPs that are listed in stopforumspam.com? I've noticed it quite a bit lately on a couple different vB sites w/ this mod installed..

I have IP check enabled
I have it set to block if it can't reach the stopforumspam site..

[TheSupportForum]

Is anyone else noticing people getting through with IPs that are listed in stopforumspam.com? I've noticed it quite a bit lately on a couple different vB sites w/ this mod installed..

I have IP check enabled
I have it set to block if it can't reach the stopforumspam site..

which API are you using ?
and are you aware that they migrated their API to a new location that you need to change in the php file

[bzcomputers]

Is anyone else noticing people getting through with IPs that are listed in stopforumspam.com? I've noticed it quite a bit lately on a couple different vB sites w/ this mod installed..

I have IP check enabled
I have it set to block if it can't reach the stopforumspam site..

I believe even if it is in the database, if it is old (like 180 days, not sure what the length of time is), it will no longer block that ip.

[KProjects]

I did not know that - i'm just using the default settings that it had when I installed it.. is the updated code in this thread somewhere?

[TheSupportForum]

I did not know that - i'm just using the default settings that it had when I installed it.. is the updated code in this thread somewhere?

open functions_ghsom.php
replace code from line 96 - 105 with


case 'username':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?username='.urlencode($data).'&f=serial', $field);
break;

case 'email':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?email='.urlencode($data).'&f=serial', $field);
break;

case 'ip':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?ip='.urlencode($data).'&f=serial', $field);
break;

[KProjects]

Thank you!

open functions_ghsom.php
replace code from line 96 - 105 with


case 'username':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?username='.urlencode($data).'&f=serial', $field);
break;

case 'email':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?email='.urlencode($data).'&f=serial', $field);
break;

case 'ip':
$is_spam = VBGHSFS_getXML('http://api.stopforumspam.org/api?ip='.urlencode($data).'&f=serial', $field);
break;

[KProjects]

Ok - as an update..

I remembered about the logs that it provides, so I looked through there - I had a total of 80 registration attempts on one of my sites today.. of that 80, it let 4 through.

The 4 were from the same IP address, which is in the stopforumspam.com database 57 times so far..

My API code currently does point to www.stopforumspam.com and not api.stopforumspam.com but because of the 76 blocks today it seems to be contacting the server fine..

I did just change the code to what you have pasted above and will see how it goes over the next couple days..

Thanks,
Rob

[vBBurger]

How does the newbie filter work if you have Email Activation enabled on vBulletin?

Because Email Activation puts them into a group awaiting Email activation, while Glow Host is trying to put them into the Newbies group.

Normally this wouldn't be a problem. Most people immediately go and activate.

But with Spam Bots, they register, never activate by email, and since GlowHost puts the user into a group which has posting privileges, they are able to post on the forum without activating.

This is where the problem arises.

If this is in fact a bug, or oversight, the solution would be for GlowHost to *wait* until they have moved out of the "Awaiting Email Activation" group before considering them a new registrant.

As it stands, it immediately considers them an activated registrant.

[ThinkingBig]

There any way for me not to moderate the new members? We have so many members and a lot of ban appeals that come in and it takes forever to go through and moderate all the post.

+1 i have same problem... all new mambers post need to be moderate i got
Auto-Moderation set to disable and this not helps..

[kartheekb]

showing as database problem..

i have tryed other products , they are uploading..


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, November 8th 2012 @ 02:16:13 AM
Error Date : Thursday, November 8th 2012 @ 02:16:14 AM
Script : http://technodiscuss.com/vbforum/admincp/plugin.php?do=productimport
Referrer : http://technodiscuss.com/vbforum/admincp/plugin.php?do=productadd
IP Address : 117.XXX.X.XX
Username : admin
Classname : vB_Database
MySQL Version : 5.5.23-55

[TheSupportForum]

showing as database problem..

i have tryed other products , they are uploading..

please read a few pages up :(

in product-glowhostspamomatic.xml change all instances of

) TYPE=MyISAM; ');to

) ENGINE=MyISAM; ');then install again

[kartheekb]

please read a few pages up :(

in product-glowhostspamomatic.xml change all instances of

) TYPE=MyISAM; ');to

) ENGINE=MyISAM; ');then install again

thank you... worked. ;)

[TheSupportForum]

thank you... worked. ;)

np :)

[vBBurger]

Can someone address my question?

With Email Activation on, users are being pulled immediately into the newbie user group upon registration. The usergroup that allows posting, with restrictions. Why is it doing this? They should be left in the "Users Awaiting Email Activation" group until they activate by email. Because of this bug, spam bots are able to register and post without activating their email account. This nullifies the entire purpose of Email Activation. They should only be moved into the new users group after they activate.

Why? How to fix?
---------------------------------

I tried to post a question to the maker of GlowHost Spam O Matic on their support forums. He failed to answer any of my questions and then deleted all my posts. Very strange, and inappropriate behavior honestly. I guess their SpamOMatic support forum is not for support with SpamOMatic

[GlowHost.com]

With Email Activation on, users are being pulled immediately into the newbie user group upon registration. The usergroup that allows posting, with restrictions. Why is it doing this?

Because it was designed that way.



They should be left in the "Users Awaiting Email Activation" group until they activate by email. Because of this bug, spam bots are able to register and post without activating their email account. This nullifies the entire purpose of Email Activation. They should only be moved into the new users group after they activate.



Do you think spam bots cant click activation links if they can fill out a form?



I tried to post a question to the maker of GlowHost Spam O Matic on their support forums. He failed to answer any of my questions and then deleted all my posts. Very strange, and inappropriate behavior honestly. I guess their SpamOMatic support forum is not for support with SpamOMatic

You are right, this is the place to seek support.

Your choices are to either use the newbies group after registration or use the users awaiting validation group after registration.

[Fivestones]

works great ty

[M.C.]

Want to thank you for great addon first.

Have question about moderated posts/threads (may be been asked here). In statistic there is:

Spam-O-Matic Statistics

X Spammers Denied Registration

X Spammy Posts Automatically Moderated

But where they located that "moderated posts"? I don't see them....

May be you can add in options that put all moderated threads/posts into some special "Trash-bin" forum and we can put forumID for it?

WBRs

P.S. sorry my english not well

[ForceHSS]

Want to thank you for great addon first.

Have question about moderated posts/threads (may be been asked here). In statistic there is:

Spam-O-Matic Statistics

X Spammers Denied Registration

X Spammy Posts Automatically Moderated



But where they located that "moderated posts"? I don't see them....

May be you can add in options that put all moderated threads/posts into some special "Trash-bin" forum and we can put forumID for it?

WBRs

P.S. sorry my english not well

either go to your settings in your own profile or look in the admincp/Moderation

[naveeid]

this mod is wonderful and has helped me a lot to control the spam

[tuRiver]

Is it possible to control usergroup permissons? Who can ban or delete user?

[vBBurger]

Because it was designed that way.
Why would you *reduce* the built in security of vBulletin when you could have simply detected when someone Activates before moving them to the Newbies group? Simple solution. But instead you're telling me someone intentionally coded SpamOMatic to cripple the Email Activation feature of vBulletin? Why would you do that? SpamOMatic is supposed to increase security. Not break it.

Do you think spam bots cant click activation links if they can fill out a form?
No. Most of them DONT click activation links. Do you know why? Because theyd have to create thousands of email accounts just to do that.

We tried using just SpamOMatic alone. It didn't work. You place new users into a Newbies group ... but how does that stop them from posting? We ended up with hundreds of Spam BOT "Moderated Posts" that had to manually be deleted. One of my Moderators quit that day because he was overhwhelmed with the failure of your plug in to stop Spam.

So I took matters into my own hands and re-enabled Email Activation. Guess what? It all stopped. But a handful are now posting freely because your tool BREAKS the Email Activation function in vBulletin. Apparently the "You must activate" page deters a large percent of them because they can't activate by email like you assume. The smarter ones try posting anyways, and do so just fine because your tool doesn't stop them.

Your choices are to either use the newbies group after registration or use the users awaiting validation group after registration.
There is absolutely no reason why this has to be an either-or situation. All you have to do is fix the problem, and SpamOMatic can be used in conjunction with Email Activation. Detect Email Activation before putting them into Newbies group. Simple. Basic code change. Is there someone a little more willing to listen that I can report this bug to?

VBB

[GlowHost.com]

I guess if you don't like it, simply remove the program, problem solved.

You certainly won't get any help with an attitude like that.

[vBBurger]

Attitude? I am just trying to help by reporting a bug. You copped the attitude in your response, as if I was clueless about spam botS, or forums in general. Really caught me off guard actually.

I'm not trying to damage anyone's Ego here. Just trying to avoid endless hours of deleting unnecessary spam. Which is why your tool exists. This *bug* has been confirmed on the main vBulletin forums by a couple guys now. So it would be nice if you'd acknowledge it too.

Why would you give me such a strange, arrogant response, and tell me to get over it, or uninstall it? Wow. Why not take it as a bug or feature request and improve the tool? Is your ego that huge? This isnt personal. Its a bug. It needs to be fixed. And doing so will help everyone.

Ill just pay my programmer $14 to fix your bug instead. Lose the ego.

[GlowHost.com]

You are demanding special treatment. Have you ever heard of the word "please?"

Something like:

"Can you please make this mod do something that it doesn't do already?"

That would get you a lot more support than of an entire thread flaming this mod. If you understood how the mod worked, you wouldn't have this question in the first place.

Email activation puts people into the registered users group. That is the default setting of this mod when you install it.

If you do not like how vBulletin handles this, (since it is worthless, and yes, bots do click the links) you can optionally enable the Newbies system which will allow you to permission the group to your hearts content given all of the options that vBulletin allows for.

What is the point of having real people click a link to end up in the Newbies group?

Is it to make it more difficult for real people to post on your forums? Or in your mind, to prevent bots who don't click links from registering?

Actually, after reading your updated post, don't bother answering. I don't care. Go pay your $14 programmer to do whatever you want with it, he must be talented. All that anger and effort to try and save $14 bucks? Wow.

[djbaxter]

And didn't you get essentially the same answer in your vBulletin.com thread?

[Fatal Hazard]

I have installed it and it works but when I try to edit the settings I get this error:
https://vborg.vbsupport.ru/external/2012/11/27.png

[GlowHost.com]

Check that you have set the correct permissions on the PHP files that you uploaded. Depending on your php environment they probably should be set to 644 or you can try 755 if 644 doesnt work. That or ask your hosting company to help read the messages in the Apache error logs...they will tell you exactly why Apache is forbidding you from accessing that page.

[bzcomputers]

Server appears to currently be down and denying registrations even with:

StopForumSpam: Query Connection Errors
What should happen if the remote connection times out when querying the new registration?
set to Allow Registration

4 registrations in last 15 minutes denied for:
pam-O-Matic Tagged email - XXXXXXX@xxxxx.com Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at 'StopForumSpam:

Unfortunately the last time the servers went down it also would not pass registrations through, even though it was set to fall back on "Allow Registration".

Edit: Looks like it may a temporary downtime, I see last week at the same time it also appears to have been down. Routine maintenance? Hope not.

https://vborg.vbsupport.ru/external/2012/11/32.jpg

[ForceHSS]

<a href="https://vborg.vbsupport.ru/showpost.php?p=2378937&postcount=2193" target="_blank">https://vborg.vbsupport.ru/showp...postcount=2193</a>

[djbaxter]

https://vborg.vbsupport.ru/showpost.php?p=2378937&postcount=2193

Not necessary. Pedigree confirmed recently that at the moment both www.stopforumspam.com and api.stopforumspam.org go to the same place. The issue has nothing to do with the URL.

Depending on where you are, you may also be timing out at times. Hurricane Sandy wreaked havoc on the east coast of the US and power is still out in many places. When I do a tracert for my own site it slows down noticeably doing hops through New York State and Atlanta,

[bzcomputers]

I did have the updated "api" links already installed and was still getting no response from the server. This is coming from Texas.

What worries me is seeing nearly 4 hours of no submissions (presumably downtime) from 4:00AM to 8:00AM local time for StopForumSpam.com two weeks in a row (can't see detailed history past that from their published graphs).

Image below is directly from their site statistics:
http://www.stopforumspam.com/historygraph

https://vborg.vbsupport.ru/external/2012/11/25.jpg

[Fatal Hazard]

Check that you have set the correct permissions on the PHP files that you uploaded. Depending on your php environment they probably should be set to 644 or you can try 755 if 644 doesnt work. That or ask your hosting company to help read the messages in the Apache error logs...they will tell you exactly why Apache is forbidding you from accessing that page.

Okay will do so, thanks for the help!! :)

[djbaxter]

As I said earlier (maybe in the thread for the vbStopForumSpam version by pedigree), sometimes their server can appear down for some users and not for others, depending on where you are when you're trying to access it.

As long as you set it to "allow registration" when the database can't be accessed, you'll be fine.

[Beatrix Kiddo]

I don't really understand why but just in the last month I'm all of a sudden getting waves of spam registration attempts that are getting passed this add-on. Thankfully I have my forum set to where myself or another admin has to give a manual approval on the account so technically I have not been spammed. But when I first installed this mod up until just a while ago none of the slimeball spammers were even getting passed the Spam-o-matic...now they are...I think someone found a hack or a security hole to exploit.

[ForceHSS]

I don't really understand why but just in the last month I'm all of a sudden getting waves of spam registration attempts that are getting passed this add-on. Thankfully I have my forum set to where myself or another admin has to give a manual approval on the account so technically I have not been spammed. But when I first installed this mod up until just a while ago none of the slimeball spammers were even getting passed the Spam-o-matic...now they are...I think someone found a hack or a security hole to exploit.

try this (https://vborg.vbsupport.ru/showthread.php?t=289463)

[Snowhog]

Are Spammers suck! and Spam-O-Matic compatible? Do they interfere with each other in any way?

[ForceHSS]

Are Spammers suck! and Spam-O-Matic compatible? Do they interfere with each other in any way?

they work well with each other

[djbaxter]

they work well with each other

Yes. They do not compete with one another but target different varieties of spammers. Glowhost is primarily about blocking human spammers. Spammers Suck is about blocking spambots.

[fishinstud]

Does this work with vb5-connect?

[ForceHSS]

Does this work with vb5-connect?

this is for vb4 only

[zombiemau5]

BEAST! THANK YOU!

[deltahawk5]

I'm confused...is Easy Clean up something we are able to run manually? If so, how? Our site has been hit pretty hard by spammer registration (almost 100 a day, which is the reason I set up this mod) and I'd like to have them removed if they match anything in the StopForumSpam DB.

Any help would be immensely appreciated!

[Syxguns]

I'm confused...is Easy Clean up something we are able to run manually? If so, how? Our site has been hit pretty hard by spammer registration (almost 100 a day, which is the reason I set up this mod) and I'd like to have them removed if they match anything in the StopForumSpam DB.

Any help would be immensely appreciated!

This mod as great as it is will not help you with the clean up of already registered members to the site.

This is what I do for registration:

I have this mod set to check new registration e-mail, and IP address. I also have it set to auto moderate the first post only, in case someone gets past the mod. The only problem with this is that you have to pay attention to the post to see if it's been moderated, and then allow access manually.

The second thing that I do is use another mod I use is NoSpam!Image Enhancement by BOP5 (https://vborg.vbsupport.ru/showthread.php?t=265845) I'm not really suppose to talk about other mods on this thread, but with the two combined I have few to no spammers.

Manual clean up is required for you at this point. However, with the use of this mod it may take a little time but you can not only clean but you may also submit the spammers when doing so.

[GlowHost.com]

Hi All-

We will have a fix for the MySQL ENGINE/TYPE bug that is repeatedly reported very soon.

Also, a couple other common problems, plus a new feature (well, maybe a couple small ones too) is being added which has been requested many times over. Not telling what they are but this will be ready soon for your holiday present from GlowHost. :)

We are not doing anything major here, mainly code cleanup and bug fixes, because of the need for a vB5 version.

Stay tuned!

PS a big thanks to djbaxter, TheSupportForum, ForceHSS and I am sure I missed a few for your great help and support of this mod.

[DannyITR]

Can someone PLEASE tell me how to fix the problem of posts that cannot be approved. The only solution is to physically deleted them and that's not a solution.

[osayidan]

Hi All-

We will have a fix for the MySQL ENGINE/TYPE bug that is repeatedly reported very soon.



Is that referring to the database error when installing the product?
In the past couple of days I've had more spammers than the rest of my forum's history combined, so this is the first place I came to but I can't seem to install it :(



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

[bzcomputers]

Is that referring to the database error when installing the product?
In the past couple of days I've had more spammers than the rest of my forum's history combined, so this is the first place I came to but I can't seem to install it :(


Answer is just a page away...

https://vborg.vbsupport.ru/showpost.php?p=2379299&postcount=2199

[mrfarb]

This is the bomb (I'm so old). Installed, and nominated for MOTM.

[SRobbins1977]

Hello,
Im getting the following error:

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 : Saturday, November 17th 2012 @ 02:33:17 PM
Error Date : Saturday, November 17th 2012 @ 02:33:17 PM
Script : http://mydomain.com/admincp/plugin.php?do=productimport
Referrer : http://mydomain.com/admincp/plugin.php?do=productadd
IP Address : 0.0.0.0
Username : Administrator
Classname : vB_Database
MySQL Version : 5.5.23-55

PLEASE HELP!

[Alibass]

Read the posts...

https://vborg.vbsupport.ru/showpost.php?p=2379299&postcount=2199

[gajinoz]

I'm about to install this mod and I see there is a DB error when installing and a fix for it.

What I'd like to know is: Should I do this fix before installing it for the first time or just install it and see if I need the fix?

[bzcomputers]

I'm about to install this mod and I see there is a DB error when installing and a fix for it.

What I'd like to know is: Should I do this fix before installing it for the first time or just install it and see if I need the fix?

MUST be changed before it will install correctly,

[gajinoz]

MUST be changed before it will install correctly,

OK, thanks for that.

[schuhby]

I installed in this fantastic Add-on yesterday and it caused all new post to error and didn't allow anyone to post. Is there a setting I'm missin please?

Thank you in advance

[ForceHSS]

I installed in this fantastic Add-on yesterday and it caused all new post to error and didn't allow anyone to post. Is there a setting I'm missin please?

Thank you in advance

https://vborg.vbsupport.ru/showthread.php?t=289463
see if this one works better for u

[schuhby]

https://vborg.vbsupport.ru/showthread.php?t=289463
see if this one works better for u

Does this mean I can't use spam-o-matic?

Philip

[ForceHSS]

Does this mean I can't use spam-o-matic?

Philip

spam o matic needs updated and some things fixed I have no idea why it is not working for you. Wrong install or bad install hard to tell as there is no error message you have given, screenshots or links to your site

[schuhby]

I will post a screen capture later today.

Thank you

[schuhby]

Hi

I have added a screen shop of the error message my users get when they try to post

Error message (http://www.mydecozo.co.uk/showthread.php?6541-Error-page&p=76830#post76830)

Philip

[ForceHSS]

Can you make a test account for me need to see the error when I post. Also check server logs and post what errors it shows

[slimwhitman]

Hey, I just installed this and it seems to work great.. Many thanks.

Is there a way to restrict the user email and IP info, or preferably the entire spamomatic dialogue, to admins only?

And keep mods or super mods from seeing it or using it?

[ForceHSS]

Do you mean the Spam-O-Matic Statistics? For now no unless it is recoded, I know the coder is making some changes and will come out with a new version soon so it might be added but you can hide the stats from all in the settings on it