I went to manually update my forums cache the other day (not sure if its really related or just something that happened around the same time) and after I did I checked myXBL leaderboard to find that the users all became jumbled. All the listed users got stats from the same 2 people. 4 of us fixed it by re-adding our xbox live names. However not everyone has updated it. I need to know how to fix it. Also I think it would be nice to be able to manually edit or update a users xbox name via acp profile edit, but that's just a suggestions and not really a concern to me getting the leaderboard fixed with out telling everyone to update is.
Link to the messed board.
http://v2.infinite-gaming.com/forum/misc...eaderboard
Thanks,
Cyber_Punk
Weird. I have no idea why this would happen at all. It seems like the multipage link is wrong on your site too. Are you definitely using the latest version?
MyXBL v2 (1.1)
Using the plugin updater tells me all my plugins are up to date.
Weird. I've ran the plugin with no such issues on boards in the past. Is there any chance I could take a peak at the database?
Well I found this has been popping some errors, I have gotten....
Quote:<error>
<dateline>1342807224</dateline>
<script>inc/tasks/myxbl.php</script>
<line>27</line>
<type>2</type>
<friendly_type>Warning</friendly_type>
<message>DOMDocument::loadHTMLFile(http://gamercard.xbox.com/en-US/cyberpunk667.card) [<a href='domdocument.loadhtmlfile'>domdocument.loadhtmlfile</a>]: failed to open stream: Connection timed out</message>
</error>
<error>
<dateline>1342807224</dateline>
<script>inc/tasks/myxbl.php</script>
<line>27</line>
<type>2</type>
<friendly_type>Warning</friendly_type>
<message>DOMDocument::loadHTMLFile() [<a href='domdocument.loadhtmlfile'>domdocument.loadhtmlfile</a>]: I/O warning : failed to load external entity "http://gamercard.xbox.com/en-US/cyberpunk667.card"</message>
</error>
<error>
<dateline>1342807224</dateline>
<script>inc/tasks/myxbl.php</script>
<line>27</line>
<type>2</type>
<friendly_type>Warning</friendly_type>
<message>DOMDocument::loadHTMLFile(http://gamercard.xbox.com/en-US/xDisharmony.card) [<a href='domdocument.loadhtmlfile'>domdocument.loadhtmlfile</a>]: failed to open stream: Connection timed out</message>
</error>
<error>
<dateline>1342807224</dateline>
<script>inc/tasks/myxbl.php</script>
<line>27</line>
<type>2</type>
<friendly_type>Warning</friendly_type>
<message>DOMDocument::loadHTMLFile() [<a href='domdocument.loadhtmlfile'>domdocument.loadhtmlfile</a>]: I/O warning : failed to load external entity "http://gamercard.xbox.com/en-US/xDisharmony.card"</message>
</error>
<error>
<dateline>1343620516</dateline>
<script></script>
<line>0</line>
<type>20</type>
<friendly_type>MyBB SQL Error</friendly_type>
<message>SQL Error: 1064 - 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 '' at line 1
Query: SELECT p.uid, x.valid, x.gamertag, x.game1, x.game2, x.game3 FROM mybb_posts p INNER JOIN mybb_xboxlive x ON (p.uid = x.uid) WHERE </message>
</error>
Also with the pagenation for example one user removed his xbl so I have 9 users yet it still shows a page 2.
Are there just some tables I can export giving my whole database is kinds sensitive.
Ah, now i see the problem. Apparently your server is having issues contacting the xboxm.com server. I'll have to add some kind of check to the task.
Strange I guess I will just disable it for now.
Hi there, was a fix found for this?
I think I have the same issue, many many error reports are being e-mailed to me:
Type: 20
File: (Line no. 0)
Message
SQL Error: 1064 - 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 '' at line 1
Query: SELECT p.uid, x.valid, x.gamertag, x.game1, x.game2, x.game3 FROM mybb_posts p INNER JOIN mybb_xboxlive x ON (p.uid = x.uid) WHERE
I think when eurantor gets done his vacation he was going to update this.
Yes, I'm planning some pretty major updates. I have no idea what would cause the above error though - it's obviously something wrong with the postbit. If you disable the postbit functionality the error aught not to show.