vb.org Archive - Anti-Spam Options - [GlowHost] Spam-O-Matic

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.

Code:

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  : Saturday, November 3rd 2012 @ 02:21:55 PM

Error Date    : Saturday, November 3rd 2012 @ 02:21:55 PM

Script        : http://www.xxxxxxxxxxxx/forums/admincp/plugin.php?do=productimport

Referrer      : http://www.xxxxxxxxxxxxxx/forums/admincp/plugin.php?do=productadd

IP Address    : xxxxxxxxxxxxxxxxxx

Username      : xxxxxxxxxxxxx

Classname     : vB_Database

MySQL Version : 5.5.27-cll

bzcomputers

11-03-2012 09:41 PM

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.

Code:

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  : Saturday, November 3rd 2012 @ 02:21:55 PM

Error Date    : Saturday, November 3rd 2012 @ 02:21:55 PM

Script        : http://www.xxxxxxxxxxxx/forums/admincp/plugin.php?do=productimport

Referrer      : http://www.xxxxxxxxxxxxxx/forums/admincp/plugin.php?do=productadd

IP Address    : xxxxxxxxxxxxxxxxxx

Username      : xxxxxxxxxxxxx

Classname     : vB_Database

MySQL Version : 5.5.27-cll

read post 2175 on previous page

smoknz28

11-03-2012 10:00 PM

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

11-03-2012 10:07 PM

Yup, that did it. ;)

Now, off to configuring it.

Thanks Bzcomputers.

jimmy026

11-06-2012 12:07 AM

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

11-06-2012 01:46 PM

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

11-06-2012 06:43 PM

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

11-06-2012 07:08 PM

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

11-06-2012 07:12 PM

Quote:

Originally Posted by KProjects (Post 2378932)

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

All times are GMT. The time now is 04:41 AM.

Page 219 of 350

219

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03372 seconds Memory Usage 1,755KB 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 (5)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
Messages: