Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Error when trying to register an account.

Junior Spellweaver
Joined
Aug 24, 2006
Messages
105
Reaction score
0
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
 
Newbie Spellweaver
Joined
Nov 26, 2007
Messages
9
Reaction score
0
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
 
Upvote 0
Junior Spellweaver
Joined
Aug 24, 2006
Messages
105
Reaction score
0
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.
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
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.
 
Upvote 0
Game Developer
Joined
Oct 1, 2005
Messages
420
Reaction score
47
u tryed to check "cabal_auth_table" some times give error but it create account normally(its not an error its like a warning)
 
Upvote 0
Game Developer
Joined
Oct 1, 2005
Messages
420
Reaction score
47
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 Ducking char in your local server(by the way hes not have much time to level or dont know how to play kkk)
 
Upvote 0
Back
Top