[tnguy3n]

Originally Posted by G-Force 199

I got this error :
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vbb_user AS users LEFT JOIN vbb_user AS user ON (users.referrerid = user.userid) LEFT JOIN vbb_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;

MySQL Error  : Unknown column 'usergroup.usergroupid' in 'field list'
Error Number : 1054
Date         : Sunday, November 27th 2005 @ 08:25:24 PM
Script       : http://localhost/forum/
Referrer     : 
IP Address   : 127.0.0.1
Username     : 1st
Classname    : vB_Database

G-Force 199,
usergroupid is the first field in usergroup table, existing in both vb 3.0.x and vb 3.5.x. Unless you drop the field by accident or conflict with other hacks.