[FAQ] Why is there an error when updating statistics?

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • [FAQ] Why is there an error when updating statistics?

    USER ERROR
    Message: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details.
    File: /includes/classes/Database.class.php
    Line: 259
    URL: xnova.nat.cu/admin.php?page=statsupdate
    PHP-Version: 7.3.29
    PHP-API: fpm-fcgi
    2Moons Version: 2.2.git
    Debug Backtrace:
    #0 /includes/classes/Database.class.php(259): PDO->query('SELECT @i := 0;')
    #1 /includes/classes/class.statbuilder.php(263): Database->nativeQuery('SELECT @i := 0;')
    #2 /includes/classes/class.statbuilder.php(443): statbuilder->SetNewRanks()
    #3 /includes/pages/adm/ShowStatUpdatePage.php(24): statbuilder->MakeStats()
    #4 /admin.php(147): ShowStatUpdatePage()
    #5 {main}

  • Cambia esa función a ver si resuelves

    Source Code: clas.statbuilder.php

    1. private function SetNewRanks()
    2. {
    3. foreach($this->Unis as $uni)
    4. {
    5. foreach(array('tech', 'build', 'defs', 'fleet', 'total') as $type)
    6. {
    7. Database::get()->nativeQuery('SET @i := 0;');
    9. $sql = 'UPDATE %%STATPOINTS%% SET '.$type.'_rank = (SELECT @i := @i + 1)
    10. WHERE universe = :uni AND stat_type = :type
    11. ORDER BY '.$type.'_points DESC, id_owner ASC;';
    13. Database::get()->update($sql, array(
    14. ':uni' => $uni,
    15. ':type' => 1,
    16. ));
    18. Database::get()->nativeQuery('SET @i := 0;');
    20. Database::get()->update($sql, array(
    21. ':uni' => $uni,
    22. ':type' => 2,
    23. ));
    24. }
    25. }
    26. }
    Display All
    VERY SAD :/ :/ :/ :/