[MU] Cần giúp lỗi MU [Lưu trữ] - CLBGAMESVN MMORPG DEVELOPMENT

chuotyeulua

30-04-14, 10:18 AM

Như tiêu đề game đang online thì bị sự cố gì đó disconnect toàn bộ người đang chơi, vào lại thì click vào gameserver là bị dis
xem log nó ra thế này mà mình không hiểu gì
các pro giúp với

09:40:27 UPDATE Character SET cLevel=400,Class=16,LevelUpPoint=65000, Experience=-2804076, Strength=28, Dexterity=20, Vitality=25, Energy=10, Money=776398700, Life=9080, MaxLife=9080, Mana=2195, MaxMana=2195, MapNumber=3, MapPosX=179, MapPosY=102, MapDir=4, PkCount=0, PkLevel=3, PkTime=40955, DbVersion=3, Leadership=0, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'REDBULL'
09:40:27 UPDATE Character SET Inventory=? WHERE Name='REDBULL'
09:40:27 UPDATE Character SET MagicList=? WHERE Name='REDBULL'
09:40:27 UPDATE Character SET Quest=? WHERE Name='REDBULL'
09:40:28 EXEC WZ_GetItemSerial
09:40:28 EXEC WZ_GetItemSerial
09:40:29 EXEC WZ_GetItemSerial
09:40:31 UPDATE Character SET cLevel=400,Class=82,LevelUpPoint=4760, Experience=1990457396, Strength=1501, Dexterity=25021, Vitality=20018, Energy=14023, Money=646647243, Life=60408, MaxLife=11434, Mana=42720, MaxMana=26296, MapNumber=41, MapPosX=30, MapPosY=76, MapDir=1, PkCount=0, PkLevel=3, PkTime=40959, DbVersion=3, Leadership=0, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'NhokSiik'
09:40:31 [WzExDB] [ExDB][ExDB] member close: [NhokSiik]
09:40:31 UPDATE Character SET Inventory=? WHERE Name='NhokSiik'
09:40:31 EXEC WZ_DISCONNECT_MEMB 'zhuy113z'
09:40:31 UPDATE Character SET MagicList=? WHERE Name='NhokSiik'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] zhuy113z has been deleted
09:40:31 EXEC WZ_DISCONNECT_MEMB '090909'
09:40:31 UPDATE Character SET Quest=? WHERE Name='NhokSiik'
09:40:31 UPDATE Character SET cLevel=400,Class=65,LevelUpPoint=40, Experience=0, Strength=30026, Dexterity=12020, Vitality=17020, Energy=5015, Money=579202616, Life=60981, MaxLife=19205, Mana=40464, MaxMana=13854, MapNumber=3, MapPosX=155, MapPosY=115, MapDir=1, PkCount=0, PkLevel=3, PkTime=40959, DbVersion=3, Leadership=1025, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'TestDL'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] 090909 has been deleted
09:40:31 EXEC WZ_DISCONNECT_MEMB '13051990'
09:40:31 UPDATE Character SET Inventory=? WHERE Name='TestDL'
09:40:31 [WzExDB] [ExDB][ExDB] member close: [GameOver]
09:40:31 UPDATE Character SET MagicList=? WHERE Name='TestDL'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] 13051990 has been deleted

MUNew

30-04-14, 10:24 AM

Như tiêu đề game đang online thì bị sự cố gì đó disconnect toàn bộ người đang chơi, vào lại thì click vào gameserver là bị dis
xem log nó ra thế này mà mình không hiểu gì
các pro giúp với

09:40:27 UPDATE Character SET cLevel=400,Class=16,LevelUpPoint=65000, Experience=-2804076, Strength=28, Dexterity=20, Vitality=25, Energy=10, Money=776398700, Life=9080, MaxLife=9080, Mana=2195, MaxMana=2195, MapNumber=3, MapPosX=179, MapPosY=102, MapDir=4, PkCount=0, PkLevel=3, PkTime=40955, DbVersion=3, Leadership=0, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'REDBULL'
09:40:27 UPDATE Character SET Inventory=? WHERE Name='REDBULL'
09:40:27 UPDATE Character SET MagicList=? WHERE Name='REDBULL'
09:40:27 UPDATE Character SET Quest=? WHERE Name='REDBULL'
09:40:28 EXEC WZ_GetItemSerial
09:40:28 EXEC WZ_GetItemSerial
09:40:29 EXEC WZ_GetItemSerial
09:40:31 UPDATE Character SET cLevel=400,Class=82,LevelUpPoint=4760, Experience=1990457396, Strength=1501, Dexterity=25021, Vitality=20018, Energy=14023, Money=646647243, Life=60408, MaxLife=11434, Mana=42720, MaxMana=26296, MapNumber=41, MapPosX=30, MapPosY=76, MapDir=1, PkCount=0, PkLevel=3, PkTime=40959, DbVersion=3, Leadership=0, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'NhokSiik'
09:40:31 [WzExDB] [ExDB][ExDB] member close: [NhokSiik]
09:40:31 UPDATE Character SET Inventory=? WHERE Name='NhokSiik'
09:40:31 EXEC WZ_DISCONNECT_MEMB 'zhuy113z'
09:40:31 UPDATE Character SET MagicList=? WHERE Name='NhokSiik'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] zhuy113z has been deleted
09:40:31 EXEC WZ_DISCONNECT_MEMB '090909'
09:40:31 UPDATE Character SET Quest=? WHERE Name='NhokSiik'
09:40:31 UPDATE Character SET cLevel=400,Class=65,LevelUpPoint=40, Experience=0, Strength=30026, Dexterity=12020, Vitality=17020, Energy=5015, Money=579202616, Life=60981, MaxLife=19205, Mana=40464, MaxMana=13854, MapNumber=3, MapPosX=155, MapPosY=115, MapDir=1, PkCount=0, PkLevel=3, PkTime=40959, DbVersion=3, Leadership=1025, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'TestDL'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] 090909 has been deleted
09:40:31 EXEC WZ_DISCONNECT_MEMB '13051990'
09:40:31 UPDATE Character SET Inventory=? WHERE Name='TestDL'
09:40:31 [WzExDB] [ExDB][ExDB] member close: [GameOver]
09:40:31 UPDATE Character SET MagicList=? WHERE Name='TestDL'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'master.dbo.XP_MD5_EncodeKeyVal'.
SQLSTATE:01000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
[Player] 13051990 has been deleted

khởi động lại server xem sao cả SQL luôn

chuotyeulua

30-04-14, 10:32 AM

khởi động lại server xem sao cả SQL luôn

khởi động lại thì online bình thường
nhưng lâu lâu nó lại bị thế, mình không thể canh chờ khởi động lại miết, với mem bị dis quá nhiều như vậy sẽ nghỉ hết

anhlocvk

30-04-14, 11:20 AM

bạn lên thay bd . khác đi mmmmmmmmmmmmmmmmmmmmmmmm hoặc để lại yahoo .: mình xem qua team cho

lequangvu

30-04-14, 12:43 PM

Kiểm tra lại MD5 của DB nhé bạn

chuotyeulua

01-05-14, 01:05 PM

Kiểm tra lại MD5 của DB nhé bạn

là kiểm tra thế nào bạn, mình dùng sv không md5, db cũng không md5
ai giúp với

anhemtb113

01-05-14, 01:16 PM

làm mu online với tui nè bác chả bị lỗi rỳ đâu :) cái chính là bác pm yahoo nico_di_oto_115 chiến bản khác =))

chuotyeulua

01-05-14, 01:23 PM

làm mu online với tui nè bác chả bị lỗi rỳ đâu :) cái chính là bác pm yahoo nico_di_oto_115 chiến bản khác =))

cảm ơn bạn, bạn biết fix lỗi này chỉ mình giùm với, mình cũng làm mu tàm tạm rồi, nhưng bị cái này lạ chưa gặp bao giờ

anhemtb113

01-05-14, 01:26 PM

check port .... chỉnh titancs.....xem có trung các kiểu con đà điểu k đc thì pm yahoo mình teamview giúp=D>=D>=D>=D>=D>

chuotyeulua

01-05-14, 01:51 PM

up up up up up up up up up pro giúp với