Frequent error log.

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

    • Frequent error log.

      What could be the problem? X/ X/
      ===========================
      USER ERROR: "SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'interplanetary_misil' at row 1

      Query-Code:UPDATE uni_planets SET interplanetary_misil = interplanetary_misil - 10 WHERE id = 2251;"
      File: classes/Database.class.php | Line: 126
      URL: game.php?page=fleetMissile | Version: 2.0.git
      Stack trace:
      #0 classes/Database.class.php(177): Database->_query('UPDATE uni1_pla...', Array, 'update')
      #1 classes/class.FleetFunctions.php(585): Database->update('UPDATE %%PLANET...', Array)
      #2 pages/game/ShowFleetMissilePage.class.php(162): FleetFunctions::sendFleet(Array, 10, '527', '10176', '1', '59', '5', '1', '438', '7633', 1, 57, 11, 1, Array, 1676781533, 1676781533, 1676781533, 0, 0)
      #3 /game.php(57): ShowFleetMissilePage->show()
      #4 {main}
      --------------------------------------------------------------------------------------

    • yamilrh wrote:

      intenta cambiar ese campo en la bd de double(255,0) a bigint(20)
      Lo mismo para el campo interceptor_misil
      De momento creo que deberia resolver el problema


      Thanks for all friend.
      Double(255,0) is being used in 2moons 2.0 version.
      Is there any problem if I change all of them to bigint(20)?

      other sql
      ============ bigint(20) ==========
      `orbital_station` bigint(20) unsigned NOT NULL DEFAULT '0',
      `misil_launcher` bigint(20) unsigned NOT NULL DEFAULT '0',
      `interceptor_misil` bigint(20) unsigned NOT NULL DEFAULT '0',
      `interplanetary_misil` bigint(20) unsigned NOT NULL DEFAULT '0',

      My sql
      ============ double(255,0) ========
      `orbital_station` double(255,0) UNSIGNED NOT NULL DEFAULT 0,
      `misil_launcher` double(255,0) UNSIGNED NOT NULL DEFAULT 0,
      `interceptor_misil` double(255,0) UNSIGNED NOT NULL DEFAULT 0,
      `interplanetary_misil` double(255,0) UNSIGNED NOT NULL DEFAULT 0,
      --------------------------------------------------------------------------------------

    • No, de echo yo todo los tengo cambiado para evitar errores como ese, en algún momento me pasaron y se resolvieron

      SQL-Query

      1. `small_ship_cargo` bigint(20) sin firmar NOT NULL DEFAULT 0,
      2. `big_ship_cargo` bigint(20) sin firmar NOT NULL DEFAULT 0,
      3. `light_hunter` bigint(20) sin firmar NO NULO PREDETERMINADO 0,
      4. `heavy_hunter` bigint(20) sin firmar NOT NULL DEFAULT 0,
      5. `crusher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      6. `battle_ship` bigint(20) sin firmar NOT NULL DEFAULT 0,
      7. `colonizador` bigint(20) sin firmar NOT NULL DEFAULT 0,
      8. `recycler` bigint(20) sin firmar NOT NULL DEFAULT 0,
      9. `spy_sonde` bigint(20) sin firmar NOT NULL DEFAULT 0,
      10. `bomber_ship` bigint(20) sin firmar NOT NULL DEFAULT 0,
      11. `solar_satelit` bigint(20) sin firmar NOT NULL DEFAULT 0,
      12. `destructor` bigint(20) sin firmar NOT NULL DEFAULT 0,
      13. `dearth_star` bigint(20) sin firmar NOT NULL DEFAULT 0,
      14. `acorazado` bigint(20) sin firmar NOT NULL DEFAULT 0,
      15. `lune_noir` bigint(20) sin firmar NOT NULL DEFAULT 0,
      16. `ev_transporter` bigint(20) sin firmar NOT NULL DEFAULT 0,
      17. `star_crasher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      18. `giga_recykler` bigint(20) sin firmar NOT NULL DEFAULT 0,
      19. `dm_ship` bigint(20) NO NULO PREDETERMINADO 0,
      20. `orbital_station` bigint(20) sin firmar NOT NULL DEFAULT 0,
      21. `misil_launcher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      22. `small_laser` bigint(20) sin firmar NOT NULL DEFAULT 0,
      23. `big_laser` bigint(20) sin firmar NO NULO PREDETERMINADO 0,
      24. `gauss_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      25. `ionic_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      26. `buster_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      27. `small_protection_shield` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      28. `planet_protector` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      29. `big_protection_shield` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      30. `graviton_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      31. `interceptor_misil` bigint(20) sin firmar NOT NULL DEFAULT 0,
      32. `interplanetary_misil` bigint(20) sin firmar NOT NULL DEFAULT 0,
      Display All
      VERY SAD :/ :/ :/ :/

    • yamilrh wrote:

      No, de echo yo todo los tengo cambiado para evitar errores como ese, en algún momento me pasaron y se resolvieron

      SQL-Query

      1. `small_ship_cargo` bigint(20) sin firmar NOT NULL DEFAULT 0,
      2. `big_ship_cargo` bigint(20) sin firmar NOT NULL DEFAULT 0,
      3. `light_hunter` bigint(20) sin firmar NO NULO PREDETERMINADO 0,
      4. `heavy_hunter` bigint(20) sin firmar NOT NULL DEFAULT 0,
      5. `crusher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      6. `battle_ship` bigint(20) sin firmar NOT NULL DEFAULT 0,
      7. `colonizador` bigint(20) sin firmar NOT NULL DEFAULT 0,
      8. `recycler` bigint(20) sin firmar NOT NULL DEFAULT 0,
      9. `spy_sonde` bigint(20) sin firmar NOT NULL DEFAULT 0,
      10. `bomber_ship` bigint(20) sin firmar NOT NULL DEFAULT 0,
      11. `solar_satelit` bigint(20) sin firmar NOT NULL DEFAULT 0,
      12. `destructor` bigint(20) sin firmar NOT NULL DEFAULT 0,
      13. `dearth_star` bigint(20) sin firmar NOT NULL DEFAULT 0,
      14. `acorazado` bigint(20) sin firmar NOT NULL DEFAULT 0,
      15. `lune_noir` bigint(20) sin firmar NOT NULL DEFAULT 0,
      16. `ev_transporter` bigint(20) sin firmar NOT NULL DEFAULT 0,
      17. `star_crasher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      18. `giga_recykler` bigint(20) sin firmar NOT NULL DEFAULT 0,
      19. `dm_ship` bigint(20) NO NULO PREDETERMINADO 0,
      20. `orbital_station` bigint(20) sin firmar NOT NULL DEFAULT 0,
      21. `misil_launcher` bigint(20) sin firmar NOT NULL DEFAULT 0,
      22. `small_laser` bigint(20) sin firmar NOT NULL DEFAULT 0,
      23. `big_laser` bigint(20) sin firmar NO NULO PREDETERMINADO 0,
      24. `gauss_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      25. `ionic_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      26. `buster_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      27. `small_protection_shield` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      28. `planet_protector` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      29. `big_protection_shield` tinyint(1) sin firmar NOT NULL DEFAULT 0,
      30. `graviton_canyon` bigint(20) sin firmar NOT NULL DEFAULT 0,
      31. `interceptor_misil` bigint(20) sin firmar NOT NULL DEFAULT 0,
      32. `interplanetary_misil` bigint(20) sin firmar NOT NULL DEFAULT 0,
      Display All

      Thanks.
      I will amend all double(255,0) to bigint(20).

      ^^ ^^
      --------------------------------------------------------------------------------------

    • The problem that you will encounter will be in time because the maximum possible number will be smaller once the limit of the field is reached you will have an error this is why I put double which takes the largest number.

    • Danter14 wrote:

      The problem that you will encounter will be in time because the maximum possible number will be smaller once the limit of the field is reached you will have an error this is why I put double which takes the largest number.
      Thanks a lot for your help.
      :D :D
      --------------------------------------------------------------------------------------