ps_game crash after char select

[AwakenGiant]

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.

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:

[{Skrillex}]

post some other logs like db_agent

[AwakenGiant]

Originally Posted by .:Skrillex:.

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:isconnect: (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

[Garrett_Thief]

Check you GuildDetails table and procedure Read_Guild2_R because you logs say miss column Rank in table GuildDetails:

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:

 Spoiler

USE [PS_GameData]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildDetails_KeepEtin]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildDetails_EtinReturnCnt]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildHouses_Etine]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildHouses_Rank]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildDetails_BuyHouse]
GO

ALTER TABLE [dbo].[GuildDetails] DROP CONSTRAINT [DF_GuildHouses_UseHouse]
GO

/****** Object:  Table [dbo].[GuildDetails]    Script Date: 30.03.2016 13:12:07 ******/
DROP TABLE [dbo].[GuildDetails]
GO

/****** Object:  Table [dbo].[GuildDetails]    Script Date: 30.03.2016 13:12:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[GuildDetails](
	[GuildID] [int] NOT NULL,
	[UseHouse] [tinyint] NOT NULL,
	[BuyHouse] [tinyint] NOT NULL,
	[Rank] [tinyint] NOT NULL,
	[Etin] [int] NOT NULL,
	[EtinReturnCnt] [int] NOT NULL,
	[KeepEtin] [int] NOT NULL,
	[Remark] [varchar](64) NULL,
 CONSTRAINT [PK_GuildHouses] PRIMARY KEY CLUSTERED 
(
	[GuildID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildHouses_UseHouse]  DEFAULT ((0)) FOR [UseHouse]
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildDetails_BuyHouse]  DEFAULT ((0)) FOR [BuyHouse]
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildHouses_Rank]  DEFAULT ((31)) FOR [Rank]
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildHouses_Etine]  DEFAULT ((0)) FOR [Etin]
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildDetails_EtinReturnCnt]  DEFAULT ((0)) FOR [EtinReturnCnt]
GO

ALTER TABLE [dbo].[GuildDetails] ADD  CONSTRAINT [DF_GuildDetails_KeepEtin]  DEFAULT ((2000)) FOR [KeepEtin]
GO

From my server procedure Read_Guild2_R:

 Spoiler

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Read_Guild2_R]    Script Date: 30.03.2016 13:11:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Proc [dbo].[usp_Read_Guild2_R]

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint, 
ISNULL(H.Rank,31) Rank, ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 )  EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY H.Rank DESC

SET NOCOUNT OFF