vBulletin Mods

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

TheSupportForum 10 Oct 2012 18:23

Quote:

Originally Posted by Corrine. (Post 2372091)
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: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)

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
http://www.vbulletin.org/forum/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. 10 Oct 2012 22:16

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) 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 10 Oct 2012 23:01

Quote:

Originally Posted by Corrine. (Post 2372146)
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) 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.

http://www.vbulletin.org/forum/showthread.php?t=282704

Bluefin221 11 Oct 2012 00:03

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 12 Oct 2012 00:05

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/adm...=productimport
Referrer : http://yyyyyyyyyyyyyy.com/forum/admi...?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 12 Oct 2012 00:16

Quote:

Originally Posted by onestorydown (Post 2372404)
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 12 Oct 2012 00:44

Quote:

Originally Posted by bzcomputers (Post 2372405)
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 12 Oct 2012 10:29

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

Uberguilds 13 Oct 2012 02:15

Quote:

Originally Posted by ccampo (Post 2160034)
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 13 Oct 2012 12:02

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 13 Oct 2012 13:14

Quote:

Originally Posted by killerford (Post 2372695)
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 13 Oct 2012 22:31

Quote:

Originally Posted by Bluefin221 (Post 2372702)
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 14 Oct 2012 12:08

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 14 Oct 2012 12:17

Quote:

Originally Posted by Cybex (Post 2372864)
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 14 Oct 2012 14:39

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

Harpo 14 Oct 2012 19:39

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

TheSupportForum 14 Oct 2012 19:44

Quote:

Originally Posted by Harpo (Post 2372992)
Its breaks my footer. I'm using pureVBs Gametime theme.

disable sponsors

Vick98 15 Oct 2012 09:06

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

TheSupportForum 15 Oct 2012 09:16

Quote:

Originally Posted by Vick98 (Post 2373107)
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/6...70b86e05e8.png

JakeSully 15 Oct 2012 13:12

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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 15 Oct 2012 13:54

Quote:

Originally Posted by JakeSully (Post 2373129)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

there are plenty more

squidsk 15 Oct 2012 17:00

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.

HTTP 500 Error Trying to Post Reply After Installing
by john_rsd
16 Oct 2012 12:56

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.

Quote:

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 16 Oct 2012 21:39

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

Does word block include title of post?
by achouza
16 Oct 2012 23:49

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 17 Oct 2012 00:24

Quote:

Originally Posted by achouza (Post 2373578)
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 17 Oct 2012 15:40

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 17 Oct 2012 16:42

Quote:

Originally Posted by AlpineZone (Post 2373752)
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 17 Oct 2012 20:52

Quote:

Originally Posted by john_rsd (Post 2373420)
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 17 Oct 2012 21:32

Quote:

Originally Posted by john_rsd (Post 2373846)
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 18 Oct 2012 03:46

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 19 Oct 2012 02:10

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 19 Oct 2012 02:41

Quote:

Originally Posted by killerford (Post 2374139)
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 19 Oct 2012 11:36

Quote:

Originally Posted by simonhind (Post 2373852)
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 19 Oct 2012 11:37

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 19 Oct 2012 14:47

Quote:

Originally Posted by john_rsd (Post 2374210)
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 19 Oct 2012 14:47

Quote:

Originally Posted by Vick98 (Post 2374212)
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 19 Oct 2012 17:42

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

Quote:

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 19 Oct 2012 21:30

Quote:

Originally Posted by ForceHSS (Post 2374257)
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 19 Oct 2012 22:32

Quote:

Originally Posted by john_rsd (Post 2374345)
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 19 Oct 2012 22:32

Quote:

Originally Posted by DFish (Post 2374299)
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 20 Oct 2012 08:01

Quote:

Originally Posted by ForceHSS (Post 2374370)
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 20 Oct 2012 08:11

Quote:

Originally Posted by john_rsd (Post 2374456)
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 20 Oct 2012 11:56

Quote:

Originally Posted by simonhind (Post 2374458)
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 21 Oct 2012 06:13

Quote:

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 22 Oct 2012 05:22

Quote:

Originally Posted by Vick98 (Post 2374212)
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?

Quote:

Originally Posted by ForceHSS (Post 2374258)
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 22 Oct 2012 18:30

check custom plugins

TheSupportForum 22 Oct 2012 22:08

Quote:

Originally Posted by Vick98 (Post 2374959)
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| 23 Oct 2012 11:11

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 24 Oct 2012 12:35

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 24 Oct 2012 14:40

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 24 Oct 2012 15:19

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

Parse Error
by mgmuranaka
24 Oct 2012 18:16

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 24 Oct 2012 18:22

Quote:

Originally Posted by mgmuranaka (Post 2375694)
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 24 Oct 2012 18:25

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

mgmuranaka 24 Oct 2012 18:32

Also, how do I use the Easy Cleanup tools?

Jonm 24 Oct 2012 20:02

Quote:

Originally Posted by Sushubh (Post 2375627)
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

Limit BBCode
by Meestor_X
24 Oct 2012 20:37

Quote:

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 25 Oct 2012 00:27

Quote:

Originally Posted by Jonm (Post 2375618)
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

Quote:

Originally Posted by Sushubh (Post 2375627)
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!

Quote:

Originally Posted by Jonm (Post 2375713)
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! mod - it will work in tandem with SFS to stop bots even when they're not yet in the database.

My Hattiesburg 26 Oct 2012 02:29

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 26 Oct 2012 07:29

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 26 Oct 2012 07:55

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 27 Oct 2012 02:50

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 27 Oct 2012 03:56

Quote:

Originally Posted by iputinwork (Post 2376210)
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 27 Oct 2012 13:27

Quote:

Originally Posted by ForceHSS (Post 2376223)
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 27 Oct 2012 14:58

When will it support blogs?

ForceHSS 27 Oct 2012 16:15

Quote:

Originally Posted by iputinwork (Post 2376272)
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 28 Oct 2012 17:11

Quote:

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

TheSupportForum 28 Oct 2012 17:47

Quote:

Originally Posted by iputinwork (Post 2376599)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

then install again

iputinwork 28 Oct 2012 18:19

^^

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 28 Oct 2012 20:00

solved thanks to simonhind!!!

Silver_2000_)! 30 Oct 2012 04:18

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 30 Oct 2012 04:39

Quote:

Originally Posted by Silver_2000_)! (Post 2376958)
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 31 Oct 2012 11:29

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 31 Oct 2012 12:00

Quote:

Originally Posted by ilikeitlikethat (Post 2377251)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

then install again

doctorsexy 02 Nov 2012 10:59

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 02 Nov 2012 11:05

Quote:

Originally Posted by doctorsexy (Post 2377770)
Is there a how to set up guide to this somewhere...


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 ?

doctorsexy 02 Nov 2012 12:23

Quote:

what else would you need to do other than that ?
Well quite alot judging from some of the posts .

TheSupportForum 02 Nov 2012 12:32

Quote:

Originally Posted by doctorsexy (Post 2377797)
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 03 Nov 2012 18:17

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

TheSupportForum 03 Nov 2012 18:44

Quote:

Originally Posted by rinkrat (Post 2378130)
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 03 Nov 2012 21:26

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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


bzcomputers 03 Nov 2012 21:41

Quote:

Originally Posted by smoknz28 (Post 2378168)
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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

read post 2175 on previous page

smoknz28 03 Nov 2012 22:00

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 03 Nov 2012 22:07

Yup, that did it. ;)

Now, off to configuring it.

Thanks Bzcomputers.

jimmy026 06 Nov 2012 00:07

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 06 Nov 2012 13:46

Quote:

Originally Posted by ForceHSS (Post 2374371)
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 06 Nov 2012 18:43

Quote:

Originally Posted by DFish (Post 2378878)
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 06 Nov 2012 19:08

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 06 Nov 2012 19:12

Quote:

Originally Posted by KProjects (Post 2378932)
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 06 Nov 2012 19:16

Quote:

Originally Posted by KProjects (Post 2378932)
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 06 Nov 2012 19:16

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 06 Nov 2012 19:21

Quote:

Originally Posted by KProjects (Post 2378936)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


KProjects 06 Nov 2012 19:28

Thank you!

Quote:

Originally Posted by TheSupportForum (Post 2378937)
open functions_ghsom.php
replace code from line 96 - 105 with


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


KProjects 06 Nov 2012 19:40

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 06 Nov 2012 20:42

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 06 Nov 2012 21:21

Quote:

Originally Posted by jimmy026 (Post 2378718)
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 08 Nov 2012 07:18

showing as database problem..

i have tryed other products , they are uploading..

Quote:

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/adm...=productimport
Referrer : http://technodiscuss.com/vbforum/adm...?do=productadd
IP Address : 117.XXX.X.XX
Username : admin
Classname : vB_Database
MySQL Version : 5.5.23-55

TheSupportForum 08 Nov 2012 07:42

Quote:

Originally Posted by kartheekb (Post 2379296)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

then install again

kartheekb 08 Nov 2012 15:56

Quote:

Originally Posted by TheSupportForum (Post 2379299)
please read a few pages up :(

in product-glowhostspamomatic.xml change all instances of


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

then install again

thank you... worked. ;)


All times are GMT. The time now is 01:54.

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