| Gholsie |
03-13-2012 01:22 PM |
I currently have 1.1.0 beta 4.2 and tried installing this version. Here's the database error I get when I try to import the product into vBulletin 4.1.11.
Quote:
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
Request Date : Tuesday, March 13th 2012 @ 06:20:36 AM
Error Date : Tuesday, March 13th 2012 @ 06:20:37 AM
Script : http://www.classiczcars.com/forums/a...=productimport
Referrer : http://www.classiczcars.com/forums/a...?do=productadd
IP Address : 189.34.23.121
Username : Mike
Classname : vB_Database
MySQL Version : 5.5.19-cll
|
|
More Information