[Qwk86gn]

Originally Posted by twitch

uploaded files then tried to import the xml file and got this error

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

Was having the same error as Twitch
In the product-dto_garage.xml I had to remove some spacing from the table create lines.

Change from this:

 CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . " DTO_garage_vehicle (

To this:

 CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "DTO_garage_vehicle (

Notice the spacing between the quote and DTO , that space needs removed for the next 3 occurrences. The 4th Table create line is correct. Hope that helps, solved my problem.

Thanks for the cool mod!!