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.
Display All
PHP Source Code
- [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;
- UPDATE uni1_planets as p, uni1_users as u SET
- p.metal = -446263.023494,
- p.crystal = -6018568.15185,
- p.deuterium = 4306153.19697,
- p.eco_hash = '649d89d4ceff337f58a61f3bdc7f2dfd',
- p.last_update = 1506629977,
- p.b_building = '1506630203',
- 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";}}',
- p.field_current = 146,
- p.b_hangar_id = '',
- p.metal_perhour = 141884579.729,
- p.crystal_perhour = 38463206.099,
- p.deuterium_perhour = 4507417.86473,
- p.darkmatter_perhour = 0,
- p.metal_max = 18432500000,
- p.crystal_max = 883750000,
- p.deuterium_max = 63125000,
- p.energy_used = -11344.8467206,
- p.energy = 16959,
- p.b_hangar = 0, p.solar_plant = p.solar_plant + 1, p.metal_mine = p.metal_mine + 1, u.darkmatter = 17602,
- u.antimatter = 8616,
- u.b_tech = '1506631096',
- u.b_tech_id = '124',
- u.b_tech_planet = '598',
- 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";}}'
- WHERE
- p.id = 598 AND
- u.id = 57;
- UNLOCK TABLES;"
- File: /home/muffin/public_html/ogamespeed.net/includes/classes/class.Database.php | Line: 274
- URL: http://ogamespeed.net/game.php?page=buildings | Version: 1.7.2676
- Stack trace:
- #0 /includes/classes/class.PlanetRessUpdate.php(877): Database->multi_query('LOCK TABLE uni1...')
- #1 /includes/classes/class.PlanetRessUpdate.php(810): ResourceUpdate->SavePlanetToDB(Array, Array)
- #2 /includes/classes/class.PlanetRessUpdate.php(689): ResourceUpdate->SetNextQueueTechOnTop()
- #3 /includes/classes/class.PlanetRessUpdate.php(102): ResourceUpdate->ResearchQueue()
- #4 /includes/classes/missions/MissionCaseSpy.php(61): ResourceUpdate->CalcResource(Array, Array, true, '1506631026')
- #5 /includes/classes/class.FlyingFleetHandler.php(82): MissionCaseSpy->TargetEvent()
- #6 /includes/FleetHandler.php(40): FlyingFleetHandler->run()
- #7 /includes/common.php(126): require('/home/muffin/p...')
- #8 /game.php(35): require('/home/muffin/p...')
- #9 {main}