[Delphiprogrammi]

Originally Posted by Tayeb

Dear Delphi,

On permanent banning I got the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:

UPDATE user SET
usergroupid = 4,
displaygroupid = 4,
warnings=2,
warning_bans = 1,
usertitle = 'Permanently Banned'
WHERE userid = 1571;

MySQL Error : Unknown column 'warning_bans' in 'field list' Error Number : 1054
Date : Monday, August 14th 2006 @ 10:07:12 AM
Script : http://myiwc.com/forums/Warn.php
Referrer : http://myiwc.com/forums/Warn.php?do=...571&post=25317
IP Address : xx.xxx.xx.xx
Username : xxx
Classname : vb_database

Can you help please? The other problem got sorted out with your help.

Tayeb

you don't have a warning_bans field in the user table ? try this

DESCRIBE user;

if the warning_bans field is not there

ALTER TABLE user ADD warning_bans INT(2) DEFAULT '0';

*=keep table prefixes in mind or the queries won't work