PDA

View Full Version : Just installed, SQL error when I warn a user


rnawky
23 Apr 2005, 04:49
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
23 Apr 2005, 06:13
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
23 Apr 2005, 07:03
Thanks :)

sv1cec
23 Apr 2005, 12:05
Most welcome