[Canis Firebrand]

I uploaded the files and overwrote the older version I had. When I view my list, the gamertag icons and games aren't there.
So, I tried to force the cron job to run. When I do so, I get a database error.

Database error in vBulletin 3.6.4:

Invalid SQL:

		SELECT
			user.*,
			userfield.field5,
			IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
		FROM
			`userfield`
		INNER JOIN
			usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
		LEFT JOIN
			`user` ON userfield.userid = user.userid
		WHERE
			user.posts >= '0'
		AND
			userfield.field5 != '' 
		ORDER BY
			RAND();

MySQL Error  : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date         : Wednesday, February 28th 2007 @ 04:48:56 AM

I looked at my phpadmin and the user table does have a field called usergroupid. So, I'm not sure why it is saying that it is an unknown column.

Also, in the Leaderboard Statistics section, the Top Avatar just reads "By 2 players By 2 players By 2 players By 1 player By 1 player"

That might be because the cron job won't run, however.