[Dev] Server 4.2 Release support

Page 3 of 6 FirstFirst 123456 LastLast
Results 31 to 45 of 82
  1. #31
    Hardcore Member pegasus82 is offline
    MemberRank
    Jan 2012 Join Date
    117Posts

    Re: Server 4.2 Release support


    RaGEZONE Recommends

    RaGEZONE Recommends

    I'm stuck on pet procedures.

  2. #32
    Member KenshinCE is offline
    MemberRank
    Feb 2006 Join Date
    42Posts

    Re: Server 4.2 Release support

    Quote Originally Posted by WarriorSW View Post
    I fixed preety all just one what i have to do its complete CrystalSystem tables and it will be like original DB (NGC Infl War working corectly, pet socket, level, name working, arena maps ragnarok armagedon working, InfinityField 1,2,3 working) , About crystals i just started to work with them but i have a quite problem with sequencenumbers ( if its not a random when beat one crystal then rest of them dissapear but its under construction now), ahh i almost forget, all bins cleaned and deleted that shitty welcome message

    about procedure/table:

    Proc:
    Code:
    USE [atum2_db_1]
    GO
    /****** Object:  StoredProcedure [dbo].[atum_load_ti_itemmixingelement]    Script Date: 2014-04-03 14:51:10 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    ALTER PROCEDURE [dbo].[atum_load_ti_itemmixingelement]
    AS
    	SELECT UniqueID,ItemNum,Count FROM atum2_db_account.dbo.ti_itemmixingelement WITH (NOLOCK);
    Table (Copied from table design):
    Code:
    UniqueID	int	Checked
    ItemNum	int	Checked
    Count	int	Checked
    		Unchecked
    Youre welcome
    Yeah I tried that first before I wrote the other and I see what I did wrong. Note to self - try not to code at 4 am when your brain is dead. I forgot to add any data to the table.

    Edit: Ok still not working, :/ well the procedure is but not sure why its not accepting the data I put into the table.
    Last edited by KenshinCE; 03-04-14 at 08:02 PM.

  3. #33
    Se7enSins WARonline is offline
    True MemberRank
    Sep 2011 Join Date
    Limassol, CypruLocation
    1,333Posts

    Re: Server 4.2 Release support

    Any idea with this:
    Code:
    4-04 00:58:40|[Notify] ItemEvent reloaded !!, ItemEvent Count(112)
    04-04 00:58:42|ERROR: CAtumDBHelper::LoadItemMixingInfo() Failed!!!
    04-04 00:58:42|[Error] FieldServer IOCPInit Error
    04-04 00:58:48|  [Notify] CFieldGlobal::EndServerSocket# 
    04-04 00:58:48|CGlobalGameServer::EndServerSocket_1
    It's the procedure incorrect I assume.

  4. #34
    Ultimate Member WarriorSW is offline
    MemberRank
    Oct 2013 Join Date
    162Posts

    Re: Server 4.2 Release support

    Procedure and table incorrect. In ti_mixinginfo should be products only and in mixinginfoelements ingreediens. server match them by col uniquenumber

  5. #35
    RoRivals gaby001 is offline
    True MemberRank
    Aug 2011 Join Date
    RomaniaLocation
    376Posts

    Re: Server 4.2 Release support

    USE [atum2_db_1]
    GO

    /****** Object: StoredProcedure [dbo].[atum_import_ti_itemmixingelement] Script Date: 04-Apr-14 9:13:47 AM ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO


    --------------------------------------------------------------
    -- ti_ItemMixingElement µ¥ÀÌÅÍ »ý¼º °ü·Ã
    --------------------------------------------------------------
    -- !!!!
    -- Name:
    -- Desc: // 2009-07-09 by jwlee, °ÔÀÓ Á¤º¸ Å×ÀÌºí µ¥ÀÌÅÍ DB¿¡ ¹Ð¾î³Ö±â Åø ±¸Çö -
    -- // 2012-02-20 by hskim, DB Á¤±ÔÈ­ - ItemMixingInfo
    -- ====
    CREATE PROCEDURE [dbo].[atum_import_ti_itemmixingelement]
    @uniqueid INT,
    @sourceItemNum INT,
    @sourceItemCount INT
    -- // 2009-02-17 by cmkwon, MARK for Yedang -- // 2008-09-04 by cmkwon, ¿¹´ç º¸¾È°ü·Ã ¼û±ä °èÁ¤ Àû¿ë Çϱâ(SQL Server 2005ÀÌ»ó¸¸ Áö¿øÇÏ´Â ±â´É) -
    AS
    INSERT INTO atum2_db_account.dbo.ti_ItemMixingElement(UniqueID, SourceItemNum, SourceItemCount)
    VALUES @uniqueid, @sourceItemNum, @sourceItemCount)

    GO
    - - -™®GaßYºº¹_25® - - -

  6. #36
    Member Davidc96 is offline
    MemberRank
    Feb 2011 Join Date
    Rubí, CatalunaLocation
    75Posts

    Re: Server 4.2 Release support

    I have a problem with DBLoadInitializedGuild, I made the procedures InitializedGuild but when I start field server, Profiler stops in atum_LeaderCandidate.

    I was seeing if there are something need to change but there are no diferences between leadercandidate ep3.5 and ep4.3.

    I added values but nothing.

    I dont know how but now, it stopped in Delete_InitializedGuildList, my procedures are based in thread [REQUEST]procedure 4.2 by WarriorSW
    Last edited by Davidc96; 04-04-14 at 09:26 AM.

  7. #37
    Ultimate Member WarriorSW is offline
    MemberRank
    Oct 2013 Join Date
    162Posts

    Re: Server 4.2 Release support

    check load Pet and PetLevel procedures

  8. #38
    Se7enSins WARonline is offline
    True MemberRank
    Sep 2011 Join Date
    Limassol, CypruLocation
    1,333Posts

    Re: Server 4.2 Release support

    Gabe I was talking about procedure of Load_ti_ItemMixingInfo. That procedure is for import.
    Last edited by WARonline; 04-04-14 at 01:37 PM.

  9. #39
    Member Davidc96 is offline
    MemberRank
    Feb 2011 Join Date
    Rubí, CatalunaLocation
    75Posts

    Re: Server 4.2 Release support

    Quote Originally Posted by WarriorSW View Post
    check load Pet and PetLevel procedures
    I checked it but the same error:
    My Delete_InitializedGuildList

    USE [atum2_db_1]
    GO
    /****** Object: StoredProcedure [dbo].[atum_Delete_InitializedGuildList] Script Date: 04/04/2014 18:21:35 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[atum_Delete_InitializedGuildList]
    AS


    RETURN
    My PetLevel Procedure:
    ALTER PROC [dbo].[atum_Load_ti_petLevel]
    --@i_PetIndex INT
    AS

    BEGIN
    SELECT PetIndex, PetLevel, NeedExp, UseWeaponIndex, SlotCountSkill, SlotCountSocket, KitLevelHP, KitLevelShield, KitLevelSP FROM atum2_db_1.dbo.ti_PetLevel --WHERE PetIndex = @i_PetIndex;
    END
    Profiler stops in Delete_InitializedGuildList

  10. #40
    RoRivals gaby001 is offline
    True MemberRank
    Aug 2011 Join Date
    RomaniaLocation
    376Posts

    Re: Server 4.2 Release support

    yea i know but i se here that procedure is from ep 3.5 my procedure is difrent is from ep 4>>> what u know i have the complete DB for ep 4 and and al file server waiting to my frend to ghive this day the complete surce> but that pocedure is difrend and is the saime table
    dbo_ty_itemmixinginfo
    and that is the last procedure i share
    Last edited by gaby001; 04-04-14 at 08:27 PM.
    - - -™®GaßYºº¹_25® - - -

  11. #41
    Se7enSins WARonline is offline
    True MemberRank
    Sep 2011 Join Date
    Limassol, CypruLocation
    1,333Posts

    Re: Server 4.2 Release support

    Any ideas about this?
    Code:
    04-05 02:55:00|	szSqlState    = 42000
    04-05 02:55:00|	pfNativeError = 8144
    04-05 02:55:00|	szErrorMsg    = [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function atum_log_insert_total_user has too many arguments specified.
    04-05 02:55:00|	pcbErrorMsg   = 129
    
    04-05 02:55:00|	ODBCRowNumber = 1
    04-05 02:55:00|	SSrvrLine     = 1
    04-05 02:55:00|	SSrvrMsgState = 2
    04-05 02:55:00|	SSrvrSeverity = 16
    04-05 02:55:00|	SSrvrProcname = atum_log_insert_total_user
    04-05 02:55:00|	SSrvrSrvname  = MIHAI-52E9F83AC
    
    04-05 02:55:00|[DB Error] DBWorkerThreadID( 6060) hstmt(0xAA3618): [COLOR="#FF0000" @Atum_log_insert_total_user Failed![/COLOR]
    
    04-05 02:55:00|	szSqlState    = 42000
    04-05 02:55:00|	pfNativeError = 8144
    04-05 02:55:00|	szErrorMsg    = [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function atum_log_insert_total_user has too many arguments specified.
    04-05 02:55:00|	pcbErrorMsg   = 129
    
    04-05 02:55:00|	ODBCRowNumber = 1
    04-05 02:55:00|	SSrvrLine     = 1
    04-05 02:55:00|	SSrvrMsgState = 2
    04-05 02:55:00|	SSrvrSeverity = 16
    04-05 02:55:00|	SSrvrProcname = atum_log_insert_total_user
    04-05 02:55:00|	SSrvrSrvname  = MIHAI-52E9F83AC
    
    04-05 02:55:14|[ERROR] CSPToMPWinSocket Timeout !!
    04-05 03:00:00|[DB Error] DBWorkerThreadID( 5120) hstmt(0xAA7DF0): @Atum_log_insert_total_user Failed!
    and here's the procedure:
    Code:
    USE [atum2_db_account]
    GO
    /****** Object:  StoredProcedure [dbo].[atum_PROCEDURE_080827_0087]    Script Date: 04/05/2014 02:55:52 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    --------------------------------------------------------------------------------
    -- PROCEDURE NAME	: dbo.atum_PROCEDURE_080827_0087
    -- DESC				: -- // 2008-08-27 by cmkwon, ³¯Äõ¸®¸¦ Procedure·Î ¼öÁ¤ - 
    --------------------------------------------------------------------------------
    ALTER PROCEDURE [dbo].[atum_PROCEDURE_080827_0087]
    AS
    	UPDATE dbo.td_account
    	SET ConnectingServerGroupID = 0;
    Too many arguments? I cannot see too many arguments...

  12. #42
    Retired (Goddamn idiots) DragonLord is offline
    True MemberRank
    Dec 2003 Join Date
    /dev/urandomLocation
    553Posts

    Re: Server 4.2 Release support

    It means that 1 or more arguments have been passed to the procedure and your procedure was not set up to handle it accordingly.
    On a side note, the procedure you're showing here is not the one mentioned in your log files.
    Insanity - Doing the same thing over and over again, expecting different results - Albert Einstein


    R.I.P. Akaruz - We miss ya buddy

  13. #43
    Member hi5 is offline
    MemberRank
    Aug 2011 Join Date
    70Posts

    Re: Server 4.2 Release support

    Code:
    USE [atum2_db_account]
    GO
    
    /****** Object:  StoredProcedure [dbo].[atum_log_insert_total_user]    Script Date: 05.04.2014 7:38:57 ******/
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
        CREATE PROCEDURE [dbo].[atum_log_insert_total_user]
            @i_ServerGroupName            VARCHAR(20),    
            @i_MGameServerID            INT,
            @i_UserCount                INT,
            @i_nUserCountsOtherPublisherConncect                INT
        AS
            INSERT INTO atum_log_total_user
            VALUES (GetDate(), @i_ServerGroupName, @i_MGameServerID, @i_UserCount, @i_nUserCountsOtherPublisherConncect)
    
    GO


    Code:
    USE [atum2_db_account]
    GO
    
    /****** Object:  Table [dbo].[atum_log_total_user]    Script Date: 05.04.2014 7:38:44 ******/
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    SET ANSI_PADDING ON
    GO
    
    CREATE TABLE [dbo].[atum_log_total_user](
        [Time] [datetime] NULL,
        [ServerGroupName] [varchar](20) NULL,
        [MGameServerID] [int] NULL,
        [UserCount] [int] NULL,
        [UserCountsOtherPublisherConncect] [int] NULL
    ) ON [PRIMARY]
    
    GO
    
    SET ANSI_PADDING OFF
    GO

  14. #44
    Se7enSins WARonline is offline
    True MemberRank
    Sep 2011 Join Date
    Limassol, CypruLocation
    1,333Posts

    Re: Server 4.2 Release support

    I realized that exist an error in PreServer logs as
    Code:
    04-05 10:33:36|[ERROR] CSPToMPWinSocket Timeout !!
    Meanwhile, in FieldServer start to spam this:
    Code:
    04-05 10:33:58|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 1002] CommitSize[ 1511424] vectorSize[3] Address Range(0x7EEA0000 ~ 0x7F011000)
    04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 501) 
    04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 502) 
    04-05 10:33:58|  [Notify] LogError, Index(  2) CLogWinSocket(0x1337010) SendBufferSize( 503) 
    with different BufferSize()

  15. #45
    Member mafiaa19997 is offline
    MemberRank
    Oct 2011 Join Date
    Sion, SwitzerlaLocation
    36Posts

    Re: Server 4.2 Release support

    Hi,

    you have an idea or it may come:



    thanks in advance for your help




Page 3 of 6 FirstFirst 123456 LastLast

Advertisement