訊息: SQL錯誤: Out of range value for column 'metal' at row 1
" o1 h4 p# Q2 T7 P) P
. c6 h6 L6 ^/ k$ u: A& ^3 I查詢代碼: LOCK TABLE uni1_planets as p WRITE, uni1_users as u WRITE; UPDATE uni1_planets as p, uni1_users as u SET p.metal = -38349269.705882, p.crystal = 4134753093.8749, p.deuterium = 449824598.9286, p.eco_hash = 'de4678bc2132b9c7646b11e9032c29cc', p.last_update = 1441257765, p.b_building = '0', p.b_building_id = '', p.field_current = 230, p.b_hangar_id = '', p.metal_perhour = 545856112.84943, p.crystal_perhour = 870348519.24163, p.deuterium_perhour = 53129952.495367, p.metal_max = 11925000000, p.crystal_max = 11925000000, p.deuterium_max = 11925000000, p.energy_used = -46327.972430595, p.energy = 545478, p.b_hangar = 0, p.metal_mine = p.metal_mine + 5, u.darkmatter = 493, u.b_tech = '1441258262', u.b_tech_id = '118', u.b_tech_planet = '7426', u.b_tech_queue = 'a:3:{i:0;a:5:{i:0;i:118;i:1;i:14;i:2;d:497;i:3;d:1441258262;i:4;s:4:"7426";}i:1;a:5:{i:0;i:118;i:1;i:15;i:2;d:1989;i:3;d:1441260748;i:4;s:4:"7452";}i:2;a:5:{i:0;i:118;i:1;i:16;i:2;d:3979;i:3;d:1441264727;i:4;s:4:"7451";}}' WHERE p.id = 7426 AND u.id = 1162; UNLOCK TABLES; ^, Y3 V$ g4 P
檔案: /includes/classes/class.Database.php2 p& x* `% |3 ~' ]. ]
行數: 280/ [# J( v; ^* }( v
網址: http://u2.myxnova.com/game.php?page=recomand
2 P$ N* @5 g5 I4 PPHP-版本: 5.6.11) F) ]- A( L( C9 P
PHP-API: apache2handler
$ J {. K! H! S+ Y# @" x' g0 FMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
; b& Z: k1 ]3 U* [5 j0 D宇宙戰記版本: 1.4, F5 X9 }# f9 W+ ]0 |$ e
除錯追蹤路徑:
_, z7 \* q2 Q5 S. M; H; k1 @' e0 n#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')( x6 K- _+ E* z4 x
#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
7 I5 N( X1 `( N& ?#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()& o# ~& V- T$ f3 T& H9 Y; }& |2 P
#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()9 s+ X i) ^" o; L1 Z
#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
$ C. m) U3 t$ b! d#5 /includes/pages/game/class.ShowRecomandPage.php(34): AbstractPage->__construct()
4 L+ ~5 K% t9 Y#6 /game.php(50): ShowRecomandPage->__construct()! j' G! [9 X) {7 X8 B
#7 {main} |