點閱: 623|回覆: 2

[遊戲疑問] 顯示用戶錯誤進不去 [複製連結]

MarkShih@FB

初級會員

等級：6 - 駕輕就熟

經驗值：0 / 50

魔法值：60 / 1729

生命值：0%

升級 86.67%

TA的每日心情

	開心 2015-9-27 18:22

簽到天數: 10 天

[LV.3]偶爾看看II

發表於 2015-9-3 13:49:23 |顯示全部樓層

馬上註冊，結交更多好友，享用更多功能，讓你輕鬆玩轉社群。

您需要登入才可以下載或檢視，沒有帳號？立即註冊

×

求救~~

用戶錯誤

訊息: SQL錯誤： Out of range value for column 'metal' at row 1

查詢代碼： 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;
檔案: /includes/classes/class.Database.php
行數: 280
網址: http://u2.myxnova.com/game.php?page=recomand
PHP-版本: 5.6.11
PHP-API: apache2handler
MySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
宇宙戰記版本: 1.4
除錯追蹤路徑:
#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')
#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()
#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
#5 /includes/pages/game/class.ShowRecomandPage.php(34): AbstractPage->__construct()
#6 /game.php(50): ShowRecomandPage->__construct()
#7 {main}