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 - vbStopForumSpam (https://vborg.vbsupport.ru/showthread.php?t=230921)

jdrakopo 06-29-2013 10:22 PM

Question y'all:
The instructions.txt file says to "Upload the contents of the upload folder into the root of your forums. DOnt upload the "upload" folder itself, just the contets of the upload folder."

Does that mean that *EACH* of the files in the sub-folders under 'Upload' (i.e., admincp, includes) should get dropped right into the root folder ? --> /public_html/staging/forums

Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes

I tried both but got 'Invalid File Specified' when I clicked 'Import' in the 'Import Product' admincp screen.

THANKS !
PS - I'm using VB 4.1.9

bzcomputers 06-30-2013 02:40 AM

Quote:

Originally Posted by jdrakopo (Post 2431257)
Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes

It means the above.

jdrakopo 06-30-2013 11:28 AM

Thanks.
This is the error I'm receiving (below)
I must be missing something simple ?

- - -
Database error in vBulletin 4.1.9:
Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Sunday, June 30th 2013 @ 05:24:53 AM
Error Date : Sunday, June 30th 2013 @ 05:24:53 AM
Script : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productimport
Referrer : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productadd
IP Address : xxx.xx.xxx.xxx

jdrakopo 07-06-2013 03:10 PM

hey - can anybody help out here ?
Thanks.

Jakeman 07-08-2013 02:57 AM

Try finding that CREATE TABLE query in the files and change:

TYPE=MyISAM

...to:

ENGINE=MyISAM

Rob Graves 07-08-2013 03:12 AM

I am getting the exact same error:

Database error in vBulletin 4.1.12:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Sunday, July 7th 2013 @ 11:00:39 PM
Error Date : Sunday, July 7th 2013 @ 11:00:39 PM

SQL version is 5.5.23-55

Rob Graves 07-08-2013 03:21 AM

Engine did it - thanks man!

Rob Graves 07-08-2013 01:46 PM

A big thanks - 133 spammers were stopped just last night!

jdrakopo 07-10-2013 04:32 AM

Yeah - big thanks to jakeman on this.

I certainly would not have picked up on the need to change TYPE to ENGINE.
Is this an issue that needs to get addressed in the next ver of this module ?

Bernd Glasstett 07-10-2013 06:35 AM

It seems, that version 0.61 doesn't work with vBulletin 4.1.11. Is there a way to get an older version, which works with that version of vBulletin 4.1?


All times are GMT. The time now is 11:35 AM.

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.01686 seconds
  • Memory Usage 1,736KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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