Database Error while installing...

[Chris Croft]

Database error in vBulletin 3.0.7:

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'

mysql error number: 1060

Date: Monday 01st of August 2005 09:04:15 AM
Script: http://roflradio.com/admincp/install_vbchat.php
Referer: http://roflradio.com/admincp/install_vbchat.php

I've done everything I can think of to get it to work, and it still won't work... Help please :ermm:

[Andreas]

Drop the colum first or alter the query so it does not try to add it.

[Chris Croft]

Thank you :) All fixed now.

[silenthare]

Ok I have the same problem as well, but i can't find any table in the database with that name.

[Marco van Herwaarden]

Ok I have the same problem as well, but i can't find any table in the database with that name.Because that name is not a tablename, but the name of a column in the user table.