System Error Caused Login Fail

Results 1 to 7 of 7
  1. #1
    Enthusiast apple1ye is offline
    MemberRank
    Mar 2013 Join Date
    35Posts

    System Error Caused Login Fail

    Server Log:
    Session Server
    Service Provider:CHINA
    CreateIoCompletionPort OK
    INFO:SQL_ATTR_CONNECTION_POOLING OK
    INFO:SQLAllocHandle OK
    Database Thread Create OK
    --------------- System Information -------------------
    Unknown OS
    Pentium III processor 2199 Mhz
    8 System Processor Detected
    ------------------------------------------------------
    6 Worker Thread
    1 st Worker Thread Create OK
    2 st Worker Thread Create OK
    3 st Worker Thread Create OK
    4 st Worker Thread Create OK
    5 st Worker Thread Create OK
    6 st Worker Thread Create OK
    Server Update Thread Create OK
    WSASocket OK
    Bind OK
    127.0.0.1:5113
    Server Accept Thread Create OK
    =======================================================
    Server Start OK
    =======================================================
    (Client ID:100) (127.0.0.1:60312)
    INFO:SetSvrInfo 127.0.0.1 5001 0 0 1
    INFO:SetSvrInfo 127.0.0.1 5001 0 0 1
    (Client ID:101) (127.0.0.1:60320)
    INFO:SetSvrInfo 127.0.0.1 5003 0 100 3
    INFO:SetSvrInfo 127.0.0.1 5003 0 100 3
    INFO:SetSvrInfo 127.0.0.1 5003 0 100 3
    (Client ID:102) (127.0.0.1:60330)
    INFO:SetSvrInfo 127.0.0.1 5502 500 0 4
    MsgSndCurSvrInfo 127.0.0.1
    MsgSndCurSvrInfo 127.0.0.1
    INFO:SetSvrInfo 127.0.0.1 5502 500 0 4
    MsgSndCurSvrInfo 127.0.0.1
    MsgSndCurSvrInfo 127.0.0.1
    DB:{call log_serverstate(0,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(0,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    DB:{call log_serverstate(1,500,0,0)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'log_serverstate'.
    Login Server:
    Service Provider:CHINA
    CreateIoCompletionPort OK
    --------------- System Information -------------------
    Unknown OS
    Pentium III processor 2199 Mhz
    8 System Processor Detected
    ------------------------------------------------------
    6 Worker Thread
    1 st Worker Thread Create OK
    2 st Worker Thread Create OK
    3 st Worker Thread Create OK
    4 st Worker Thread Create OK
    5 st Worker Thread Create OK
    6 st Worker Thread Create OK
    Server Update Thread Create OK
    WSASocket OK
    Bind OK
    127.0.0.1:5001
    Server Accept Thread Create OK
    (Client ID:99) (127.0.0.1:5113)
    ============================
    Session Server Connection OK
    ============================
    =======================================================
    Server Start OK
    =======================================================
    (Client ID:100) (127.0.0.1:60337)
    (Client ID:101) (127.0.0.1:60354)
    Field Server :
    Service Provider:CHINA
    CreateIoCompletionPort OK
    INFO:SQL_ATTR_CONNECTION_POOLING OK
    INFO:SQLAllocHandle OK
    User DB Open OK
    Game DB Open OK
    Log DB Open OK
    Shop DB Open OK
    Database Thread Create OK
    Log Database Thread Create OK
    User Database Thread Create OK
    --------------- System Information -------------------
    Unknown OS
    Pentium III processor 2199 Mhz
    8 System Processor Detected
    ------------------------------------------------------
    6 Worker Thread
    1 st Worker Thread Create OK
    2 st Worker Thread Create OK
    3 st Worker Thread Create OK
    4 st Worker Thread Create OK
    5 st Worker Thread Create OK
    6 st Worker Thread Create OK
    nProtect GameGuard server DLL load failed
    [Gaea Server] Start
    PK MODE : 1
    DB:SELECT MaxNum, NIDMain, NIDSub, MakeType FROM LogItemMax WITH (NOLOCK) WHERE SGNum=0 AND SvrNum=0 AND FldNum=0
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'LogItemMax'.
    [Add Map] w_ep3_saintB_1F.Lev / [46/0]
    [Add Map] w_club_c_out.Lev / [204/0]
    [Add Map] w_school_01_in_31.Lev / [107/0]
    [Add Map] w_school_01_in_22.Lev / [106/0]
    [Add Map] w_ep3_saintB_boss2.Lev / [41/0]
    [Add Map] w_school_01_in_17.Lev / [105/0]
    [Add Map] w_club_s_out.Lev / [201/0]
    [Add Map] w_ep3_saintB_boss1.Lev / [40/0]
    [Add Map] w_school_01_in_14_2.Lev / [104/0]
    [Add Map] w_school_01_in_14.Lev / [103/0]
    [Add Map] w_school_01_trash.Lev / [102/0]
    [Add Map] w_blue_in_3F.Lev / [21/0]
    [Add Map] w_school_01_in_08_2.Lev / [101/0]
    [Add Map] w_blue_in_2F.Lev / [20/0]
    [Add Map] w_ep3_saintB_52F.Lev / [52/0]
    [Add Map] w_school_01_in_08.Lev / [100/0]
    [Add Map] w_blue_in_1F.Lev / [19/0]
    [Add Map] w_ep3_saintB_51F.Lev / [51/0]
    [Add Map] w_club_s_in.Lev / [211/0]
    [Add Map] w_school_01.Lev / [2/0]
    [Add Map] ev_underpark2.Lev / [162/0]
    [Add Map] ev_underpark.Lev / [161/0]
    [Add Map] innerzone_01.lev / [0/0]
    [Add Map] w_Prison_01.Lev / [27/0]
    [Add Map] W_Tunnel_3.Lev / [26/0]
    [Add Map] W_Tunnel_4.Lev / [250/0]
    [Add Map] w_tradezone1.Lev / [22/0]
    [Add Map] w_club_c_in.Lev / [214/0]
    DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'viewGuildInfo'.
    DB:SELECT RegionID, GuNum, RegionTax FROM GuildRegion WITH (NOLOCK) ORDER BY RegionID
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'GuildRegion'.
    [Gaea Server] Start Succeeded
    [Gaea Server] ---------------
    Server Update Thread Create OK
    WSASocket OK
    Bind OK
    127.0.0.1:5003
    Server Accept Thread Create OK
    ============================
    Session Server Connection OK
    ============================
    INFO:SessionSndSvrInfo 127.0.0.1
    INFO:SessionSndSvrInfo 127.0.0.1
    NET_MSG_BASE 987
    =======================================================
    Server Start OK
    =======================================================
    INFO:SessionSndSvrInfo 127.0.0.1
    Agent Server:
    Service Provider:CHINA
    INFO:nProtect GameGuard server DLL load failed
    CreateIoCompletionPort OK
    INFO:SQL_ATTR_CONNECTION_POOLING OK
    INFO:SQLAllocHandle OK
    User DB Open OK
    Game DB Open OK
    Log DB Open OK
    Shop DB Open OK
    Database Thread Create OK
    Log Database Thread Create OK
    User Database Thread Create OK
    Web Database Thread Create OK
    --------------- System Information -------------------
    Unknown OS
    Pentium III processor 2199 Mhz
    8 System Processor Detected
    ------------------------------------------------------
    6 Worker Thread
    1 st Worker Thread Create OK
    2 st Worker Thread Create OK
    3 st Worker Thread Create OK
    4 st Worker Thread Create OK
    5 st Worker Thread Create OK
    6 st Worker Thread Create OK
    [Gaea Server] Start
    PK MODE : 1
    DB:SELECT MaxNum, NIDMain, NIDSub, MakeType FROM LogItemMax WITH (NOLOCK) WHERE SGNum=0 AND SvrNum=0 AND FldNum=-1
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'LogItemMax'.
    DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'viewGuildInfo'.
    DB:SELECT RegionID, GuNum, RegionTax FROM GuildRegion WITH (NOLOCK) ORDER BY RegionID
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'GuildRegion'.
    [Gaea Server] Start Succeeded
    [Gaea Server] ---------------
    Server Update Thread Create OK
    WSASocket OK
    Bind OK
    127.0.0.1:5502
    Server Accept Thread Create OK
    (Client ID:99) (127.0.0.1:5113)
    ============================
    Session Server Connection OK
    ============================
    SessionSndSvrInfo 127.0.0.1 CH:1
    (Client ID:0) (127.0.0.1:5003)
    INFO:Field Server CH(0) FIELD(0) ID(0) Connection OK
    NET_MSG_BASE 987
    =======================================================
    Server Start OK
    =======================================================
    DB:UPDATE UserInfo WITH (UPDLOCK) SET UserLoginState=0 WHERE UserLoginState=1 AND SGNum=0
    DB:42S02, NativeError:208, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'UserInfo'.
    (Client ID:100) (127.0.0.1:60363)
    DB:{call user_verify('admin2','D4E0D3994DCFAA89FFE','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1
    DB:{call user_verify('admin2','E10ADC3949BA59ABBE5','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1
    DB:{call user_verify('admin1','E10ADC3949BA59ABBE5','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1
    DB:{call user_verify('admin1','C44FA380A687E598318','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1
    DB:{call user_verify('admin2','E10ADC3949BA59ABBE5','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1
    DB:{call user_verify('admin2','E10ADC3949BA59ABBE5','127.0.0.1',0,0,'','12',?)}
    DB:42000, NativeError:2812, [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'user_verify'.
    CAgentUserCheck result -1


  2. #2
    c++ CNDev is offline
    MemberRank
    Oct 2010 Join Date
    1,681Posts

    Re: System Error Caused Login Fail

    what episode is this?

  3. #3
    Enthusiast apple1ye is offline
    MemberRank
    Mar 2013 Join Date
    35Posts

    Re: System Error Caused Login Fail

    Quote Originally Posted by nieen12 View Post
    what episode is this?
    episode 7

  4. #4
  5. #5
    Enthusiast apple1ye is offline
    MemberRank
    Mar 2013 Join Date
    35Posts

    Re: System Error Caused Login Fail

    Service Provider:CHINA
    INFO:nProtect GameGuard server DLL load failed
    CreateIoCompletionPort OK
    INFO:SQL_ATTR_CONNECTION_POOLING OK
    INFO:SQLAllocHandle OK
    User DB Open OK
    Game DB Open OK
    Log DB Open OK
    Shop DB Open OK
    Database Thread Create OK
    Log Database Thread Create OK
    User Database Thread Create OK
    Web Database Thread Create OK
    --------------- System Information -------------------
    Unknown OS
    Pentium III processor 2199 Mhz
    8 System Processor Detected
    ------------------------------------------------------
    6 Worker Thread
    1 st Worker Thread Create OK
    2 st Worker Thread Create OK
    3 st Worker Thread Create OK
    4 st Worker Thread Create OK
    5 st Worker Thread Create OK
    6 st Worker Thread Create OK
    [Gaea Server] Start
    PK MODE : 1
    DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
    DB:42S22, NativeError:207, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'GuAuthorityTime'.
    [Gaea Server] Start Succeeded
    [Gaea Server] ---------------
    Server Update Thread Create OK
    WSASocket OK
    Bind OK
    127.0.0.1:5502
    Server Accept Thread Create OK
    (Client ID:99) (127.0.0.1:5113)
    ============================
    Session Server Connection OK
    ============================
    SessionSndSvrInfo 127.0.0.1 CH:1
    (Client ID:0) (127.0.0.1:5003)
    INFO:Field Server CH(0) FIELD(0) ID(0) Connection OK
    NET_MSG_BASE 987
    =======================================================
    Server Start OK
    =======================================================.

    DB:42S22, NativeError:207, [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'GuAuthorityTime'.


    This Error I try to create new column but it still error
    thx

  6. #6
    c++ CNDev is offline
    MemberRank
    Oct 2010 Join Date
    1,681Posts

    Re: System Error Caused Login Fail

    i would like to suggest try the database of ramispo.

  7. #7
    Apprentice ferry2512 is offline
    MemberRank
    Sep 2013 Join Date
    IndonesiaLocation
    5Posts

    Re: System Error Caused Login Fail

    Quote Originally Posted by Stack Overflow View Post
    i would like to suggest try the database of ramispo.
    could you give me the link to download the database of ramispo?
    thank's...



Advertisement