[Delphiprogrammi]

hi John,

the upgrade went fine only if i choose the "view banned users" link i get a database crash

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 vb_3user AS user
LEFT JOIN vb_3userban AS userban ON(userban.userid = user.userid)
LEFT JOIN vb_3user 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: Tuesday 28th of December 2004 07:00:22 PM
Script: /admincp/admin_warn.php?act=viewbannedusers
Username: ****************
IP Address: ********

i did all the queries you told us to do in the upgradetolatestversion.txt file mmmm i'm lost i had to lock my forums :speechless:

there is a 'userban' table in my database but no userban.reason look at the image and you'll see what i mean