Just installed, SQL error when I warn a user

[rnawky]

I just installed this mod, and when I go to warn someone, I get this error.

Database error in vBulletin 3.0.7:

Invalid SQL: update user set warning_level='1', warnings='1' where userid='33'
mysql error: Unknown column 'warnings' in 'field list'

mysql error number: 1054

Date: Friday 22nd of April 2005 11:47:10 PM
Script: http://66.221.232.165/forum/Warn.php
Referer: http://66.221.232.165/forum/Warn.php?do=WarnUser&id=33&post=21078
Username: RyanK
IP Address: *.*.*.*

[sv1cec]

Your user table hasn't the proper columns.

Run the following query:

ALTER TABLE `".TABLE_PREFIX."user`
add `warnings` int(5) default '0',
add `warning_level` int(15) default '0',
add `warning_bans` int(2) default '0',
add `alerts` int(5) default '0'

Rgds

[rnawky]

Thanks :)

[sv1cec]

Most welcome