error.log What is the error?

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

    • error.log What is the error?

      Hi~~
      Often the following error occurs.
      It's the galaxy and the missile part, can you tell me what the error is?
      The source doesn't seem to have any problems.

      ShowGalaxyPage.class.php error line 91....

      89: $USER += Database::get()->selectSingle($sql, array(
      90: ':userId' => $USER['id'],
      91: ':statType' => 1
      92: ));



      ============================
      [30-Dec-2022 12:00:02] USER ERROR: "Unsupported operand types"
      File: /www_root/includes/pages/game/ShowGalaxyPage.class.php | Line: 91
      URL: /game.php?page=galaxy | Version: 2.0.git
      Stack trace:
      #0 /game.php(57): ShowGalaxyPage->show()
      #1 {main}
      ============================
      [02-Jan-2023 20:59:34] USER ERROR: "SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'interplanetary_misil' at row 1
      Query-Code:UPDATE uni1_planets SET interplanetary_misil = interplanetary_misil - 7 WHERE id = 12702;"
      File: /www_root/includes/classes/Database.class.php | Line: 126
      URL: /game.php?page=fleetMissile | Version: 2.0.git
      Stack trace:
      #0 /includes/classes/Database.class.php(177): Database->_query('UPDATE uni1_pla...', Array, 'update')
      #1 /includes/classes/class.FleetFunctions.php(585): Database->update('UPDATE %%PLANET...', Array)
      #2 /includes/pages/game/ShowFleetMissilePage.class.php(162): FleetFunctions::sendFleet(Array, 10, '674', '12702', '3', '153', '8', '1', '20', '1322', 3, 101, 7, 1, Array, 1672663924, 1672663924, 1672663924, 0, 411)
      #3 /game.php(57): ShowFleetMissilePage->show()
      #4 {main}
      ===========================
      --------------------------------------------------------------------------------------

    • noonn wrote:

      [30-Dec-2022 12:00:02] USER ERROR: "Unsupported operand types"
      File: /www_root/includes/pages/game/ShowGalaxyPage.class.php | Line: 91
      URL: /game.php?page=galaxy | Version: 2.0.git
      Stack trace:
      #0 /game.php(57): ShowGalaxyPage->show()
      #1 {main}
      For this error it is possible that it conflicts with the global variable $USER, and from what I see it adds an int to a String from time to time.

      noonn wrote:

      [02-Jan-2023 20:59:34] USER ERROR: "SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'interplanetary_misil' at row 1
      Query-Code:UPDATE uni1_planets SET interplanetary_misil = interplanetary_misil - 7 WHERE id = 12702;"
      File: /www_root/includes/classes/Database.class.php | Line: 126
      URL: /game.php?page=fleetMissile | Version: 2.0.git
      Stack trace:
      #0 /includes/classes/Database.class.php(177): Database->_query('UPDATE uni1_pla...', Array, 'update')
      #1 /includes/classes/class.FleetFunctions.php(585): Database->update('UPDATE %%PLANET...', Array)
      #2 /includes/pages/game/ShowFleetMissilePage.class.php(162): FleetFunctions::sendFleet(Array, 10, '674', '12702', '3', '153', '8', '1', '20', '1322', 3, 101, 7, 1, Array, 1672663924, 1672663924, 1672663924, 0, 411)
      #3 /game.php(57): ShowFleetMissilePage->show()
      #4 {main}
      For this error, what I see is that when sending missiles to the database, your number falls into negative, which generates this error because the column is UNSIGNED and therefore does not take negative numbers.

    • noonn wrote:

      Hi~~
      Often the following error occurs.
      It's the galaxy and the missile part, can you tell me what the error is?
      The source doesn't seem to have any problems.

      ShowGalaxyPage.class.php error line 91....

      89: $USER += Database::get()->selectSingle($sql, array(
      90: ':userId' => $USER['id'],
      91: ':statType' => 1
      92: ));



      ============================
      [30-Dec-2022 12:00:02] USER ERROR: "Unsupported operand types"
      File: /www_root/includes/pages/game/ShowGalaxyPage.class.php | Line: 91
      URL: /game.php?page=galaxy | Version: 2.0.git
      Stack trace:
      #0 /game.php(57): ShowGalaxyPage->show()
      #1 {main}
      ============================
      [02-Jan-2023 20:59:34] USER ERROR: "SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'interplanetary_misil' at row 1
      Query-Code:UPDATE uni1_planets SET interplanetary_misil = interplanetary_misil - 7 WHERE id = 12702;"
      File: /www_root/includes/classes/Database.class.php | Line: 126
      URL: /game.php?page=fleetMissile | Version: 2.0.git
      Stack trace:
      #0 /includes/classes/Database.class.php(177): Database->_query('UPDATE uni1_pla...', Array, 'update')
      #1 /includes/classes/class.FleetFunctions.php(585): Database->update('UPDATE %%PLANET...', Array)
      #2 /includes/pages/game/ShowFleetMissilePage.class.php(162): FleetFunctions::sendFleet(Array, 10, '674', '12702', '3', '153', '8', '1', '20', '1322', 3, 101, 7, 1, Array, 1672663924, 1672663924, 1672663924, 0, 411)
      #3 /game.php(57): ShowFleetMissilePage->show()
      #4 {main}
      ===========================
      1- me he dado cuenta que suele ocurrir justo cuando actualiza las estadísticas y un usuario visita la galaxia al mismo tiempo da ese error, lo mismo puede pasar si coincide al visitar las estadísticas
      2- ocurre cuando el usuario esta intentando enviar mas misiles de lo que el campo en la base de datos permite. Momentáneamente lo resolvi cambiando el campo en la base de datos bigint(20)
      VERY SAD :/ :/ :/ :/

      The post was edited 1 time, last by yamilrh ().

    • You are trying to sum array and boolean times to times.

      $var = $db->selectSingle(...);

      İf (isset($var))
      $USER = array_merge($USER, $var);

      But this problem actually caused by stat updates, stat updates uses TRUNCATE table, so sometimes there is no stats to show, it is working wrong, it should use another method
      ogniter.net

      for a slightly better version of steemnova

      github.com/koraykarakus/steemnova-1.8-x

      The post was edited 1 time, last by amamoslavida ().