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

Hi All,

I imported and this is what I get:

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 : Friday, January 4th 2013 @ 11:36:33 AM
Error Date : Friday, January 4th 2013 @ 11:36:34 AM
Script : http://www.domain.com/admincp/plugin...=productimport
Referrer : http://www.domain.com/admincp/plugin.php?do=productadd
IP Address :
Username : AdminMJ
Classname : vB_Database
MySQL Version : 5.5.23-55

Any idea how I can fix this?

Thank you

MJ

Here is the fix

dragonsflight

01-04-2013 05:19 PM

Thank you!! It worked!

Alibass

01-04-2013 05:24 PM

Quote:

Originally Posted by ForceHSS (Post 2394653)

was never but you can do this
admincp/Plugins & Products/Add New Plugin
Product = vBulletin
Hook Location = useradmin_edit_column1
Title = Submit to StopForumSpam.com
Execution Order = 5
Plugin PHP Code

PHP Code:


		
			
if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
        { 
            print_table_break('', $INNERTABLEWIDTH);
            print_table_header("Submit to StopForumSpam");
            
                print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username"  size="30" value="'. 
$user['username'] . '"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"  size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td>
<td><input type="text" name="ip_addr"  value="' .$user['ipaddress'] . '"></td></tr></table>
<input name="api_key" type="hidden" value="YOUR API KEY"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()"  type="button" class="button" value="' . $vbphrase['submit'] . '"/>');   
        }

MAKE SURE YOU PUT IN YOUR API KEY You will see it on this line <input name="api_key" type="hidden" value="YOUR API KEY">
Plugin is Active = Yes

Thanks for this, you have been a big help with this mod :):up:

dragonsflight

01-04-2013 07:14 PM

Installed successfully. Now when I try to add a post I get this:

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(532) : 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/whatsyou/public_html/includes/functions_newpost.php(532) : eval()'d code on line 5

Is this related to Spam O Matic?

That is the last mod I made to my forum. Thanks for the help.

MJ

Big Engine

01-04-2013 07:21 PM

Quote:

Originally Posted by dragonsflight (Post 2394729)

Are you sure you didn't miss this step ?

2.2. Upload content of the upload folder into you forum root folder

*

dragonsflight

01-04-2013 07:38 PM

Yep, I did upload the upload folder to my root. Intact.

MJ

dragonsflight

01-04-2013 07:40 PM

seems I was a bit too literal. It's working now.

Thanks!

MJ

hubbers72

01-06-2013 11:54 AM

Does this work on VB5?

spd2612

01-06-2013 01:29 PM

Is there a way I can give a user / moderator access to the Spam 0 Matic Logs ?

aspen0

01-06-2013 02:03 PM

Will this do anything with blocking and or with the easy-cleanup feature for removing blog spam?

vb has really poor built in tools for managing blog spam, its a problem in need of a solution.

All times are GMT. The time now is 10:45 AM.

Page 241 of 350

241

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04344 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 (1)bbcode_php_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
Messages: