ps_game crash after char select

03/29/2016 18:39 AwakenGiant#1
hello elitepvpers, I don `t know what to do, so I am write here,i use ep5.4 server files with item mall fix, everything works fine but i got DC after char select and PS_game going off.
Quote:
2016-03-29 18:24:56 PS_GAME__system log start (Game01) [GERMANY]


2016-03-29 18:25:02 connect mgr 1252

2016-03-29 18:25:02 Server Version : 11093000

2016-03-29 18:25:02 connect dbagent 1260

2016-03-29 18:25:02 connect gamelog 1256

2016-03-29 18:25:03 Market End -----------------------

2016-03-29 18:25:04 Start CWorldSendThread=3928

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08





================================================== ==============

2016-03-29 18:26:57 Exception !!!, code=0xE06D7363, address=0x765D5B68

Minidump write end.....................

0x765D5B68 KERNELBASE.dll: RaiseException + 72

0x5D0C519B ItemMallFix.dll: Start + 9243

0x5D0C3F3E ItemMallFix.dll: Start + 4542

0x5D0C3E41 ItemMallFix.dll: Start + 4289

0x5D0C1DA7 ItemMallFix.dll: <unknown symbol>

0x5D0C1F9E ItemMallFix.dll: <unknown symbol>

0x5D0C2E91 ItemMallFix.dll: Start + 273

0x5D0C2DA5 ItemMallFix.dll: Start + 37

0x00405B9B ps_game.exe: <unknown symbol>

0x004ECF40 ps_game.exe: <unknown symbol>

0x004035C3 ps_game.exe: <unknown symbol>

0x004E942D ps_game.exe: <unknown symbol>

0x004E9211 ps_game.exe: <unknown symbol>

0x0051D003 ps_game.exe: <unknown symbol>

0x0051D09F ps_game.exe: <unknown symbol>

0x76497C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x7736AB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x7736AB5A ntdll.dll: RtlInitializeExceptionChain + 90

Stack trace end.....................



Stack trace(all thread) begin.....................



Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08

Error: Attempts to access 'ps_game.exe' failed: 0x0 - The operation completed successfully.

************* Symbol Path validation summary **************
Response Time (ms) Location
Error ps_game.exe
Error: Attempts to access 'ps_game.pdb' failed: 0x2 - Can not find the file specified.

************* Symbol Path validation summary **************
Response Time (ms) Location
Error ps_game.pdb

Microsoft (R) Windows Debugger Version 6.3.9600.17788 X86
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [C:\ShaiyaServer\PSM_Client\bin\Log\20160329_182456 _ps_game.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available

Error: Attempts to access 'ps_game.exe' failed: 0x0 - The operation completed successfully.

************* Symbol Path validation summary **************
Response Time (ms) Location
Error ps_game.exe
Error: Attempts to access 'ps_game.pdb' failed: 0x2 - Can not find the file specified.

************* Symbol Path validation summary **************
Response Time (ms) Location
Error ps_game.pdb
Symbol search path is: ps_game.pdb
Executable search path is: ps_game.exe
Windows 8 Version 9600 MP (2 procs) Free x86 compatible
Product: WinNt, suite: SingleUserTS Personal
Built by: 6.3.9600.18217 (winblue_ltsb.160124-0053)
Machine Name:
03/29/2016 19:57 {Skrillex}#2
post some other logs like db_agent
03/30/2016 07:12 AwakenGiant#3
Quote:
Originally Posted by .:Skrillex:. View Post
post some other logs like db_agent
2016-03-29 18:24:53 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2016-03-29 18:25:02 ### Connect[4772] : Game[?][0x00D9BC88], Addr=127.0.0.1, DBJobEnd=1

2016-03-29 18:25:02 ### DB_SYSTEM_CONNECT[2852] :Game[1][0x00D9BC88], Name=Game01, Addr=127.0.0.1

2016-03-29 18:25:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-29 18:25:02 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2016-03-29 18:25:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-29 18:25:02 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2016-03-29 18:25:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2016-03-29 18:25:02 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2016-03-29 18:27:01 1 1 SAgent::Disconnect: (4, 64)

2016-03-29 18:27:01 1 1 T=000:01:00:000, RC=9,RCS=0, RB=254,RBS=2, SC=20,SCS=0, SB=5743,SBS=48

2016-03-29 18:27:01 ### Disconnect[448] : Game[1][0x00D9BC88], Name=Game01, Addr=127.0.0.1, DBJobEnd=0

2016-03-29 18:27:01 ### PostDispatchDB[448] : DB_DISPATCHER_EXIT Game[1][0x00D9BC88]

2016-03-29 18:27:01 ### OnDispatchDB[3432] : => DB_DISPATCHER_EXIT Game[1][0x00D9BC88]

2016-03-29 18:27:01 ### Save[3432] : Game[1][0x00D9BC88]

2016-03-29 18:27:01 ### OnDispatchDB[3432] : <= DB_DISPATCHER_EXIT Game[1][0x00D9BC88]

2016-03-29 18:28:05 3 1 SERVICE_CONTROL_STOP

2016-03-29 18:28:05 PS_DBAGENT__system log end (DBAgent01)


2016-03-29 18:28:05 3 1 SService::ServiceCtrlDispatcher(): service shutdown
03/30/2016 12:17 Garrett_Thief#4
Check you GuildDetails table and procedure Read_Guild2_R because you logs say miss column Rank in table GuildDetails:

Code:
2016-03-29 18:25:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name "Rank"., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)
From my server table GuildDetails:

From my server procedure Read_Guild2_R: