[July] Server character creation error -> nomsg(-1)

[endar]

Whenever I create a character it gives me an error that says nomsg(-1), I am using the july server and client. Could someone tell me what is wrong?

[MentaL]

[Rotana]

can you post the log file of the server? i think you miss an stored procedure.

[endar]

I think I am using the old LG database although I am not sure because I get the E-1 error on most other databases as well.

nhn server mode is real
Error!! - StringTable Initalize Failed
[09/20/08 10:03:38] DBMS connected
[09/20/08 10:03:41] InitCountryFilterDB.

[09/20/08 10:03:41] Command registeration completed
success init security.
FILE PATH : C:\Documents and Settings\Snail\Desktop\MatchServer\MD5HashValue.txt
MD5 Hash Value => 6e ff 40 c1 22 1e 4b 2b 33 ce 22 41 7d c4 3a 3d 

================================== Server configure info ==================================
[09/20/08 10:03:41] Release Date : Jun 13 2007
[09/20/08 10:03:41] X-Trap Off
[09/20/08 10:03:41] MD5 Check Off
[09/20/08 10:03:41] Server Country : US
[09/20/08 10:03:41] Command version : (56)
[09/20/08 10:03:41] Event usable state : (false)
[09/20/08 10:03:41] Load event size : (0)
[09/20/08 10:03:41] FileCRCCheckSum usable state : (false)
[09/20/08 10:03:41] FileCRC size : (0)
[09/20/08 10:03:41] Country Code Filter usalbe state : (true)
[09/20/08 10:03:41] Accept Invalied IP state : (false)
[09/20/08 10:03:41] Keeper IP : (127.0.0.1)
[09/20/08 10:03:41] Monitor IP : (127.0.0.1)
===========================================================================================

[09/20/08 10:03:41] Match Server Created (Port:6000)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.dbo.ConnLog'.

MMatchDBMgr::CreateCharacter - Could not find stored procedure 'spCheckDuplicateCharName'.

MMatchDBMgr::UpdateAccountLastLoginTime - Could not find stored procedure 'spUpdateAccountLastLogoutTime'.

[09/20/08 10:08:41] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
[09/20/08 10:13:41] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
RealCPNet> SessionCreated=2, SessionDestroyed=1

You were right, I am missing a stored procedure.

[endar]

Thanks for helping me, I found the SP in another database, here it is for everyone else.

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[spCheckDuplicateCharName]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
create proc [spCheckDuplicateCharName]   
 @Name varchar(24)  
as
 set nocount on  
 select top 1 cid from character(nolock) where deleteflag <> 1 and name = @Name  

' 
END
GO