Error on View Banned Users

[snyx]

Database error in vBulletin 3.5.3:

Invalid SQL:

        SELECT user.userid, user.username, user.usergroupid AS busergroupid,
        userban.usergroupid AS ousergroupid,
        IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
        bandate, liftdate, reason,
        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(11)
        ORDER BY userban.liftdate ASC, user.username;

MySQL Error  : Column: 'reason' in field list is ambiguous
Error Number : 1052
Date         : Monday, January 16th 2006 @ 11:25:16 PM
Script       : http://www.fnk.ca/board/modcp/banning.php?do=modify
Referrer     : http://www.fnk.ca/board/admincp/index.php?do=nav
IP Address   : 24.85.94.216
Username     : sNyx™
Classname    : vb_database

[snyx]

another

MySQL Error  : Column: 'reason' in field list is ambiguous
Error Number : 1052
Date         : Monday, January 16th 2006 @ 11:28:30 PM
Script       : http://www.fnk.ca/board/modcp/banning.php
Referrer     : http://www.fnk.ca/board/modcp/banning.php
IP Address   : 24.86.13.74
Username     : MC Hammered
Classname    : vb_database

[Steve Machol]

This error means that you have installed a hack or plugin that modified the database and created an extra 'reason' field that conflicts with the default vB database. You need to find out which mod is responsible for this and remove it.

[snyx]

okay I axed a pair of unused rason tables, now I get this

MySQL Error  : Unknown column 'reason' in 'field list'
Error Number : 1054

Where aboots would I be looking for the field list, my search keeps loading blank for me

[Guest]

You've made modifications to the php file ./root/modcp/banning.php, you should remove the modifications or upload a unmodified version of the file.

[snyx]

I have fresh copies of all vbulletin files, I don't understand what could be the issue. I have checked my db many times.

[Steve Machol]

Please reread post #3. One of your hacks modified the db to cause this problem. You need to find out which hack this is and remove the changes it made.

As per post #4 it looks like you may have removed a valid 'reason' field. You should not have removed any reason field you find. Only remove the one added by your hack.

[snyx]

hunting down hacks made to my db from vb 2x & vb3.0 would be near impossible. also I only removed one reason feild, the rest I restored.

[Steve Machol]

You'll need to do some more hunting. This error is either from a hack still installed in your vB files, or from a missing 'reason' field that should be there. If you had provided the complete error I could tell you more.