database error when i creat an extra Field:
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `thread_fields_admin` (
`title` varchar(100) NOT NULL default '',
`fieldid` int(10) unsigned NOT NULL auto_increment,
`description` varchar(200) NOT NULL default '',
`forums` varchar(200) NOT NULL default '',
`type` varchar(100) NOT NULL default '',
`size` char(3) NOT NULL default '40',
`options` varchar(200) NOT NULL default '',
`display` varchar(100) NOT NULL default '1',
PRIMARY KEY (`fieldid`)
) 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 11
Error Number : 1064
Request Date : Wednesday, July 30th 2014 @ 07:18:08 PM
Error Date : Wednesday, July 30th 2014 @ 07:18:09 PM
Script : http://www.xxxxxx.com/adminhbdsaf/plugin.php?do=productimport
Referrer : http://www.xxxxxx.com/adminhbdsaf/plugin.php?do=productadd
IP Address : 36.69.38.50
Username : adminxlm
Classname : vB_Database
MySQL Version : 5.6.17-log