訊息: SQL錯誤: Out of range value for column 'metal' at row 1/ z3 u- F& r; T& L9 r
1 J" L" D- G* Y& B, l: 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;; M4 N! v. |5 u
檔案: /includes/classes/class.Database.php
/ X& H% P/ D; B9 h1 A& s$ ~行數: 2807 u! S, P! @, I# T4 l
網址: http://u2.myxnova.com/game.php?page=recomand
0 j: m% ?1 d" V+ X! L# `PHP-版本: 5.6.119 y/ E+ v( X4 N8 C/ f. T+ [" _
PHP-API: apache2handler9 r+ D8 Z" `; X. d! P
MySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
4 O& Y, |& z( a- U宇宙戰記版本: 1.4
- @9 p& m5 ?. {2 D- v* }除錯追蹤路徑:
. c( F7 y$ `! E+ k! `; P#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')( B# E' G1 M" `" |: [
#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
; `2 O- k5 u. Q#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()$ E& R4 N: U3 b/ y6 B# x5 ~! f
#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
# A" h# {: y; u5 w4 ?# F#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource(); R; x) S* n7 F! N' w+ p- ^4 B
#5 /includes/pages/game/class.ShowRecomandPage.php(34): AbstractPage->__construct()" s: {, Q6 g9 P: C. |; v! ?
#6 /game.php(50): ShowRecomandPage->__construct()
6 F+ x7 x6 k! U9 I6 `#7 {main} |