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 ??
1 Attachment(s)
Re: DB and Log error help pls..
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:
Re: DB and Log error help pls..
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
Re: DB and Log error help pls..
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
Re: DB and Log error help pls..
Quote:
Originally Posted by
ProAim
check ur serverstatus.dbo
Please don't post irrelevant things. ServerStatus.dbo is no where related to this problem.
Re: DB and Log error help pls..
pufff
:S i am done. i am so tired and bored
Re: DB and Log error help pls..
Anybody dont know this error how to fix ????
Re: DB and Log error help pls..
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.
Re: DB and Log error help pls..
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 ?
Re: DB and Log error help pls..
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.
Re: DB and Log error help pls..
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/