訊息: SQL Error: Out of range value for column 'metal' at row 1
1 H% b0 |, ]. M! V6 E2 Y% T* A0 [) t6 Q7 b9 R" {/ U; f; h' T
Query 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 = -25974645.623644, p.crystal = 818571860.40518, p.deuterium = 506526413.43294, p.eco_hash = '7d269e8d09197e530f478b54b8933e6e', p.last_update = 1422240561, p.b_building = '1422241134', p.b_building_id = 'a:3:{i:0;a:5:{i:0;i:1;i:1;i:35;i:2;d:635;i:3;d:1422241134;i:4;s:5:"build";}i:1;a:5:{i:0;i:1;i:1;i:36;i:2;d:1429;i:3;d:1422243391;i:4;s:5:"build";}i:2;a:5:{i:0;i:1;i:1;i:37;i:2;d:2144;i:3;d:1422245535;i:4;s:5:"build";}}', p.field_current = 160, p.b_hangar_id = '', p.metal_perhour = 238436402.82089, p.crystal_perhour = 289958470.38389, p.deuterium_perhour = 55653472.584432, p.metal_max = 11925000000, p.crystal_max = 11925000000, p.deuterium_max = 11925000000, p.energy_used = -36700.749147444, p.energy = 47250, p.b_hangar = 0, p.crystal_mine = p.crystal_mine + 1, p.metal_mine = p.metal_mine + 4, u.darkmatter = 3100, u.b_tech = '1422243357', u.b_tech_id = '109', u.b_tech_planet = '6166', u.b_tech_queue = 'a:3:{i:0;a:5:{i:0;i:109;i:1;i:20;i:2;d:2796;i:3;d:1422243357;i:4;s:4:"6166";}i:1;a:5:{i:0;i:120;i:1;i:13;i:2;d:13;i:3;d:1422248613;i:4;s:4:"6166";}i:2;a:5:{i:0;i:120;i:1;i:14;i:2;d:26;i:3;d:1422248639;i:4;s:4:"6166";}}' WHERE p.id = 6166 AND u.id = 962; UNLOCK TABLES;& P5 q% w7 k4 O
檔案: /includes/classes/class.Database.php
! x% y1 P! [( B f3 ~3 x. P3 v行: 280
9 ^! U- U$ N* _' X+ n# h網址: http://u3.myxnova.com/game.php4 J5 t; o0 M# R5 c! ^) U* P1 A2 @" `
PHP-版本: 5.6.5
) E! a% f; j" SPHP-API: apache2handler
% s( X. v' [* F% O7 o1 U( X7 c+ CMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $
# Q* \6 H$ |! @% y宇宙戰記版本: 1.7.2749; C: Z% _: K* Z+ @
除錯追蹤路徑:
9 O( ]. J+ o! ~0 M#0 /includes/classes/class.PlanetRessUpdate.php(678): Database->multi_query('LOCK TABLE uni1...')
' _2 ]/ J7 x& V1 t Y#1 /includes/classes/class.PlanetRessUpdate.php(610): ResourceUpdate->SavePlanetToDB(Array, Array)
3 ~ O( t$ z5 _3 r#2 /includes/classes/class.PlanetRessUpdate.php(490): ResourceUpdate->SetNextQueueTechOnTop()
% V. r* G, @. d+ J0 |: r }1 O#3 /includes/classes/class.PlanetRessUpdate.php(94): ResourceUpdate->ResearchQueue()
' [- p, c8 C5 M: [2 t; f' |#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()! N( C/ |! Z2 t
#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct()
3 w4 b. g# }3 y5 a) o3 V1 o- E#6 /game.php(50): ShowOverviewPage->__construct()" e* R2 s& r" c3 ]3 ?: C1 e
#7 {main}
& L1 w$ y: Q* |' v: e& a# _
$ m7 S& o% g$ g+ Z% ^2 e0 D! j0 L4 t/ {& G
請問怎麼回事QQ |