[v11] Hangs at server select

Keep getting this error after I select the server cluster and channel.

Code:

---

2009/10/27    00:50:27
query:LOG_USER_CNT_STR '01', 0
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'LOG_USER_CNT_STR'.

---

I have all the needed databases in there. The stored procedure is there so why is it saying its not?

I'm getting the same error. :\ I have re-executed the db and everything else. I just don't get it.

Have you assigned odbc drivers for the SQL Server or native client? If not all odbc things like log01 should be seleted as SQL Server not native client

Geez Glaph these files just don't want to work for you. Well i havernt encounted this error but i will look into it for ya :P

LOG_USER_CNT_STR i think something went wrong while excuteing.
Mine

Also excute this EXEC sp_dbcmptlevel DATABASENAME , 80;
Example
EXEC sp_dbcmptlevel LOG01_DBF , 80;
LOG_USER_CNT_STR

Code:

---

--
-- Definition for stored procedure LOG_USER_CNT_STR :
--
GO
CREATE PROC [dbo].LOG_USER_CNT_STR
@iserverindex CHAR(2),
@im_01 INT = 0,
@im_02 INT = 0,
@im_03 INT = 0,
@im_04 INT = 0,
@im_05 INT = 0,
@im_06 INT = 0,
@im_07 INT = 0,
@im_08 INT = 0,
@im_09 INT = 0,
@im_10 INT = 0,
@im_11 INT = 0,
@im_12 INT = 0,
@im_13 INT = 0,
@im_14 INT = 0,
@im_15 INT = 0,
@im_16 INT = 0,
@im_17 INT = 0,
@im_18 INT = 0,
@im_19 INT = 0,
@im_20 INT = 0

---

DELETE YOUR OLD ONE and excute this one :P

Glaphan i can help you fix your problems easily >: I'm just not sure yet if releasing a guide

so wait. is it LOG01_DBF or LOG_01_DBF?

I have the database in there but it looks as if it might be named different?

Perhaps I'm doing it wrong?

I believe it is LOG_01_DBF. ^^

Execute this into your database, re-start the database server by restarting the microsoft SQL database server service:

Code:

---

USE [LOG_01_DBF]
GO

DROP PROCEDURE LOG_USER_CNT_STR
GO

/****** Object:  StoredProcedure [dbo].[LOG_USER_CNT_STR]    Script Date: 09/27/2009 16:37:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object:  Stored Procedure dbo.LOG_USER_CNT_STR    Script Date: 7/29/2008 4:41:34 AM ******/


CREATE  PROCEDURE [dbo].[LOG_USER_CNT_STR]
@iserverindex          CHAR(2),
@im_01 INT = 0,
@im_02 INT = 0,
@im_03 INT = 0,
@im_04 INT = 0,
@im_05 INT = 0,
@im_06 INT = 0,
@im_07 INT = 0,
@im_08 INT = 0,
@im_09 INT = 0,
@im_10 INT = 0,
@im_11 INT = 0,
@im_12 INT = 0,
@im_13 INT = 0,
@im_14 INT = 0,
@im_15 INT = 0,
@im_16 INT = 0,
@im_17 INT = 0,
@im_18 INT = 0,
@im_19 INT = 0,
@im_20 INT = 0
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************



        LOG_USER_CNT_STR 스토어드
        작성자 : 최석준
        작성일 : 2003.12.19



***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
DECLARE @os_date CHAR(14),@onumber INT

  SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)

  SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
                                                                        + @im_06 + @im_07 + @im_08 + @im_09 + @im_10
                                                                        + @im_11 + @im_12 + @im_13 + @im_14 + @im_15
                                                                        + @im_16 + @im_17 + @im_18 + @im_19 + @im_20

        INSERT LOG_USER_CNT_TBL
                (
                        serverindex,
                        s_date,
                        number,
                        m_01,
                        m_02,
                        m_03,
                        m_04,
                        m_05,
                        m_06,
                        m_07,
                        m_08,
                        m_09,
                        m_10,
                        m_11,
                        m_12,
                        m_13,
                        m_14,
                        m_15,
                        m_16,
                        m_17,
                        m_18,
                        m_19,
                        m_20
                )
        VALUES
                (
                        @iserverindex,
                        @os_date,
                        @onumber,
                        @im_01,
                        @im_02,
                        @im_03,
                        @im_04,
                        @im_05,
                        @im_06,
                        @im_07,
                        @im_08,
                        @im_09,
                        @im_10,
                        @im_11,
                        @im_12,
                        @im_13,
                        @im_14,
                        @im_15,
                        @im_16,
                        @im_17,
                        @im_18,
                        @im_19,
                        @im_20
                )
RETURN
set nocount off
GO

---

Quote:

---

Originally Posted by Link404

Execute this into your database, re-start the database server by restarting the microsoft SQL database server service:

Code:

---

USE [LOG_01_DBF]
GO

DROP PROCEDURE LOG_USER_CNT_STR
GO

/****** Object:  StoredProcedure [dbo].[LOG_USER_CNT_STR]    Script Date: 09/27/2009 16:37:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object:  Stored Procedure dbo.LOG_USER_CNT_STR    Script Date: 7/29/2008 4:41:34 AM ******/


CREATE  PROCEDURE [dbo].[LOG_USER_CNT_STR]
@iserverindex          CHAR(2),
@im_01 INT = 0,
@im_02 INT = 0,
@im_03 INT = 0,
@im_04 INT = 0,
@im_05 INT = 0,
@im_06 INT = 0,
@im_07 INT = 0,
@im_08 INT = 0,
@im_09 INT = 0,
@im_10 INT = 0,
@im_11 INT = 0,
@im_12 INT = 0,
@im_13 INT = 0,
@im_14 INT = 0,
@im_15 INT = 0,
@im_16 INT = 0,
@im_17 INT = 0,
@im_18 INT = 0,
@im_19 INT = 0,
@im_20 INT = 0
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************



        LOG_USER_CNT_STR 스토어드
        작성자 : 최석준
        작성일 : 2003.12.19



***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
DECLARE @os_date CHAR(14),@onumber INT

  SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
                                                                        + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)

  SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
                                                                        + @im_06 + @im_07 + @im_08 + @im_09 + @im_10
                                                                        + @im_11 + @im_12 + @im_13 + @im_14 + @im_15
                                                                        + @im_16 + @im_17 + @im_18 + @im_19 + @im_20

        INSERT LOG_USER_CNT_TBL
                (
                        serverindex,
                        s_date,
                        number,
                        m_01,
                        m_02,
                        m_03,
                        m_04,
                        m_05,
                        m_06,
                        m_07,
                        m_08,
                        m_09,
                        m_10,
                        m_11,
                        m_12,
                        m_13,
                        m_14,
                        m_15,
                        m_16,
                        m_17,
                        m_18,
                        m_19,
                        m_20
                )
        VALUES
                (
                        @iserverindex,
                        @os_date,
                        @onumber,
                        @im_01,
                        @im_02,
                        @im_03,
                        @im_04,
                        @im_05,
                        @im_06,
                        @im_07,
                        @im_08,
                        @im_09,
                        @im_10,
                        @im_11,
                        @im_12,
                        @im_13,
                        @im_14,
                        @im_15,
                        @im_16,
                        @im_17,
                        @im_18,
                        @im_19,
                        @im_20
                )
RETURN
set nocount off
GO

---

---

ohh whoops xD
Sorry glaphan o.o i forgot those other lines X.x should better watch next time D:

Did you use the update .ini files for the server files.?? cause i think the ones in the download with the files are bugged.

how do i update them? I only have the ones downloaded

-.- the reason your getting stuck at server select ( right after you select server i bet ) is because you didnt comment out the line that loads gameguard. Check your login server config file for the line, or use a v11 client with gameguard enabled.

I'll be a son of a bitch! I knew it was one small line! Thanks reflax. Now I can get down to brass tacks.

So have you solved your error.??