Error when trying to register an account.

Results 1 to 9 of 9
  1. #1
    Proficient Member DarkAlien is offline
    MemberRank
    Aug 2006 Join Date
    175Posts

    Error when trying to register an account.

    Code:
    Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
    Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
    Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    
    (1 row(s) affected)
    please help X_X


  2. #2
    Apprentice jhaszthienn is offline
    MemberRank
    Nov 2007 Join Date
    14Posts

    Re: Error when trying to register an account.

    Quote Originally Posted by DarkAlien View Post
    Code:
    Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
    Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
    Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
    
    (1 row(s) affected)
    please help X_X
    try this

    exec dbo.cabal_tool_registerAccount 'test','123456'

    if that code doesn't work something wrong with your database

  3. #3
    Proficient Member DarkAlien is offline
    MemberRank
    Aug 2006 Join Date
    175Posts

    Re: Error when trying to register an account.

    Dude that's the same code as I did, just another username and password.
    It won't help, though I will try.
    BTW, I'm sure that something is wrong with my database, and that's what I'm asking for help in here.

    Edit:
    Same error happend.

  4. #4
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Error when trying to register an account.

    How can something be wrong with the database when it is the same dump eveybody else is using?

    The error is telling you that you can't insert NULLs, which means that the userid/pw you are entering into the stored procedure isn't getting through to the actual query it calls and is therefore being replaced with NULLs (nothing).

    What tinkering have you done in the DB? The stored procedure works for me without any messing about and i'm using the same DB everybody else is.

  5. #5
    Game Developer snaity is offline
    MemberRank
    Oct 2005 Join Date
    BrazilLocation
    946Posts

    Re: Error when trying to register an account.

    u tryed to check "cabal_auth_table" some times give error but it create account normally(its not an error its like a warning)

  6. #6
    Enthusiast Rexzam is offline
    MemberRank
    Jul 2008 Join Date
    38Posts

    Re: Error when trying to register an account.

    same problem here .. someone can help ?

  7. #7
    Account Upgraded | Title Enabled! `CcyClOnE` is offline
    MemberRank
    Jul 2008 Join Date
    USLocation
    270Posts

    Re: Error when trying to register an account.

    try creating the account manually. ^_^

  8. #8
    Enthusiast Rexzam is offline
    MemberRank
    Jul 2008 Join Date
    38Posts

    Re: Error when trying to register an account.

    sorry first time i make a server

    how exactly i make that?!?

  9. #9
    Game Developer snaity is offline
    MemberRank
    Oct 2005 Join Date
    BrazilLocation
    946Posts

    Re: Error when trying to register an account.

    Quote Originally Posted by Rexzam View Post
    sorry first time i make a server

    how exactly i make that?!?
    u first time? Only tip for u is forget about that, learn about sql(mssql,mysql or anyelse) first and TCP/IP(Using and configuring), learn how to read logs and trace for errors and find fixes. Its all.

    99% of people is just a player wanting to make a fucking char in your local server(by the way hes not have much time to level or dont know how to play kkk)



Advertisement