[Help] Server can't connect to database

Results 1 to 6 of 6
  1. #1
    Apprentice matran is offline
    MemberRank
    Jun 2010 Join Date
    19Posts

    sad [Help] Server can't connect to database

    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.



  2. #2
    DEV Twilight is offline
    MemberRank
    Dec 2004 Join Date
    RussiaLocation
    720Posts

    Re: [Help] Server can't connect to database

    see PSM_Client\Bin\Log\*.log

  3. #3
    Apprentice matran is offline
    MemberRank
    Jun 2010 Join Date
    19Posts

    Re: [Help] Server can't connect to database

    Quote Originally Posted by Twilight View Post
    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.

  4. #4
    DEV Twilight is offline
    MemberRank
    Dec 2004 Join Date
    RussiaLocation
    720Posts

    Re: [Help] Server can't connect to database

    oh
    see all logs
    PS_DBAGENT_
    PS_GAME__
    PS_GAMELOG_
    PS_LOGIN__
    PS_SESSION__

  5. #5
    Apprentice matran is offline
    MemberRank
    Jun 2010 Join Date
    19Posts

    Re: [Help] Server can't connect to database

    Quote Originally Posted by Twilight View Post
    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.

  6. #6
    Apprentice cmaxlobo is offline
    MemberRank
    Sep 2010 Join Date
    São Gonçalo,Location
    23Posts

    Re: [Help] Server can't connect to database

    Quote Originally Posted by matran View Post
    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"]
    Guys, help me!

    Im having the same problem.
    The big problem is that I am not able to fix it.
    Thx for any halp.



Advertisement