![]() |
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 |
Quote:
|
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 |
hey - can anybody help out here ?
Thanks. |
Try finding that CREATE TABLE query in the files and change:
TYPE=MyISAM ...to: ENGINE=MyISAM |
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 |
Engine did it - thanks man!
|
A big thanks - 133 spammers were stopped just last night!
|
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 ? |
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|