[TCE Killa]

Originally Posted by erasma

I am having this error pls help thanks

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
`user` AS user
LEFT JOIN
`userfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN()
AND ( FIND_IN_SET('6', membergroupids) OR usergroupid = '6' )
AND
field5 != ''
AND
user.posts >= '0'
AND
user.lastvisit >= '1170862866'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND ( FIND_IN_SET('6', membergroupids) OR usergroupid = '6' )
AND
fie' at line 13
Error Number : 1064
Date : Thursday, February 7th 2008 @ 05:41:06 PM
Script : http://gameforum.co.za/forum/index.php
Referrer : http://gameforum.co.za/forum/admincp/index.php?do=head
IP Address :
Username :
Classname : vB_Database

I had this error to. Just go to vbulletin options and XBox live and put in the correct field number... the field number for your Xbox live leaderboard gaming tag.