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!

What you've all been waiting for...

Status
Not open for further replies.
The Best DDoS Protected Servers
E

efusion

Newbie Spellweaver
Joined
Nov 7, 2011
Messages
12
Reaction score
0
What is the Problem here :eek:?

Log :

000002 2012-11-23 21:11:56 Launching the server.....
000003 2012-11-23 21:11:56 Local Time 23.11.2012 21:11:56
000004 2012-11-23 21:11:56 System Time(UTC) 23.11.2012 20:11:56
000005 2012-11-23 21:11:56 <SUCCESSED SCRIPTOR READ> DataServerInfo_AccountLog.txt
000006 2012-11-23 21:11:56 <I AM THE _AccountLog DB Server, SERVER_ID_DB_ACCOUNTLOG, WorldNo=0, ZoneNo=0>
000007 2012-11-23 21:11:56 Service start(no parameter)
000008 2012-11-23 21:11:56 <IOCP WORKTHREAD #0 RUNNING>
000009 2012-11-23 21:11:56 <IOCP WORKTHREAD #1 RUNNING>
000010 2012-11-23 21:11:56 <IOCP WORKTHREAD #2 RUNNING>
000011 2012-11-23 21:11:56 <IOCP WORKTHREAD #3 RUNNING>
000012 2012-11-23 21:11:56 <IOCP WORKTHREAD #4 RUNNING>
000013 2012-11-23 21:11:56 <IOCP WORKTHREAD #5 RUNNING>
000014 2012-11-23 21:11:56 <IOCP WORKTHREAD #6 RUNNING>
000015 2012-11-23 21:11:56 <IOCP WORKTHREAD #7 RUNNING>
000016 2012-11-23 21:11:56 <IOCP WORKTHREAD #8 RUNNING>
000017 2012-11-23 21:11:56 <IOCP WORKTHREAD #9 RUNNING>
000018 2012-11-23 21:11:56 <IOCP WORKTHREAD #10 RUNNING>
000019 2012-11-23 21:11:56 <IOCP WORKTHREAD #11 RUNNING>
000020 2012-11-23 21:11:56 <IOCP WORKTHREAD #12 RUNNING>
000021 2012-11-23 21:11:56 <IOCP WORKTHREAD #13 RUNNING>
000022 2012-11-23 21:11:56 <IOCP WORKTHREAD #14 RUNNING>
000023 2012-11-23 21:11:56 <IOCP WORKTHREAD #15 RUNNING>
000024 2012-11-23 21:11:57 <IOCP WORKTHREAD #16 RUNNING>
000025 2012-11-23 21:11:57 <IOCP WORKTHREAD #17 RUNNING>
000026 2012-11-23 21:11:57 <IOCP WORKTHREAD #18 RUNNING>
000027 2012-11-23 21:11:57 <IOCP WORKTHREAD #19 RUNNING>
000028 2012-11-23 21:11:57 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2012-11-23 21:11:58 <NUMBER OF 41 SESSION WORKER STARTED>
000030 2012-11-23 21:11:58 <SUCCESSED SESSION MANAGER INIT> AccountLog_DB
000031 2012-11-23 21:11:58 *FAILED START LISTEN SOCKET*
000032 2012-11-23 21:11:58 < END OF MAIN = 0 >
000034 2012-11-23 21:11:58 <SESSION WORKER #35 FREE>
000033 2012-11-23 21:11:58 <SESSION WORKER #31 FREE>
000036 2012-11-23 21:11:58 <SESSION WORKER #38 FREE>
000037 2012-11-23 21:11:58 <SESSION WORKER #37 FREE>
000039 2012-11-23 21:11:58 <SESSION WORKER #7 FREE>
000040 2012-11-23 21:11:58 <SESSION WORKER #13 FREE>
000038 2012-11-23 21:11:58 <SESSION WORKER #33 FREE>
000042 2012-11-23 21:11:58 <SESSION WORKER #3 FREE>
000053 2012-11-23 21:11:58 <SESSION WORKER #21 FREE>
000043 2012-11-23 21:11:58 <SESSION WORKER #1 FREE>

000045 2012-11-23 21:11:58 <SESSION WORKER #23 FREE>
000061 2012-11-23 21:11:58 <SESSION WORKER #9 FREE>
000046 2012-11-23 21:11:58 <SESSION WORKER #0 FREE>
000047 2012-11-23 21:11:58 <SESSION WORKER #8 FREE>
000048 2012-11-23 21:11:58 <SESSION WORKER #39 FREE>
000035 2012-11-23 21:11:58 <SESSION WORKER #34 FREE>
000051 2012-11-23 21:11:58 <SESSION WORKER #20 FREE>
000052 2012-11-23 21:11:58 <SESSION WORKER #10 FREE>
000049 2012-11-23 21:11:58 <SESSION WORKER #6 FREE>
000050 2012-11-23 21:11:58 <SESSION WORKER #17 FREE>
000054 2012-11-23 21:11:58 <SESSION WORKER #15 FREE>
000056 2012-11-23 21:11:58 <SESSION WORKER #36 FREE>
000055 2012-11-23 21:11:58 <SESSION WORKER #18 FREE>
000059 2012-11-23 21:11:58 <SESSION WORKER #22 FREE>
000064 2012-11-23 21:11:58 <SESSION WORKER #24 FREE>
000065 2012-11-23 21:11:58 <SESSION WORKER #27 FREE>
000063 2012-11-23 21:11:58 <SESSION WORKER #26 FREE>
000060 2012-11-23 21:11:58 <SESSION WORKER #32 FREE>
000062 2012-11-23 21:11:58 <SESSION WORKER #11 FREE>
000057 2012-11-23 21:11:58 <SESSION WORKER #29 FREE>
000068 2012-11-23 21:11:58 <SESSION WORKER #2 FREE>
000067 2012-11-23 21:11:58 <SESSION WORKER #12 FREE>
000072 2012-11-23 21:11:58 <SESSION WORKER #14 FREE>
000044 2012-11-23 21:11:58 <SESSION WORKER #4 FREE>
000069 2012-11-23 21:11:58 <SESSION WORKER #40 FREE>
000071 2012-11-23 21:11:58 <SESSION WORKER #16 FREE>
000070 2012-11-23 21:11:58 <SESSION WORKER #28 FREE>
000041 2012-11-23 21:11:58 <SESSION WORKER #30 FREE>
000073 2012-11-23 21:11:58 <SESSION WORKER #25 FREE>
000066 2012-11-23 21:11:58 <SESSION WORKER #5 FREE>
000074 2012-11-23 21:11:58 <IOCP WORKTHREAD #14 FREE>
000075 2012-11-23 21:11:58 <IOCP WORKTHREAD #17 FREE>
000076 2012-11-23 21:11:58 <IOCP WORKTHREAD #13 FREE>
000077 2012-11-23 21:11:58 <IOCP WORKTHREAD #15 FREE>
000078 2012-11-23 21:11:58 <IOCP WORKTHREAD #11 FREE>
000078 2012-11-23 21:11:58 <IOCP WORKTHREAD #10 FREE>
000079 2012-11-23 21:11:58 <IOCP WORKTHREAD #9 FREE>
000080 2012-11-23 21:11:58 <IOCP WORKTHREAD #7 FREE>
000081 2012-11-23 21:11:58 <IOCP WORKTHREAD #6 FREE>
000082 2012-11-23 21:11:58 <IOCP WORKTHREAD #16 FREE>
000083 2012-11-23 21:11:58 <IOCP WORKTHREAD #5 FREE>
000084 2012-11-23 21:11:58 <IOCP WORKTHREAD #3 FREE>
000085 2012-11-23 21:11:58 <IOCP WORKTHREAD #2 FREE>
000086 2012-11-23 21:11:58 <IOCP WORKTHREAD #12 FREE>
000087 2012-11-23 21:11:58 <IOCP WORKTHREAD #1 FREE>
000089 2012-11-23 21:11:58 <IOCP WORKTHREAD #19 FREE>
000090 2012-11-23 21:11:58 <IOCP WORKTHREAD #4 FREE>
000088 2012-11-23 21:11:58 <IOCP WORKTHREAD #8 FREE>
000091 2012-11-23 21:11:58 <IOCP WORKTHREAD #0 FREE>
 
L

LolOmgNoob

Experienced Elementalist
Joined
Nov 16, 2012
Messages
241
Reaction score
8
000030 2012-11-23 21:11:58 <SUCCESSED SESSION MANAGER INIT> AccountLog_DB
000031 2012-11-23 21:11:58 *FAILED START LISTEN SOCKET*
000032 2012-11-23 21:11:58 < END OF MAIN = 0 >
 
C

cieto12345

Newbie Spellweaver
Joined
Dec 19, 2011
Messages
77
Reaction score
1
it's this one here:

Code: 
/****** 개체: 저장 프로시저 dbo.p_Char_Delete    스크립트 날짜: 2007-03-13 오후 6:25:10 ******/


ALTER PROCEDURE [dbo].[p_Set_Guild_Academy_Reward_Record]


/*--------------------------------------------------------------------------------------
' ÀÌ  ¸§ : usp_GuildAcademy_setReward
' ÀÛ¼ºÀÚ : Ko Dong Gyun(kodong@gmail.com)
' ÀÛ¼ºÀÏ : 2008.5.8.
' Description :
'   ±æµå¾ÆÄ«µ¥¹Ì º¸»ó ¼³Á¤
' Parameter :
'	input Parameter
'		@nNo 	 : ±æµå¹øÈ£
'		@nLevel  : ·¹º§
'		@nTypeID : º¸»óŸÀÔ
'		@nValue  : º¸»ó°ª
'		@nItemID : ¾ÆÀÌÅÛ
'	output Parameter
'		@nRet	 : check SQL execute(valid/invalid)
'			= 0	 : works ok
'			< 0	 : error
'				-1513 : invaild nLevel
'				-1595 : db error(select)
'-------------------------------------------------------------------------------------*/
	@nNo     int
,	@nLevel  smallint
,	@nTypeID tinyint
,	@nValue  bigint
,	@nItemID int = null
,	@nRet    int = 0 output

AS
BEGIN
SET NOCOUNT ON

	SET @nRet = 0

	IF @nLevel <= 0 BEGIN
		SET @nRet = -1513
		RETURN
	END

	
	INSERT INTO tGuildAcademyReward (nNo, nLevel, nTypeID, nValue, nItemID)
	VALUES (@nNo, @nLevel, @nTypeID, @nValue, @nItemID)
	IF @@ERROR <> 0 BEGIN
		SET @nRet = -1595
		RETURN
	END
	SET NOCOUNT OFF
END

but i did not try to fix it atm
 
L

LolOmgNoob

Experienced Elementalist
Joined
Nov 16, 2012
Messages
241
Reaction score
8
cieto12345 said:
it's this one here:

Code: 
/****** 개체: 저장 프로시저 dbo.p_Char_Delete    스크립트 날짜: 2007-03-13 오후 6:25:10 ******/


ALTER PROCEDURE [dbo].[p_Set_Guild_Academy_Reward_Record]


/*--------------------------------------------------------------------------------------
' ÀÌ  ¸§ : usp_GuildAcademy_setReward
' ÀÛ¼ºÀÚ : Ko Dong Gyun(kodong@gmail.com)
' ÀÛ¼ºÀÏ : 2008.5.8.
' Description :
'   ±æµå¾ÆÄ«µ¥¹Ì º¸»ó ¼³Á¤
' Parameter :
'	input Parameter
'		@nNo 	 : ±æµå¹øÈ£
'		@nLevel  : ·¹º§
'		@nTypeID : º¸»óŸÀÔ
'		@nValue  : º¸»ó°ª
'		@nItemID : ¾ÆÀÌÅÛ
'	output Parameter
'		@nRet	 : check SQL execute(valid/invalid)
'			= 0	 : works ok
'			< 0	 : error
'				-1513 : invaild nLevel
'				-1595 : db error(select)
'-------------------------------------------------------------------------------------*/
	@nNo     int
,	@nLevel  smallint
,	@nTypeID tinyint
,	@nValue  bigint
,	@nItemID int = null
,	@nRet    int = 0 output

AS
BEGIN
SET NOCOUNT ON

	SET @nRet = 0

	IF @nLevel <= 0 BEGIN
		SET @nRet = -1513
		RETURN
	END

	
	INSERT INTO tGuildAcademyReward (nNo, nLevel, nTypeID, nValue, nItemID)
	VALUES (@nNo, @nLevel, @nTypeID, @nValue, @nItemID)
	IF @@ERROR <> 0 BEGIN
		SET @nRet = -1595
		RETURN
	END
	SET NOCOUNT OFF
END

but i did not try to fix it atm
Click to expand...

It's not in the procedures. It's in the actual academy tables inside the w00_Character.t.Tables
 
X

xBoredom

Newbie Spellweaver
Joined
Jul 16, 2011
Messages
5
Reaction score
0
Any other suggestions on the server full issue? I have read through this entire thread and tried trial and error, which got me past the authentication failed error once.
 
ChubbyCrab

ChubbyCrab

Newbie Spellweaver
Joined
Jan 26, 2012
Messages
95
Reaction score
41
xBoredom said:
Any other suggestions on the server full issue? I have read through this entire thread and tried trial and error, which got me past the authentication failed error once.
Click to expand...

Possible solution 1:
I supported many ppl via TV and a common problem was always the performance of the system the server runs on.
To run the services with only one zone (Zone_Server00) you a minimum of 4,5 GB RAM. If you also want to start a client on the same system, you need ca. 5 GB of RAM.
If you want to run your server with all zones you need more then 8 GB of RAM, with a client it takes ca. 8,6 GB.
You also have to include the CPU performance, the minimum is ca. 2,8 GHz singlecore, 2,5 GHz multicore.

If you do not have the minimum requirements, there can be problems like yours.

Possible solution 2:

  1. Stop all yout fiesta services
  2. Go to your service-folders
  3. Delete the folder "DebugMessage" in each one
  4. Restart your services
  5. Try to login
  6. Check the service-folders again and check the error-definitions

If you do not know how to read these logs post them here, but please as downloadable textfiles OR each one in a SPOILER!
 
C

cieto12345

Newbie Spellweaver
Joined
Dec 19, 2011
Messages
77
Reaction score
1
Oh you are right it's very easy to fix academy rewards. Got it working now, too :D
 
ChubbyCrab

ChubbyCrab

Newbie Spellweaver
Joined
Jan 26, 2012
Messages
95
Reaction score
41
cieto12345 said:
Oh you are right it's very easy to fix academy rewards. Got it working now, too :D
Click to expand...

Share it :D
Please don`t start to get back the "ego ghost" to this section =/
We´ve try to fix it too, but no success yet.

Also we try to change th amount of chars per account to 5, but it´s tricky.

Sharing is caring.Without sharing you would never be able to work on these files ;p
 
C

cieto12345

Newbie Spellweaver
Joined
Dec 19, 2011
Messages
77
Reaction score
1
OK here is the query you have to use:

Code: 
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');

Would be nice if someone can tell us how titles and flame walker effect could be fixed :D
 
C

Crystalz

Experienced Elementalist
Joined
Aug 26, 2012
Messages
212
Reaction score
62
cieto12345 said:
OK here is the query you have to use:

Code: 
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');

Would be nice if someone can tell us how titles and flame walker effect could be fixed :D
Click to expand...


Flame Walker = Replace the FirePole Folder in reschar with Os's.
 
Black12

Black12

Junior Spellweaver
10 Happy Years
Joined
Feb 7, 2012
Messages
119
Reaction score
25
OK here is the query you have to use:

Code:

INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');

Would be nice if someone can tell us how titles and flame walker effect could be fixed :D
Click to expand...



000043 2012-11-24 13:37:49 ERROR - CPFsCharacter::fc_NC_CHAR_REGNUM_VARIFICATION_REQ DB Procedure Fail : CharNo(56), CharID(Sequess), ZoneHandle(2), nRet=0
000044 2012-11-24 13:39:24 ERROR - CSQLPGuild::p_Set_Guild_Academy_Reward_Record, ret(-1), nRet(-1595)
 
L

LolOmgNoob

Experienced Elementalist
Joined
Nov 16, 2012
Messages
241
Reaction score
8
cieto12345 said:
OK here is the query you have to use:

Code: 
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');

Would be nice if someone can tell us how titles and flame walker effect could be fixed :D
Click to expand...

So you use query's to manually add items each time?
 
Black12

Black12

Junior Spellweaver
10 Happy Years
Joined
Feb 7, 2012
Messages
119
Reaction score
25
cieto12345 said:
No just execute it once, then it should work ingame.
Click to expand...

Error:

000043 2012-11-24 13:37:49 ERROR - CPFsCharacter::fc_NC_CHAR_REGNUM_VARIFICATION_REQ DB Procedure Fail : CharNo(56), CharID(Sequess), ZoneHandle(2), nRet=0
000044 2012-11-24 13:39:24 ERROR - CSQLPGuild::p_Set_Guild_Academy_Reward_Record, ret(-1), nRet(-1595)

^^
 
L

lazyx3

Newbie Spellweaver
Joined
Jan 11, 2012
Messages
20
Reaction score
1
aka item an Money fix

INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('3', 'nNo');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('4', 'nLevel');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('5', 'nTypeID');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('6', 'nValue');
INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('7', 'nItemID');
Click to expand...
 
Last edited:
Riko

Riko

Junior Spellweaver
Joined
Sep 20, 2009
Messages
101
Reaction score
29
could someone tell me why the item's in my premium bag not showin up? The Character.exe ask the apache just 1 time..and the string is right tho...

When i check premium inventory again the character dont even try again recieving items from DB.

is it related to:

Code: 
000055 2012-11-27 10:11:34 ERROR - CPFsCharacter::fc_NC_CHAR_REGNUM_VARIFICATION_REQ DB Procedure Fail : CharNo(61), CharID(test), ZoneHandle(10), nRet=0
000056 2012-11-27 10:12:46 Error - fc_NC_CHAR_LOGOUT_DB, CharNo=61, PlayMin=1

?


EDIT: yes im fcktard...used the wrong goods number

But now the character server kinda stuck? the item is marked as used in database but its still in my premium bag.

And again character stop sending requests to apache

EDIT 2: ok seems to be a prob with my php :S i dont know why that happen <_<; already compared the returns of OdinRest with my stuff. too bad i cant take a look on the OdinRest source

ignore this post~
 
Last edited:
Status
Not open for further replies.

RaGEZONE Sponsor

    HyperFilter

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Forum statistics

Threads
430,269
Messages
4,597,177
Members
286,943
Latest member
admin123
Most visitors online was 17251 , on 24 May 2024

Partners

    nongamstopbets.com Non-GamStop CasinoGap Casino Deps NZ
Back
Top