Gunz 1.5 MatchServer/Database problem.

Results 1 to 1 of 1
  1. #1
    Gunz League owner Hakurah is offline
    MemberRank
    Dec 2006 Join Date
    Rio de JaneiroLocation
    602Posts

    Gunz 1.5 MatchServer/Database problem.

    I'm almost throwing this computer out the window by now. I've tried everything I could find here and everything I knew. This is the issue:

    Code:
    Load XML from memory : strings.xml(0x0037) - SUCCESSLoad XML from memory : cserror.xml(0x0037) - SUCCESS
    [08/31/12 21:57:20] DBMS connected
    
    
    
    
    [08/31/12 21:57:20]  MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL spUpdateServerInfo (1000, 'TheDuelZ', 1)} ), ErrCode( -1 )
    ErrMsg - Could not find stored procedure 'spUpdateServerInfo'.
    State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
    
    
    [08/31/12 21:57:20] Command registeration completed
    
    
    
    
    [08/31/12 21:57:20]  MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL spGetGambleItemList} ), ErrCode( -1 )
    ErrMsg - Could not find stored procedure 'spGetGambleItemList'.
    State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
    
    
    init gamble machine fail.
    
    
    [08/31/12 21:57:21]  MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL spGetSurvivalGroupRanking} ), ErrCode( -1 )
    ErrMsg - Could not find stored procedure 'spGetSurvivalGroupRanking'.
    State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
    "You're using the wrong DB. Get Emisand's DB."
    No, I'm not. I'm using his DB already.

    "Try using the .bak and restore your DB to the original file."
    Done. Twice. With a 2005 build and the original 2008 one.

    "Check the username and password at server.ini"
    Checked and correct.

    "Is the ODBC set up correctly?"
    I think so... I followed this tutorial: http://forum.ragezone.com/f497/1-5-s...7/#post7106327

    Now, another guy in one of the threads I searched for had the same problem and he managed to fix it. He said the problem was with permissions, that the MatchServer was not able to get to the procedure. So I went on "Properties" at the DB, Procedure and server, checked my own user and "public" and changed the Permissions to "Grant". It didn't change anything, in fact, after I did this the MatchServer crashed faster, God knows why.

    Then I just restored again from another file someone out here made for a kid, a 2005 build of Emisand's DB. I did that because it worked for this guy. But it didn't for me.

    Should I just delete SQL 2012 and get 2005? I really hope there's another way around it because it takes forever to reinstall this bitch.

    Thanks in advance.

    EDIT: Oh, God damn it. It's the tutorial's fault. After filling out username and password for the SQL connection, you're supposed to change the DB in the first field to GunzDB and not leave it at "master". My MServer is running. I kept changing files and stuff for nothing. Ugh. You can close this now, mod.
    Last edited by Hakurah; 01-09-12 at 03:16 AM.




Advertisement