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)

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


All times are GMT. The time now is 03:17 PM.

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.04193 seconds
  • Memory Usage 1,756KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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