[Help] Not working recoded SG stats page

Discussion in 'Help & Support / Errors & Bugs' started by 314, May 21, 2014.

  1. 314

    314 Irrational GameAdmin, former ServerAdmin
    EcoLegend ⛰️⛰️⛰️⛰️ Ex-President ⚒️⚒️ Prestige ⭐ VI ⭐ Premium Upgrade

    Joined:
    Apr 1, 2014
    Messages:
    7,219
    Trophy Points:
    101,160
    EcoDollars:
    $0
    Ratings:
    +4,919
    Dear staff team,
    after I read in the announcements that the SG stats page has been recoded to fit the new UUID's I went there to see how my SG rank developed since it was put down. But then I saw that only the indicators Rank (12647), W/L (0%), K/D (0) and Time (0:0:00) are shown, the other indicators are simply empty. It also shows none of my former games listed in the table below, but it shows a message saying "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 'GROUP BY `s`.`gameID` ORDER BY `s`.`gameID` DESC LIMIT 0,30' at line 7 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/ecocitycraft/public_html/newsgstats/pages/player.php on line 86". I have tried reloading the page for many times and played another SG to see whether the stats update, but the problem is still consisting. I would be grateful if a mod - or in that case better a dev - could please take a look at it.

    Thank you in advance!

    -314 a.k.a. Pi-
     
  2. KHobbits

    KHobbits Builder
    Builder ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Premium Upgrade

    Joined:
    Aug 19, 2011
    Messages:
    257
    Trophy Points:
    51,290
    Gender:
    Male
    Ratings:
    +236
    This is because you are using the old link.
    I've made that page display an error instead saying the uuid doesn't exist.
     
  3. 314

    314 Irrational GameAdmin, former ServerAdmin
    EcoLegend ⛰️⛰️⛰️⛰️ Ex-President ⚒️⚒️ Prestige ⭐ VI ⭐ Premium Upgrade

    Joined:
    Apr 1, 2014
    Messages:
    7,219
    Trophy Points:
    101,160
    EcoDollars:
    $0
    Ratings:
    +4,919
    Thank you very much for your quick and good help! It's finally working. All my stats are shown correctly now. Also updated my firefox bookmark so I won't be misled by it again. :D Once again I see how helpful the ECC team is. :)

    -314 a.k.a. Pi-