DB and Log error help pls..

[includee666]

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
[09/18/10 01:43:43] DBMS connected
[09/18/10 01:43:43] Command registeration completed
Inited client file list (1)
success init security.
FILE PATH : E:\oyun\Gunz\server\working server\Gunz ServerFiles Rev 5\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/18/10 01:43:43] Release Date : Jun 13 2007
[09/18/10 01:43:43] X-Trap Off
[09/18/10 01:43:43] MD5 Check Off
[09/18/10 01:43:43] Server Country : BRAZIL
[09/18/10 01:43:43] Command version : (56)
[09/18/10 01:43:43] Event usable state : (false)
[09/18/10 01:43:43] Load event size : (0)
[09/18/10 01:43:43] FileCRCCheckSum usable state : (false)
[09/18/10 01:43:43] FileCRC size : (1)
[09/18/10 01:43:43] Country Code Filter usalbe state : (false)
[09/18/10 01:43:43] Accept Invalied IP state : (true)
[09/18/10 01:43:43] Keeper IP : (127.0.0.1)
[09/18/10 01:43:43] Monitor IP : (127.0.0.1)
===========================================================================================

[09/18/10 01:43:43] Match Server Created (Port:6000)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'dbo.ConnLog'.

MMatchDBMgr::CreateCharacter - Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnCheckString", or the name is ambiguous.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.

RealCPNet> SessionCreated=3, SessionDestroyed=2

Ok i cant create character nomsg e-1 error and

i check db repair but now log give me this error

pls someone tell me how can i fix this db problem ??

 

[Phoenix]

Your database is way too messed up. Download the SQL file I've attached below and create a new database with it. Delete your GunzDB > Go to New Query > Execute the attached script. A new GunzDB will automatically be created and it's a 2007 + 2008 compatible one. Use this and you won't have problems.

Download:

 

[includee666]

Thank bro i hope my all problem fix :S ill try now and post here

---------- Post added at 09:08 PM ---------- Previous post was at 08:58 PM ----------

pufff :S bro

this DB i have and i already try this you attached DB to give error

cannot accest server :S

another DB can enter account but can create char :S

 

[ProAim]

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
[09/18/10 01:43:43] DBMS connected
[09/18/10 01:43:43] Command registeration completed
Inited client file list (1)
success init security.
FILE PATH : E:\oyun\Gunz\server\working server\Gunz ServerFiles Rev 5\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/18/10 01:43:43] Release Date : Jun 13 2007
[09/18/10 01:43:43] X-Trap Off
[09/18/10 01:43:43] MD5 Check Off
[09/18/10 01:43:43] Server Country : BRAZIL
[09/18/10 01:43:43] Command version : (56)
[09/18/10 01:43:43] Event usable state : (false)
[09/18/10 01:43:43] Load event size : (0)
[09/18/10 01:43:43] FileCRCCheckSum usable state : (false)
[09/18/10 01:43:43] FileCRC size : (1)
[09/18/10 01:43:43] Country Code Filter usalbe state : (false)
[09/18/10 01:43:43] Accept Invalied IP state : (true)
[09/18/10 01:43:43] Keeper IP : (127.0.0.1)
[09/18/10 01:43:43] Monitor IP : (127.0.0.1)
===========================================================================================

[09/18/10 01:43:43] Match Server Created (Port:6000)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'dbo.ConnLog'.

MMatchDBMgr::CreateCharacter - Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnCheckString", or the name is ambiguous.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.

RealCPNet> SessionCreated=3, SessionDestroyed=2

Ok i cant create character nomsg e-1 error and

i check db repair but now log give me this error

pls someone tell me how can i fix this db problem ??

check ur serverstatus.dbo

 

[Phoenix]

check ur serverstatus.dbo

Please don't post irrelevant things. ServerStatus.dbo is no where related to this problem.

 

[includee666]

pufff

:S i am done. i am so tired and bored

 

[includee666]

Anybody dont know this error how to fix ????

 

[Phoenix]

Anybody dont know this error how to fix ????

I already asked you to use a new database and I even posted it. Just delete your whole GunzDB and execute the script I posted.

 

[includee666]

I already asked you to use a new database and I even posted it. Just delete your whole GunzDB and execute the script I posted.

And i said i already do that bro.

if i use your DB i cant login with user name give me error

"cannot accest server" dont tell me pls check your DB becouse everything done nothing wrong

but if i use my DB its ok can enter but another error cant create character nomsg.

understand ?

 

[Phoenix]

Use a proper runnable like Xiao's or GUNZ2830's and use my DB, configure your server configuration files and ServerStatus.dbo. It has to work. If it doesn't, you're doing it wrong.

 

[00niels00]

About the database error that complains about the conlog. I made a fix for this. You can read it over here http://forum.ragezone.com/f497/tut-connlog-fix-matchserver-670285/