[mferguson]

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;
....

I apologize but we obviously missed this in our testing. I've resolved the issue (an extra space prior to our table names when using a vB table prefix), repackaged, and reuploaded a new zip to this thread.

If you are using prefixes for your vBulletin table please redownload the attached .zip and install. If you are not using vBulletin prefixes there is no need to redownload/reinstall.

Again, I apologize for missing this and I'll add this testing scenario to our future regression tests.

Best regards,

Mark