[bjf2k]

Originally Posted by Watson

Hi,

I did have it previously running, but when I uninstalled it looks like its left the tables. This is good as I have my data still, however when I run the XML file I get the below error.

Database error in vBulletin 3.7.1:

Invalid SQL:
CREATE TABLE itrader (
		  rateid int(10) unsigned NOT NULL auto_increment,
		  userid int(10) unsigned NOT NULL default '0',
		  rateduserid int(10) unsigned NOT NULL default '0',
		  rating tinyint(3) NOT NULL default '0',
		  buyselltrade tinyint(3) unsigned NOT NULL default '0',
		  subject varchar(80) NOT NULL default '',
		  dealurl varchar(255) NOT NULL default '',
		  dateline int(10) unsigned NOT NULL default '0',
		  ipaddress varchar(15) NOT NULL default '',
		  PRIMARY KEY  (userid,rateid),
		  UNIQUE KEY rateduserid (rateduserid,rateid),
		  KEY rateid (rateid)
		) TYPE=MyISAM AUTO_INCREMENT=1;

MySQL Error   : Table 'itrader' already exists

Also when I try and do it via the upgrade file, I get an error telling me tables don't exist. Any help is appreciated.

Cheers

Watson

same thing happened to me, how did you fix the problem?