got a database error on 4.0.1 upgraded from the 3.8 version of this
Code:
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM award a, award_user au
WHERE (au.userid = 2391) AND (a.award_id=au.award_id) AND (a.award_active=1)
GROUP BY au.userid;
MySQL Error : Unknown column 'award_pointvalue' in 'field list'
Error Number : 1054