[baddude]

I get this error when I tried to upgrade.. I tried it several times and then I went to the sever and deleted all files for the vbchat and unistalled the VBChat product and tried installing the product again but still doesnt work..
Database error in vBulletin 3.6.4:

Invalid SQL:
CREATE TABLE `vbchat_store` (
`sid` int(15) NOT NULL auto_increment,
`s_postby` int(15) NOT NULL default '0',
`s_message` mediumtext NOT NULL default '',
`s_postime` int(15) NOT NULL default '0',
`s_foruser` int(15) not null default '0',
PRIMARY KEY (`sid`)
) TYPE=MyISAM;;

MySQL Error : Table 'vbchat_store' already exists
Error Number : 1050
Date : Tuesday, April 24th 2007 @ 10:17:44 AM

Edit:: I went in and deleted the two table for VBChat 'vbchat_store' and vbchat_datastore' and now I get this error..

Database error in vBulletin 3.6.4:

Invalid SQL:
alter table user
add vbchat_pref_font_face varchar(255) not null default '',
add vbchat_pref_font_color varchar(255) not null default '',
add vbchat_pref_user_ignore text not null default '';;

MySQL Error : Duplicate column name 'vbchat_pref_font_face'
Error Number : 1060