[CAG CheechDogg]

WOAH! lol ...

After a little searching I figured out the problem to fix the error above:

In your "award_user.php" file inside upload/admincp find the following:

$awards = $db->query("
			SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
			FROM " . TABLE_PREFIX . " award_user as award_user
			LEFT JOIN " . TABLE_PREFIX . " award as award USING (award_id)
			WHERE award_user.userid = " . $vbulletin->GPC['userid']
		);

Replace it with :

$awards = $db->query("
			SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
			FROM " . TABLE_PREFIX . "award_user as award_user
			LEFT JOIN " . TABLE_PREFIX . "award as award USING (award_id)
			WHERE award_user.userid = " . $vbulletin->GPC['userid']
		);

The thing causing this error was the extra space between the (") and award as award USING (award_id) in the 3rd line (LEFT JOIN) which I highlighted in red above ....