MySQL help please?

[Ntenze]

Here is the error.

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users 
                   LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT 10
mysql error: Unknown column 'user.username' in 'field list'

mysql error number: 1054

Thank's for any help

[Zachery]

Originally Posted by Ntenze

Here is the error.

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users 
                   LEFT JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT 10
mysql error: Unknown column 'user.username' in 'field list'

mysql error number: 1054

Thank's for any help

Can we see the whole error, including the refer and script name. and any other info, like i installed this hack and got this error?

[Ntenze]

Oops Sorry Zachary thought i grabbed it all MYSQYL prefix is portal

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10
mysql error: Unknown column 'user.username' in 'field list'

mysql error number: 1054

Date: Monday 08th of November 2004 08:31:13 PM
Script: http://www.forthebayarea.com/forums/referrals.php
Referer: http://www.forthebayarea.com/forums/index.php?