uploaded files then tried to import the xml file and got this error
Code:
Database error in vBulletin 3.8.3:
Invalid SQL:
CREATE TABLE IF NOT EXISTS vb3_ DTO_garage_vehicle (
vehicle_id int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
name varchar(50) NOT NULL default '',
year int(4) unsigned NOT NULL default '0',
make varchar(50) NOT NULL default '',
model varchar(50) NOT NULL default '',
color varchar(50) NOT NULL default '',
packages text NOT NULL,
history text NOT NULL,
exteriormods text NOT NULL,
interiormods text NOT NULL,
icemods text NOT NULL,
drivetrainmods text NOT NULL,
suspensionmods text NOT NULL,
wheelsandtires text NOT NULL,
time_modified timestamp NOT NULL default CURRENT_TIMESTAMP,
time_added timestamp NOT NULL default '0000-00-00 00:00:00',
allowcomments tinyint(1) NOT NULL default '1',
display tinyint(1) NOT NULL default '0',
PRIMARY KEY (vehicle_id)
) ENGINE=MyISAM auto_increment=1000;
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 'DTO_garage_vehicle (
vehicle_id int(10) unsigned NOT NULL auto_increment,
' at line 1
Error Number : 1064
Request Date : Friday, June 19th 2009 @ 09:38:14 AM
Error Date : Friday, June 19th 2009 @ 09:38:14 AM
Script : http://www.mysite.com/forum/admincp/plugin.php?do=productimport
Referrer : http://www.mysite.com/forum/admincp/plugin.php?do=productadd
IP Address : 11.111.111.111
Username : myusername
Classname : vb_database
MySQL Version : 5.0.67-community