DB and Log error help pls..

Code:

---

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 ??

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:

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

Quote:

---

Originally Posted by includee666

Code:

---

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

Quote:

---

Originally Posted by ProAim

check ur serverstatus.dbo

---

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

pufff

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

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

Quote:

---

Originally Posted by includee666

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.

Quote:

---

Originally Posted by phoenix_147

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 ?

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.

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-c...server-670285/