[PabloAM]

Originally Posted by 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.

Same problem

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 : Saturday, March 3rd 2007 @ 08:57:58 PM
Script : http://www.xboxers360.net/admincp/cr...cron&cronid=25
Referrer : http://www.xboxers360.net/admincp/cr....php?do=modify
IP Address : 81.202.163.34
Username : PabloAM
Classname : vB_Database

One solution?