[JuGgOlOw22]

Wanted to give a heads up.

When I installed this awards system, (which is great btw), I got this error:

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE 1=1
AND post.postid IN (0,1691,2180,2184,2185,2187,2188,2189,2190,2252,22 79,2280,2286,2327,2332,2333,2337,2338)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Table 'setxapa2_forum.award_user' doesn't exist Error Number : 1146
Date : Friday, April 20th 2007 @ 04:59:56 PM

This happened because I had installed Nova Awards.

Fix:

1. Uninstall Nova Awards
2. Uninstall YAAS
3. Re-Install YAAS


Voila!