My server ran good for the last few days. Now, i get a problem which game can't connect to Database or something. This is a picture tell me what happen after i clicked Start All Sever Service
can anyone tell me why?
thank you so much for read it.
![]()
My server ran good for the last few days. Now, i get a problem which game can't connect to Database or something. This is a picture tell me what happen after i clicked Start All Sever Service
can anyone tell me why?
thank you so much for read it.
![]()
see PSM_Client\Bin\Log\*.log
i got this:
2010-07-21 04:17:21 PS_USERLOG__system log start (UserLog)
2010-07-21 04:17:21 connect
2010-07-21 04:17:26 connect
2010-07-21 04:19:05 3 1 SERVICE_CONTROL_STOP
2010-07-21 04:19:05 1 1 SAgent::Disconnect: (4, 64)
2010-07-21 04:19:05 1 1 T=000:01:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0
2010-07-21 04:19:05 disconnect
2010-07-21 04:19:06 1 1 SAgent::Disconnect: (4, 64)
2010-07-21 04:19:06 1 1 T=000:01:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0
2010-07-21 04:19:06 disconnect
2010-07-21 04:19:07 PS_USERLOG__system log end (UserLog)
2010-07-21 04:19:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Last edited by matran; 21-07-10 at 10:21 AM.
oh
see all logs
PS_DBAGENT_
PS_GAME__
PS_GAMELOG_
PS_LOGIN__
PS_SESSION__
2010-07-21 04:29:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'ItemID4'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)
2010-07-21 04:29:39 CGameData::LoadProductList Failed, qerr=-1, EXEC usp_Read_ProductList
2010-07-21 04:29:39 DB table load error
2010-07-21 04:29:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2010-07-21 04:29:39 Call save all waiting...
2010-07-21 04:29:39 Call save all failed dbagent disconnected(user count = 0)...
2010-07-21 04:29:39 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0
2010-07-21 04:29:39 Save Shaiya.SData 0
2010-07-21 04:29:39 PS_GAME__system log end (AnhEmTa)
2010-07-21 04:29:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
I know what's wrong now..thank you so much Twilight[COLOR="Silver"]
Last edited by matran; 21-07-10 at 10:45 AM.