(已解決)無法遊戲

123698745

用戶錯誤

訊息: SQL Error: Out of range value for column 'metal' at row 1 ) ~0 ?) |* W7 x1 |& Z% ? 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; - [3 `+ w/ S, f& @: B  b, H. ~檔案: /includes/classes/class.Database.php # ^3 W1 c0 G4 y, k- t1 F/ c0 d行: 280 ; ?9 `# z3 K; N% c網址: http://u3.myxnova.com/game.php 3 {( S. u- @# ^' x, ^" \PHP-版本: 5.6.5 PHP-API: apache2handler MySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $ 宇宙戰記版本: 1.7.2749 2 P7 [7 ~9 M8 w$ z5 K: D除錯追蹤路徑: 0 e9 v1 B8 J# T% P/ H8 {) e" z8 M#0 /includes/classes/class.PlanetRessUpdate.php(678): Database->multi_query('LOCK TABLE uni1...') #1 /includes/classes/class.PlanetRessUpdate.php(610): ResourceUpdate->SavePlanetToDB(Array, Array) ; d- X7 {2 C! X% ^" W5 u& K( L#2 /includes/classes/class.PlanetRessUpdate.php(490): ResourceUpdate->SetNextQueueTechOnTop() % M2 @! P. p' S( }#3 /includes/classes/class.PlanetRessUpdate.php(94): ResourceUpdate->ResearchQueue() #4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()   e: Q8 _6 K. i1 n' c+ W#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct() #6 /game.php(50): ShowOverviewPage->__construct() ; E) f0 q- p0 U/ t6 T- x#7 {main} & N. Z& X% ?' V# ?) x * h1 Y, k) f- J& a 4 W% D# b  W$ t請問怎麼回事QQ

  |8 B7 ^! ]* B! j$ N. R$ c) C

admin

Out of range value for column 'metal' at row 1

SET p.metal = -25974645.623644

1 D$ g) x! k  z9 M8 `0 S* Q8 H- d金屬為負的?
) c7 k3 L- A, u. G4 C系統有偵測的功能
資源應該不能為負的(能量除外)
% i& A  O" R1 i9 f6 o0 h偵測到為負數資源就會報錯了

可能是某些功能有bug吧
把資源扣成負數就報錯了
; u! }5 Y3 s7 r  _8 t. a- c
! q/ f# f2 n3 @& a1 c8 h/ k: b目前已經將你的金屬改成0
( F8 K0 L& f+ C0 t% F8 g9 F/ u現在應該正常了

; R8 Z! x3 A+ g! T- f. N7 G# G下次有錯時再報上來吧
記得註明操作方法