vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?t=248042)

Megaboost 10-28-2011 11:56 PM

This works fine on my 4.1.7 and finds spammers almost every day. This is such an Awesome Mod.

Antolio 10-31-2011 04:24 PM

I'm having trouble.. It's counting EVERYTHING as spam?

charlesr 11-03-2011 05:31 PM

Has anyone tried installing this fresh on 4.1.7?

I've just set up a test instance for 4.1.7 and all my other products work so far, but this one gives the following when I try and import the xml file (after having uploaded the relevant folders):

EDIT: I get the same error for the limited guest viewing product. I can't see anything wrong though - I have MyISAM as my default storage engine (I actually don't have InnoDB at all). I'm off to check the manual (mysql version 5.5.16), but if anyone has any ideas in the mean time, please post away.

EDIT2: The 5.0 manual suggests TYPE is deprecated and it should say ENGINE, but that TYPE is supported. There is no mention of TYPE in the 5.5 manual.

Code:

Database error in vBulletin 4.1.7:

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 3rd 2011 @ 06:22:03 PM
Error Date    : Thursday, November 3rd 2011 @ 06:22:03 PM
Script        : http://127.0.0.1/site/admincp/plugin.php?do=productimport
Referrer      : http://127.0.0.1/site/admincp/plugin.php?do=productadd
IP Address    : 127.0.0.1
Username      : charlesr
Classname    : vB_Database
MySQL Version : 5.5.16


FannBlade 11-03-2011 06:07 PM

I'm running it on 4.1.7 with no problems. Loaded right up and works very well for me.

charlesr 11-04-2011 08:52 AM

Changing TYPE to ENGINE in a few places in the XML before import worked fine.

GossipAll 11-04-2011 09:08 AM

Im running it on 4.1.7 for quite sometime now and it's a wonderful hack. The only thing which bothers me is that it sometimes stops genuine people from registering, only because the username they try to register is flagged :(

tonyDD 11-04-2011 04:14 PM

Hi

I wonder if anyone would be kind enough to help.
I have been handed our companies forum to look after and im stuck trying to install this as im a complete newb.

I have downloaded but i cant seem to upload to vbulletin 4.17. I point to the cpnav_glowhostspamomatic.xml and vbulletin reports inavlid file specified. I have tried to follow the instructions in the zip but not sure where to put the other files using filezilla as the forum was installed by global gold and again im a useless newb.

Any help would be superb and help me save a few hours of my day on spam.

regards and thanks

ToddG 11-05-2011 06:16 AM

Just installed at our forum today running 4.1.7 patch 1, caught 8 spammers already and allowed legitimate registrants in without a hassle. We've been able to turn off manual moderation of new members. Great mod. Thanks GlowHost!

Bejecas 11-05-2011 12:52 PM

Hi!

Is there any way i can change (translate) the information on my main forum about the spammers tas were denied registration?
I tryed in the phrases search and nothing... Can i find it on cms? Theme? Where?

Many thanks forthe time and its a great plugin!

tonyDD 11-06-2011 12:49 AM

got it installed now,hope it does the job

polle 11-06-2011 01:56 PM

It seems this breaks 4.1.7 patch 2.

I get blank pages when posting new threads or reply to old ones.

Thanks.

Ross L 11-06-2011 02:10 PM

Quote:

Originally Posted by polle (Post 2264973)
It seems this breaks 4.1.7 patch 2.

I get blank pages when posting new threads or reply to old ones.

Thanks.

I updated to 4.1.7 PL2 yesterday and it works fine with it :D

polle 11-06-2011 02:27 PM

Quote:

Originally Posted by Ross L (Post 2264977)
I updated to 4.1.7 PL2 yesterday and it works fine with it :D

If I activate it, I can't post anything, after I click send when I start a thread or reply, I get a pop up telling me "are you sure you want to leave" and after I click ok, I get a blank page.

Nothing gets posted...

Deactivating it solves the problem.

Anyone ?

rolfw1 11-06-2011 02:44 PM

Can't replicate your problem polle, I'm running 4.1.7 PL2 and there is no change to the operation.

polle 11-06-2011 03:12 PM

Quote:

Originally Posted by rolfw1 (Post 2264986)
Can't replicate your problem polle, I'm running 4.1.7 PL2 and there is no change to the operation.

Strange, the same happened to me when upgrading from 4.1.6 to 4.1.7, but I had an outdated [GlowHost] Spam-O-Matic, I updated it and everything fine.

Now from 4.1.7 to 4.1.7 patch 2, the same, blank pages and alerts when trying to post, reply, erase a message, etc...

So definitely there's something.

FannBlade 11-06-2011 03:41 PM

I too have upgrade to latest patch and all works fine on my end. Good thing I'm not sure how I would live without it.

polle 11-06-2011 03:55 PM

I uploaded everything again and now its working :)

Thanks.

tonyDD 11-06-2011 04:55 PM

polle how did you get around this? When the plug ins are active i get blank pages when someone tries to sign up or post and i have to deactivate the spam-o-matic plug ins

many thanks for any help

polle 11-06-2011 05:04 PM

Quote:

Originally Posted by tonyDD (Post 2265055)
polle how did you get around this? When the plug ins are active i get blank pages when someone tries to sign up or post and i have to deactivate the spam-o-matic plug ins

many thanks for any help

That was happening to me as well.

Download it and upload the files, so installing it again fixes the problem.

Hope it helps.

tonyDD 11-06-2011 06:01 PM

Hi

many thanks, uploaded the folders again and now its working. One more question, is there any way to remove certain tagged usernames from Spam-o-matic is this a local list i can edit or stored at Spam-o-matic or something?

Thanks again peeps

sportsfroma2 11-06-2011 06:07 PM

I upgraded from vbulletin suite 4.1.4 to 4.1.7 PL2 yesterday, no issues whatsoever related to spam-o-matic / blank pages, etc...

the annoying "are you sure you want to leave" prompt is something I experienced in 4.1.4, and fixed it/disabled it using a suggestion here:
http://tracker.vbulletin.com/browse/VBIV-12548

polle 11-06-2011 06:17 PM

Quote:

Originally Posted by tonyDD (Post 2265076)
Hi

many thanks, uploaded the folders again and now its working. One more question, is there any way to remove certain tagged usernames from Spam-o-matic is this a local list i can edit or stored at Spam-o-matic or something?

Thanks again peeps

You're welcome, in the other thing I have no idea, lets hope someone else share that with you.

ForceHSS 11-06-2011 11:10 PM

Quote:

Originally Posted by tonyDD (Post 2265076)
Hi

many thanks, uploaded the folders again and now its working. One more question, is there any way to remove certain tagged usernames from Spam-o-matic is this a local list i can edit or stored at Spam-o-matic or something?

Thanks again peeps

DELETE FROM `glowhostspamomatic_remotecache` WHERE (`data`='put in user name here')

tonyDD 11-07-2011 12:06 PM

Many thanks.Sorry im a newb, where would that reside?

Thanks again all that have helped.

ForceHSS 11-07-2011 12:24 PM

admincp/Maintenance/Execute SQL Query/Manual Query

tonyDD 11-07-2011 12:43 PM

Many thanks for that, mmmm get a pop up stating i am not authorised to execute SQL queries.
What joy lol.

tonyDD 11-07-2011 12:50 PM

o.k sorted the query prob, updated config php with
$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number

tonyDD 11-07-2011 12:53 PM

So i just paste this text into teh query box but include username?
DELETE FROM `glowhostspamomatic_remotecache` WHERE (`data`='put in user name here')

Many apologies in advance for being a pain, as i say im trying to learn so need spoon feeding for a while.

neparker 11-07-2011 05:13 PM

I'm getting the following error when you try to comment or make a post in the forum after installing this mod, I don't want to uninstall either:

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(761) : eval()'d code on line 17

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/stufftos/public_html/forums/includes/class_dm_threadpost.php(761) : eval()'d code on line 17

Please help.

ForceHSS 11-08-2011 01:11 AM

Quote:

Originally Posted by tonyDD (Post 2265334)
So i just paste this text into teh query box but include username?
DELETE FROM `glowhostspamomatic_remotecache` WHERE (`data`='put in user name here')

Many apologies in advance for being a pain, as i say im trying to learn so need spoon feeding for a while.

yes just put it in that box change the "put in user name here" with the user name you want to remove from the list then click continue

RS25com 11-09-2011 02:54 PM

Request: When banning a user, allow us to report them. I have many members who sign up just to link to their home page, but make no posts. Therefore, I cannot select their posts as spam and then report/ban them.

xxducatixx 11-10-2011 02:31 AM

Hi,

I installed s per instruction and having some problems posting on the forum now. Would anyone in here kind enough to lend a hand please?

I get this message when I try to post.

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(466) : eval()'d code on line 5

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/andrewch/public_html/includes/functions_newpost.php(466) : eval()'d code on line 5

ForceHSS 11-10-2011 03:55 AM

make sure the file is uploaded to the right folder

tonyDD 11-10-2011 06:06 PM

thankyou!!

Quote:

Originally Posted by ForceHSS (Post 2265538)
yes just put it in that box change the "put in user name here" with the user name you want to remove from the list then click continue


HHelp1 11-10-2011 09:26 PM

Will this mods against the unwant bots too ?

ForceHSS 11-11-2011 01:15 AM

Quote:

Originally Posted by HHelp1 (Post 2266713)
Will this mods against the unwant bots too ?

this is what this mod does

maxicroma 11-11-2011 02:15 AM

i have to that error when i try to upload the product-glowhostspamomatic.xml
PHP Code:

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
                                    `
dateDATETIME NOT NULL,
                                    `
ipVARCHAR(15NOT NULL,
                                    `
emailVARCHAR(255NOT NULL,
                                    `
usernameVARCHAR(255NOT NULL,
                                    `
messageVARCHAR(255NOT NULL,
                                    `
is_blockedTINYINT NOT NULL DEFAULT "0",
                                    `
user_hashVARCHAR(50NOT NULL,
                                    `
user_idINT NOT NULL
                                 
TYPE=MyISAM;; 


HMBeaty 11-11-2011 02:18 AM

Quote:

Originally Posted by maxicroma (Post 2266812)
i have to that error when i try to upload the product-glowhostspamomatic.xml
PHP Code:

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
                                    `
dateDATETIME NOT NULL,
                                    `
ipVARCHAR(15NOT NULL,
                                    `
emailVARCHAR(255NOT NULL,
                                    `
usernameVARCHAR(255NOT NULL,
                                    `
messageVARCHAR(255NOT NULL,
                                    `
is_blockedTINYINT NOT NULL DEFAULT "0",
                                    `
user_hashVARCHAR(50NOT NULL,
                                    `
user_idINT NOT NULL
                                 
TYPE=MyISAM;; 


https://vborg.vbsupport.ru/showpost....postcount=1365

usuyusu 11-12-2011 12:04 PM

Hi my friends....

Any one knows how can I report StopForumSpam a spammer ONCE he is allready put in the Spammers group?

I'll try to explain better:

I detect a spammer in the same moment is is registering, so there is no ONE post from him. Inmediatly, I change the users group to Spammers (for example).

Is there any option in GlosHost Spam-O-Matic to report this users as spammer to the StopForumSpam database? (other than entering the users data directly in the StopForumSpam site database, obviously...)

:)

Thanx a lot to all.

LLent 11-12-2011 02:20 PM

Quote:

Originally Posted by usuyusu (Post 2267249)
Hi my friends....

Any one knows how can I report StopForumSpam a spammer ONCE he is allready put in the Spammers group?

I'll try to explain better:

I detect a spammer in the same moment is is registering, so there is no ONE post from him. Inmediatly, I change the users group to Spammers (for example).

Is there any option in GlosHost Spam-O-Matic to report this users as spammer to the StopForumSpam database? (other than entering the users data directly in the StopForumSpam site database, obviously...)

:)

Thanx a lot to all.

not sure why you are trying to stop spammers trying to get in by yourself cause this is what this mod does it is automatic and the few that get in you go to your thread tools and go through process which report it to stop forum spam ....this mod is the best there is imo this has saved me and my staff at my site much time ....


All times are GMT. The time now is 11:12 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03048 seconds
  • Memory Usage 1,858KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete