Xterium version fleets are locking.

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

    • Xterium version fleets are locking.

      When players are spying sometimes fleets are locking and when I unlock they don't unlock but throw this error in log. Also I'm using xterium version, does anyone know how to fix this? I checked those planets but they show positive amount of resources not negative like shown in error. And sometimes after some time I can unlock them.

      PHP Source Code

      1. [28-Sep-2017 23:46:32] USER ERROR: "SQL Error: Out of range value for column 'metal' at row 1Query Code: LOCK TABLE uni1_planets as p WRITE, uni1_users as u WRITE;
      2. UPDATE uni1_planets as p, uni1_users as u SET
      3. p.metal = -446263.023494,
      4. p.crystal = -6018568.15185,
      5. p.deuterium = 4306153.19697,
      6. p.eco_hash = '649d89d4ceff337f58a61f3bdc7f2dfd',
      7. p.last_update = 1506629977,
      8. p.b_building = '1506630203',
      9. p.b_building_id = 'a:1:{i:0;a:5:{i:0;i:1;i:1;i:33;i:2;d:317;i:3;d:1506630203;i:4;s:5:"build";}}',
      10. p.field_current = 146,
      11. p.b_hangar_id = '',
      12. p.metal_perhour = 141884579.729,
      13. p.crystal_perhour = 38463206.099,
      14. p.deuterium_perhour = 4507417.86473,
      15. p.darkmatter_perhour = 0,
      16. p.metal_max = 18432500000,
      17. p.crystal_max = 883750000,
      18. p.deuterium_max = 63125000,
      19. p.energy_used = -11344.8467206,
      20. p.energy = 16959,
      21. p.b_hangar = 0, p.solar_plant = p.solar_plant + 1, p.metal_mine = p.metal_mine + 1, u.darkmatter = 17602,
      22. u.antimatter = 8616,
      23. u.b_tech = '1506631096',
      24. u.b_tech_id = '124',
      25. u.b_tech_planet = '598',
      26. u.b_tech_queue = 'a:1:{i:0;a:5:{i:0;i:124;i:1;i:14;i:2;d:1119;i:3;d:1506631096;i:4;s:3:"598";}}'
      27. WHERE
      28. p.id = 598 AND
      29. u.id = 57;
      30. UNLOCK TABLES;"
      31. File: /home/muffin/public_html/ogamespeed.net/includes/classes/class.Database.php | Line: 274
      32. URL: http://ogamespeed.net/game.php?page=buildings | Version: 1.7.2676
      33. Stack trace:
      34. #0 /includes/classes/class.PlanetRessUpdate.php(877): Database->multi_query('LOCK TABLE uni1...')
      35. #1 /includes/classes/class.PlanetRessUpdate.php(810): ResourceUpdate->SavePlanetToDB(Array, Array)
      36. #2 /includes/classes/class.PlanetRessUpdate.php(689): ResourceUpdate->SetNextQueueTechOnTop()
      37. #3 /includes/classes/class.PlanetRessUpdate.php(102): ResourceUpdate->ResearchQueue()
      38. #4 /includes/classes/missions/MissionCaseSpy.php(61): ResourceUpdate->CalcResource(Array, Array, true, '1506631026')
      39. #5 /includes/classes/class.FlyingFleetHandler.php(82): MissionCaseSpy->TargetEvent()
      40. #6 /includes/FleetHandler.php(40): FlyingFleetHandler->run()
      41. #7 /includes/common.php(126): require('/home/muffin/p...')
      42. #8 /game.php(35): require('/home/muffin/p...')
      43. #9 {main}
      Display All
    • Common man, that question has already been asked tons of times, use the search function and please avoid using the name of Xterium in negative threads, you could also use my game fleets are locking. You are making negative effect on other persons games :)

      Regards
    • Sorry for that name using. Just when I downloaded it was called as an xterium. I'm new to this. I only found one more thread regarding locking fleets and nobody fixed that issue there. Only pointed out that the problem is negative ress values. But when I look at those planets I see positive values in Admin panel. That's why I'm asking for someone to help point out what causes those values to show negative.
    • Hello, (this is 2moons) :)

      As you can see, there are negative values.

      p.metal = -446263.023494, p.crystal = -6018568.15185,

      If it are fleets and they have positive resource on planet, then they are bringing negative resource back from the mission, the reason why you can unlock them later is because player ahs enough res on the planet to remove the res in the fleets and not go in negative values on the planet at the end
      => Fix the mission file :)
    • Refering to the error log. Player #57 started a research then that caused an error to go in negative values when he was probed by someone.
      1. #4 /includes/classes/missions/MissionCaseSpy.php(61): ResourceUpdate->CalcResource(Array, Array, true, '1506631026')
      2. #2 /includes/classes/class.PlanetRessUpdate.php(689): ResourceUpdate->SetNextQueueTechOnTop()
      3. #3 /includes/classes/class.PlanetRessUpdate.php(102): ResourceUpdate->ResearchQueue()
      Check those functions and add a check if neg values, cancel