Quote:
Originally Posted by xtreme-mobile
right guys ive downloaded the latest files and replaced the "functions_warnings" file on my account and i get the following error when i put the user up to the ban limit
Database error in vBulletin 3.0.6:
Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=7,
warning_bans = 1,
usertitle = 'Temporarily Banned'
WHERE userid = 166
mysql error: Unknown column 'warning_bans' in 'field list'
mysql error number: 1054
Date: Tuesday 08th of February 2005 01:48:57 PM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xxx.xxx.xxx.xx
any ideas? also i dont understand what code you wnat me to show you? sorry mate am quite an amature at this
|
I guess you had installed a previous version first and now you are upgrading. That's why you do not have the warning_bans column. Try running this query:
ALTER TABLE user ADD COLUMN warning_bans int(2)
Remember to add any table prefix if you are using one. Let me know if that works.
rgds