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

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `bfw_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 : Tuesday, December 18th 2012 @ 08:15:59 AM
Error Date : Tuesday, December 18th 2012 @ 08:15:59 AM
Script :/Removed/
Referrer :/Removed/
IP Address : /Removed/
Username : /Removed/
Classname : vB_Database
MySQL Version : 5.5.23-55

thenoob2012

12-18-2012 06:02 PM

I am having the same problem as above

ForceHSS

12-18-2012 08:08 PM

in product-glowhostspamomatic.xml change all instances of

Code:

) TYPE=MyISAM; ');

Code:

) ENGINE=MyISAM; ');

then install again

thenags

12-19-2012 02:16 PM

Ever since updating from vB 3.8 to 4.X last week spam has been outta control for me even with Q&A verification. Going to be installing this tonight. Hopefully it does the trick!

thenags

12-20-2012 03:52 AM

I've installed and got everything configured. However when I registered a test account I get this at the end

"Warning: array_intersect() [function.array-intersect]: Argument #1 is not an array in [path]/modules/navigation.php on line 34"

The account gets registered but why the error?

ForceHSS

12-20-2012 04:52 AM

Quote:

Originally Posted by thenags (Post 2391782)

there is no modules folder unless you renamed the admincp folder as the only navigation.php file is in the admincp folder
If you have not renamed the admincp folder then this problem is from a custom plugin or mod
Check Navigation Manager for errors also any error logs you have post them

thenags

12-20-2012 04:35 PM

Quote:

Originally Posted by ForceHSS (Post 2391789)

You're right. It must have been there before. I've since disabled S-O-M and still have the issue.

Thanks for pointing me in the right direction.

nicklfire

12-22-2012 05:12 AM

i installed this a few days ago and seems to be working. I caught my first post, and tried to moderator it and got this error when i pressed on moderator threads in the admin cp

Not Found

The requested URL /vapor/moderate.php was not found on this server.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

No idea why, cause everything else works fine?

Alibass

12-22-2012 05:29 AM

Quote:

Originally Posted by nicklfire (Post 2392180)

Do you actually have moderate.php file in the vapor folder in your forum root? Looks to me it's not in your forum root.

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

Page 238 of 350

238

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04588 seconds Memory Usage 1,747KB 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: