訊息: SQL錯誤: Out of range value for column 'metal' at row 1( I% e5 J1 v; ?/ v, g
: I# V+ }" t. b9 ] _7 z) p6 X+ a
查詢代碼: 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;
1 N2 N& m( J9 f- R2 @* E/ m檔案: /includes/classes/class.Database.php
7 k& s/ a! I& n9 l4 x行數: 280& m6 J$ H l9 B! V A' ?
網址: http://u2.myxnova.com/game.php?page=recomand$ v5 I; r1 G. O8 ~% j
PHP-版本: 5.6.11
" w8 S$ `) p( p- g7 OPHP-API: apache2handler
e* B6 b1 L6 m7 U, C8 M9 QMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
) N3 _. X8 B& s% v宇宙戰記版本: 1.4
" N) o: |; p. K2 Y3 c1 b7 o/ L2 d; L; k除錯追蹤路徑:
! b! ]* S: d" z. R* o; H#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...') ^! T4 M: H9 I- b
#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
: i+ a# b: z) n" J#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()& I& P& Z. N' ^7 O3 U
#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()& w* ~0 W+ v6 q$ u% A" J, U
#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()6 c5 z7 Q9 i4 f Y
#5 /includes/pages/game/class.ShowRecomandPage.php(34): AbstractPage->__construct()" [- T# g& H% P
#6 /game.php(50): ShowRecomandPage->__construct(); l# }" L" [8 M% A( H! U' m+ }0 Y! n
#7 {main} |