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

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?

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

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.

When will it support blogs?

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/pl...=productimport

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

in product-glowhostspamomatic.xml change all instances of

to

then install again

^^

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

solved thanks to simonhind!!!

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

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

to

then install again

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

Step 1 : install
Step 2 : Get your StopForumSpam API Key Here
Step 3 : input key in right field

what else would you need to do other than that ?

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

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

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.

read post 2175 on previous page

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

Yup, that did it. ;)

Now, off to configuring it.

Thanks Bzcomputers.

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.

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

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

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.

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

Thank you!

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

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.

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

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

to

then install again

thank you... worked. ;)