vb.org Archive
Page 41 of 88 « First 313940 41 424351 Last »
Show 40 post(s) from this thread on one page

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)

SteveLV702 02-17-2012 03:15 PM
Unable to install I get this error:

Code:
Database error in vBulletin 4.1.10:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `Moviesglowhostspamomatic_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  : Friday, February 17th 2012 @ 10:13:42 AM
Error Date    : Friday, February 17th 2012 @ 10:13:42 AM
Script        : http://www.themotionpicturereview.com/UnderworldRulez/plugin.php?do=productimport
Referrer      : http://www.themotionpicturereview.com/UnderworldRulez/plugin.php?do=productadd
IP Address    : ***.***.***.***
Username      : *******
Classname    : vB_Database
MySQL Version : 5.5.20-55-log

GavoTrav 02-17-2012 04:42 PM
It might be just me but my MYSQL server goes crazy with it on and it lags

Dwarden 02-17-2012 09:15 PM
this modification together with BadBehaviour2 module https://vborg.vbsupport.ru/showthread.php?t=261498
turned out as quite effective against spammers

my thanks to author

baronstaniford 02-19-2012 12:08 PM
My site has been plagued by spammers, with 50+ spam registrations a day. Since installing this mod we've been spam free. So far it's caught every one of them without stopping genuine members from registering.

48030-JayEss 02-19-2012 08:49 PM
I've been using this mod on my forum for about a month now. So far 5 out of 1,076 spammers got through and 3 were automatically moderated. This is a great mod and I sincerely thank you for it :D

Spada_FMC 02-22-2012 04:14 PM
We enabled Facebook login and have seen some issues.

We have a user that tried to log in by using the FB connet link.
They failed that and it was counted as spam (due to the email that was passed by FB).

Here is the entry. I removed the last four digits and replaced them with X's to protect anything that might be sensitive.
Spam-O-Matic Tagged email - app+6dcsihi7.2quci25km3.d66d191d410df363d41495c2c9 07XXXX@proxymail.facebook.com - Spammer Found and rejected.

Is there a way to whitelist an email domain?

rekha 02-22-2012 05:20 PM
Installed

rinkrat 02-22-2012 10:09 PM
I am suddenly getting a lot people denying they are spammers that are being banned. It started happening with my latest VB upgrade.

Anyone else have this happening?

ForceHSS 02-23-2012 02:46 AM
disable name check

Rockboy 02-23-2012 04:12 AM
Exact thing happened to me. IP and email checks are pretty dead on, but name check is the highest risk for false positives.

Nirjonadda 02-24-2012 08:47 PM
Database error on 4.1.10

Alibass 02-24-2012 08:54 PM
Quote:
Originally Posted by Nirjonadda (Post 2303062)
Database error on 4.1.10
We all get database errors at times...

Post your error message maybe someone can help you.

BoneDust 02-24-2012 09:07 PM
Anyone able to get this to work with 4.1.10.

I had a heck of a time getting vbulletin setup and this was the culprit.

Papa Bear 02-25-2012 12:45 AM
Quote:
Originally Posted by BoneDust (Post 2303072)
Anyone able to get this to work with 4.1.10.

I had a heck of a time getting vbulletin setup and this was the culprit.

Yep..works fine with 4.1.10

handruin 02-25-2012 06:06 AM
Disregard. Solved my issue...

tommyxv 02-25-2012 07:32 AM
3 times now, I had a user signup (not a spammer) and something in the registration system is causing it to double and triple create accounts with the exact username. The user ids are consecutive though. EX: JohnW (id34) & JohnW (id35) & JohnW (id36)

This is the only mod I have that is for Registrations. Anyone else experiencing this? I wonder if the user is clicking on the register button multiple times while waiting for the Spam Check to come back.

ForceHSS 02-25-2012 09:35 AM
then add his info in the spam o matic forums manually

tommyxv 02-25-2012 03:48 PM
Quote:
Originally Posted by ForceHSS (Post 2303204)
then add his info in the spam o matic forums manually
Why would I do that...I said he wasn't a spammer? :confused: I think this mod may be fouling up the registrations by taking too long to complete them. The person signing up is probably pressing the Complete Registration button more that once. Sort of like when a double post happens.

Alfa1 02-26-2012 05:21 PM
Is this addon still supported?
Will there be another release?

weave 03-01-2012 06:01 PM
Just enabled this on a new forum and have had several users, who have made prior posts, all of a sudden end up being moderated...is there some setting I missed?

This is on 4.1.10

Please give me some direction in which to look for my answer/issue

squidsk 03-02-2012 05:22 PM
They probably have fewer posts than the minimum to not be moderated.

coloradoz 03-02-2012 08:20 PM
Works great for me on 4.1.11 ! Thanks!

Antec_HiveMail 03-08-2012 01:58 PM
Quote:
Originally Posted by Alibass (Post 2160673)
I tried going back to v1.2.8 after a complete uninstall and I started getting a DB error while trying to import xml file. So I re-installed v2.0.1 and looks like my issue is a mod conflict with KeyCAPTCHA here.
I disabled KeyCAPTCHA mod and now SOM is displaying stats on forum home page and in the logs in admincp. It would be nice if I could get both mods to work together like I did when I had v1.2.8 installed.
I have disabled and even uninstalled Keycaptcha, but the stats are still not showing on my home page. All it shows is the "Spam-O-Matic Statistics" and nothing underneath.

Jay A Kelley 03-08-2012 06:38 PM
I have a clean install with 3 members. Using Darkvision skins.. I am getting the following errors when trying to enter articles in CMS

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

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php') in /home/compa37/public_html/infotech/forum/includes/class_dm_threadpost.php(1771) : eval()'d code on line 16

Then.. This is the error I get when people try to register...

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') in /home/compa37/public_html/infotech/forum/register.php(338) : eval()'d code on line 10

All of these errors go away when I turn Spam-0-matic so I am guessing that's the cause.

Any fixes? I'd love to use this, but can't with all these errors

ForceHSS 03-08-2012 06:50 PM
you dont have the file uploaded to the right folder or not uploaded at all

big dan 03-08-2012 10:31 PM
Hello,

I'm trying to install on a freshly upgraded 4.1.11 board and am getting the following error when importing the product:

Code:
Database error in vBulletin 4.1.11:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `xxxxx_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, March 8th 2012 @ 03:30:24 PM
Error Date    : Thursday, March 8th 2012 @ 03:30:24 PM
Script        : http://www.XXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.XXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address    : 24.161.16.84
Username      : admin
Classname    : vB_Database
MySQL Version : 5.5.20
Any help would be appreciated. Thanks.

ForceHSS 03-08-2012 11:11 PM
Quote:
Originally Posted by big dan (Post 2307673)
Hello,

I'm trying to install on a freshly upgraded 4.1.11 board and am getting the following error when importing the product:

Code:
Database error in vBulletin 4.1.11:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `xxxxx_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, March 8th 2012 @ 03:30:24 PM
Error Date    : Thursday, March 8th 2012 @ 03:30:24 PM
Script        : http://www.XXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.XXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address    : 24.161.16.84
Username      : admin
Classname    : vB_Database
MySQL Version : 5.5.20
Any help would be appreciated. Thanks.
Run this sql
DROP TABLE IF EXISTS `glowhostspamomatic_log`;
CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

XtremeCrash 03-09-2012 02:46 PM
I have the same issue.I ran that sql an its not showing in the admin panel.theres a few other mods that are doing this also.

Jay A Kelley 03-09-2012 11:12 PM
Quote:
Originally Posted by ForceHSS (Post 2307594)
you dont have the file uploaded to the right folder or not uploaded at all
Thank you this was a HUGE help.. It seems to be working, but I am not getting any statics on what Spam-0-Matic has blocked.. But I KNOW it's working. Any ideas?

Jay

ForceHSS 03-10-2012 12:37 PM
it will only show that up when it blocks someone do make sure you have it to show in the settings also it is this table that holds that info glowhostspamomatic_stats

I.G.O.T.A. 03-20-2012 12:13 PM
Quote:
Originally Posted by ForceHSS (Post 2298143)
Moderation Tools then you will see Spam O Matic normally last on list
Where is this at?

ForceHSS 03-20-2012 02:15 PM
the bottom of each post

Knight0319 03-20-2012 05:57 PM
Well, I'd like to say this mod has done its job well on my forum. Can't recall if I've had many spammers get through since installing this (Though I've had some issues where it wouldnt let a real person register). About a years worth of using this resulted in this: "13904 Spammers Denied Registration". Sounds like its doing good to me.

Sure been a while since this has been updated.

shadowbreed 03-21-2012 09:51 PM
Quote:
Originally Posted by ForceHSS (Post 2307687)
Run this sql
DROP TABLE IF EXISTS `glowhostspamomatic_log`;
CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
I'm having the same issue, and running that SQL gets me a second error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar' at line 2

ForceHSS 03-21-2012 11:49 PM
1 Attachment(s)
Quote:
Originally Posted by shadowbreed (Post 2311869)
I'm having the same issue, and running that SQL gets me a second error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar' at line 2
ok run this from your admin panel and it will work
sql uploaded just in case you need it

CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

shadowbreed 03-22-2012 01:37 PM
That does work indeed, however if I import the mod after that, I still get the same error :S

ForceHSS 03-22-2012 04:04 PM
strange you should not be getting it with the table there now have you tried removing and installing the xml and making sure you have all the files in the right folders

AusPhotography 03-22-2012 11:01 PM
MySQL gone away errors - cause found...
Refer: https://vborg.vbsupport.ru/showthrea...77#post2312277

Kym

Syxguns 03-23-2012 02:40 AM
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the “Type=MyIsam:” . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.

Code:
Error 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
Code:
$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');

 
$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

                          `date` DATETIME NOT NULL,
                          `field` VARCHAR(20) NOT NULL,
                          `is_spambot` INT NOT NULL,
                          `data` VARCHAR(255) NOT NULL
                            ) TYPE=MyISAM; ');

 

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

                          `denied` INT NOT NULL DEFAULT "0",
                          `banned` INT NOT NULL DEFAULT "0",
                          `moderated` INT NOT NULL DEFAULT "0",
                          `s_sfs` INT NOT NULL DEFAULT "0",
                          `s_akismet` INT NOT NULL DEFAULT "0",
                          `removed` INT NOT NULL DEFAULT "0"
                          ) TYPE=MyISAM; ');
Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

Code:
) ; ');
That may get it working for you. It worked for me when I made the change. Good Luck!

ForceHSS 03-23-2012 02:44 AM
The version of mysql would not make a diffence


All times are GMT. The time now is 07:23 AM.
Page 41 of 88 « First 313940 41 424351 Last »
Show 40 post(s) from this thread on one page

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.06769 seconds
  • Memory Usage 1,857KB
  • 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
  • (6)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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