[Delphiprogrammi]

Originally Posted by wrestlepower

getting an SQL error when trying to modify a user.

MySQL Error : Unknown column 'warn_notes' in 'field list'


Had look through the thread but cant see a fix posted for that yet.

[SQL]
ALTER TABLE user ADD warn_notes SMALLINT DEFAULT '0';
[/SQL]

keep table prefixes in mind if you have one for example if you table table prefix is "vb" the query becomes

[SQL]
ALTER TABLE vb_user ADD warn_notes SMALLINT DEFAULT '0';
[/SQL]