Ok.. Here's Wat I've Done.. :ermm:
I Installed The Warning HACK 1.0 Then Upgraded To 1.5.
And Then Installed The AWS v3.0.2.!
Now When I Click On Warning Systems > View Ban User's I Get Database Error..!
Quote:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username
mysql error: Unknown column 'userban.reason' in 'field list'
mysql error number: 1054
Date: Sunday 02nd of January 2005 02:14:47 AM
|
Can Some One Help Me Please..! :tired: :tired: :tired: