[TCE Killa]

Originally Posted by Queball_Beast

I got this error after the the upgrade. Product disable for the time being.

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`gpuser` AS user
LEFT JOIN
`gpuserfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gpgxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN(8)

AND
field0 != ''
AND
user.posts >= '10'
AND
user.lastvisit >= '0'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : Unknown column 'field0' in 'where clause'
Error Number : 1054
Date : Friday, January 25th 2008 @ 10:10:32 PM
Script : http://www.gamerspride.com/phpBB2/online.php
Referrer : http://www.gamerspride.com/phpBB2/online.php
IP Address : **********
Username : ********
Classname : vb_database

Nope sorry, this is the exact error I get when updating.

I have disabled for the time being too.

How do you fix it? Thanks.