After I uninstalled gxboxlive I have been getting this error. Can anyone tell me how to fix it please?




Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_gxbl AS phrasegroup_gxbl,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_gxbl' in 'field list'
Error Number : 1054
Request Date : Sunday, June 27th 2010 @ 12:47:57 AM
Error Date : Sunday, June 27th 2010 @ 12:47:57 AM
Script : http://www.xxxxxxxxxxx.com/gxboxlive...&sortorder=asc
Referrer :
IP Address : xxxxxxxxxxxxxxxx
Username :
Classname : vB_Database
MySQL Version :

My Leaderboard has not updated in five days. Anyone else having this problem?

Have run scheduled task - no change. Possible Gamercard server issues?

Thanks.

I have 2 users who have been on the leaderboards for well over a year, and now they're not. Their gamertags haven't changed, been edited, or anything, on XBL or our site. Nothing has changed or been messed with, and they vanished. They were number 1 and 2, so it was obvious. I double and triple checked and spelling, spaces, capitalization is all 100%. Ideas?

Edit: There's about a half dozen or so that we've discovered that won't appear on the leaderboard.

I have the same issue with several gamertags and I am sure it has to be with MS servers. Is your board updating the scores? Mine has not updated in seven days now. Gamertags in the profiles are fine, just the feed to leaderboard.

On my vb3.8.5 board its the same as above

Same here. Missing a lot of gamertags... Can this be fixed ?

I think, all have the same problem, because even the authors leaderboards in the example show the 25.06.2010 as last update.

Same here. Not updating with new additions, or gamertag changes.

The user profile part of it is working properly - just not the list.

Is there a fix yet for the non-updating leaderboards? Mine hasn't been updated for over 3 weeks.

Well, I can tell you why it doesn't work. The requests being made by miner.gxboxlive.php on line 93 are being rejected.

If you throw together some inline code to output the result of that to the Admin console then you see a bunch of Access Denied messages.

Now, it is possible to remove all the query parameters in that string above and it starts to work again. However, I strongly suspect (with no actual evidence) that Microsoft has banned all requests with that query string involved and their Community Developer terms of service explicitly state that they reserve the right to ban any site or application they consider to be abusing their system.

As a result, I strongly suggest that, if you fancy your hand at hacking out the query string, that you also ensure the gXboxLive scheduled task runs no more than once per day. Abuse may lead to banning and I didn't see any right of appeal.

YMMV but good luck.