[andrew67]

Great hack Jason, I have it working on my test board wonderfully. But on trying to install it to my functional board I got the following errors.

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE user_rate_trade (
userrateid int(10) unsigned NOT NULL auto_increment,
rateduser int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
userrating smallint NOT NULL default '0',
usercomments varchar(80) NOT NULL default '',
userdate int(10) unsigned NOT NULL default '0',
userbuysell tinyint(1) unsigned NOT NULL default '0',
userurl varchar(255) NOT NULL default '',
PRIMARY KEY (userrateid),
KEY rateduser (rateduser,userrating),
KEY rateduser_2 (rateduser,userdate,userrating),
KEY rateduser_3 (rateduser,userbuysell,userdate,userrateid),
KEY userdate (userdate)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Table 'user_rate_trade' already exists

mysql error number: 1050

Date: Sunday 03rd of October 2004 04:08:53 PM

This I attempted to fix by search replacing all "user_rate_trade"'s in the php file with "vb3_user_rate_trade".

Then attempted to install again.
And received the following.

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'tratings', 'Trader Ratings', 1)
mysql error: Duplicate entry 'tratings-0-1' for key 2

mysql error number: 1062

Which I then fixed by removing all the phrases that were added by the php file.

Then went to install a third time and received.

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ratetradetotal'

mysql error number: 1060

Any ideas?

My next approach is to change the "vb3_user_rate_trade" to something else again and change the "ratetradetotal" to something else as I can't actually remove the tables (no access).
Cheers
andrew