| Myth-Scape |
04-06-2012 01:37 AM |
Whenever I try to import the product I get this error:
Code:
Database error in vBulletin 4.1.11:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbtube_tubes` (
`tubeid` int(20) unsigned NOT NULL auto_increment,
`categoryid` int(3) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`userid` int(20) unsigned NOT NULL default '0',
`username` varchar(70) NOT NULL default '',
`email` varchar(70) NOT NULL default '',
`title` mediumtext,
`vidlang` varchar(50) NOT NULL default '',
`link` varchar(170) NOT NULL default '',
`link1` longtext NOT NULL,
`link2` longtext NOT NULL,
`link3` longtext NOT NULL,
`link1img` varchar(250) NOT NULL default '',
`thumb_type` int(1) unsigned NOT NULL default '0',
`filename` varchar(30) NOT NULL default '',
`mext` varchar(6) NOT NULL default '',
`msize` int(20) unsigned NOT NULL,
`filename_mp4` varchar(30) NOT NULL default '',
`filename_img` varchar(30) NOT NULL default '',
`filename_img2` varchar(30) NOT NULL default '',
`photo_mp3` varchar(30) NOT NULL default '',
`url_flv` varchar(150) NOT NULL default '',
`ofilename` varchar(20) NOT NULL default '',
`oext` varchar(6) NOT NULL default '',
`osize` int(20) unsigned NOT NULL,
`mediatype` varchar(50) NOT NULL default '',
`site` varchar(50) NOT NULL default '',
`aboutme` longtext,
`active` varchar(1) NOT NULL default '0',
`tube` varchar(50) NOT NULL default '',
`views` int(30) unsigned NOT NULL default '0',
`votes` int(10) unsigned NOT NULL default '0',
`rates` int(10) unsigned NOT NULL default '0',
`rating` double(5,2) unsigned NOT NULL default '0.00',
`duration` varchar(15) NOT NULL default '',
`keywords` varchar(250) NOT NULL default '',
`joindate` int(10) unsigned NOT NULL default '0',
`reviewid` int(10) unsigned NOT NULL default '0',
`positive` int(10) unsigned NOT NULL default '0',
`negative` int(10) unsigned NOT NULL default '0',
`reported` varchar(1) NOT NULL default '0',
`reporteruser` varchar(50) NOT NULL default '',
`reportreason` mediumtext,
`reportcategory` varchar(50) NOT NULL default '',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` int(10) unsigned NOT NULL default '0',
`totalcom` int(8) unsigned NOT NULL default '0',
`deleted` int(1) unsigned NOT NULL default '0',
PRIMARY KEY (`tubeid`)
) 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 51
Error Number : 1064
|
More Information