[Delphiprogrammi]

Originally Posted by Tayeb

Hello,

In Admin CP Statistics Warning per User I am getting the following error:

Database error in vBulletin 3.5.5:

Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;

MySQL Error : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date : Thursday, August 10th 2006 @ 10:47:21 PM
Script : http://mysite/admin/admin_warn.php?d...&type=warnings
Referrer : http://mysite/admin/index.php?do=nav
IP Address : xxx xxxx ssss
Username : xxxxxx
Classname : vb_database

Any idea? I have just installed the warning system.

I'll appreciate any help.

Tayeb

you do not have a warnings field in your user table

ALTER TABLE user ADD warnings INT(5) DEFAULT '0';

keep tableprefixes in mind ...