I just wanted to know how
I just wanted to know how
In your w00_Character database? ;c
mh, where exactly
find it out o: Its really easy to fix. Read also the Logs from Character.exe then you'll know where is the Problem ;)Originally Posted by lazyx3
mh, where exactly
What is the Problem here :o?
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>
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 >
it's this one here:
but i did not try to fix it atmCode:/****** 개체: 저장 프로시저 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
It's not in the procedures. It's in the actual academy tables inside the w00_Character.t.Tables
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.
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:
- Stop all yout fiesta services
- Go to your service-folders
- Delete the folder "DebugMessage" in each one
- Restart your services
- Try to login
- 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!
Oh you are right it's very easy to fix academy rewards. Got it working now, too :D
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
OK here is the query you have to use:
Would be nice if someone can tell us how titles and flame walker effect could be fixed :DCode:INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('1', 'Money'); INSERT INTO w00_character.dbo.tGuildAcademyRewardType (nTypeID, sTypeName) VALUES ('2', 'Items');
Flame Walker = Replace the FirePole Folder in reschar with Os's.
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
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)
So you use query's to manually add items each time?
No just execute it once, then it should work ingame.
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)
^^
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');
Last edited by lazyx3; 27-11-12 at 12:12 PM.
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 by Riko; 27-11-12 at 01:34 PM.
That's why I released the OdinRestServer.
^.^
Link for updated Rest server down ...
I think this is the latest version
Thx
