hey mate, i'm getting:
Code:
Database error in vBulletin 3.5.1:
Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vb_user AS users LEFT JOIN vb_user AS user ON (users.referrerid = user.userid) LEFT JOIN vb_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;
MySQL Error : Unknown table 'usergroup' in field list
Error Number : 1109
Date : Saturday, December 3rd 2005 @ 04:16:21 PM
Script : http://commodorelife.com/forums/
Referrer :
IP Address : 220.101.20.174
Username : kurtbarker
Classname : vb_database
any suggestions?