vb.org Archive
Page 164 of 350 « First 64114154162163 164 165166174214264 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)

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 09:35 PM.
Page 164 of 350 « First 64114154162163 164 165166174214264 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.05157 seconds
  • Memory Usage 1,757KB
  • 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
  • (3)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