Hello,
I'm trying to install on a freshly upgraded 4.1.11 board and am getting the following error when importing the product:
Code:
Database error in vBulletin 4.1.11:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `xxxxx_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 : Thursday, March 8th 2012 @ 03:30:24 PM
Error Date : Thursday, March 8th 2012 @ 03:30:24 PM
Script : http://www.XXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.XXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address : 24.161.16.84
Username : admin
Classname : vB_Database
MySQL Version : 5.5.20
Any help would be appreciated. Thanks.