Unable to channel or Does not show channel. [help Me please].

Printable View

  • SQL Server should verify the authenticity of the login ID "with Windows NT authentication using the network login ID".
    Make sure "Connect to SQL Server to obtain default settings..." is checked, then hit Next.
  • Check the Change the default database to: option, and select ini3_py_account. Hit Next.
  • Click Finish, and a window will pop-up confirming all the info you provided. Hit OK, and you're done!
  • Rinse and repeat for the remaining 2 databases.
  • 06-01-11
    terrorofdeath
    Re: Server Channels Absent
    Quote:
    Originally Posted by Tsukasa View Post
    As for your problem, please verify whether the table TD_CHAR_EQUIP_S4 actually exists. Your log indicates this not to be the case.
    And, in fact, that's practically the case. -_-'

    In Pangya_S4_TH there is the table "TD_CHAR_EQUIP" ; missing the "_S4". Would simply renaming it work?

    I'll read through it whenever I wake up today. xD Need to stop staying up till 6/7 am... <_<

    Quote:
    Originally Posted by mikumiku View Post
    This is a common problem. People (like myself ;_;) tend to not realize that the servers can't just magically read the databases by themselves. They require a data source to read from, hence the ODBC errors that you got. Therefore, you need to create a data source for each DB (ini3_py_account, INI3Bill_DB and Pangya_S4_TH).
    If this was intended for me, and assuming I only had to make them and not change anything in the SQL, I've done this already. Thank you ntl. :3
  • 06-01-11
    Tsukasa
    Re: Unable to channel or Does not show channel. [help Me please].
    Don't rename, let the Management Studio create the CREATE script for it and change the table name, then run the script you get from it.
  • 06-01-11
    terrorofdeath
    Re: Unable to channel or Does not show channel. [help Me please].
    Quote:
    Originally Posted by Tsukasa View Post
    Don't rename, let the Management Studio create the CREATE script for it and change the table name, then run the script you get from it.
    If I had the energy, I would be jumping for joy. xD Thank you.

    There was some other little edits I had to make to the process, but I got the gist of the setup/fixing thing here. (And now it's working. :o)

    My dbo.TD_CHAR_EQUIP_S4 if it'll help someone:

    Code:
    USE [Pangya_S4_TH]
    GO
    /****** Object:  Table [dbo].[TD_CHAR_EQUIP_S4]    Script Date: 01/06/2011 16:54:07 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[TD_CHAR_EQUIP_S4](
            [UID] [int] NOT NULL,
            [ITEMID] [int] NULL,
            [SEQ] [int] IDENTITY(1,1) NOT NULL,
            [IN_DATE] [datetime] NOT NULL,
            [USE_YN] [char](1) NULL,
            [CHAR_ITEMID] [int] NULL,
            [EQUIP_NUM] [int] NOT NULL,
            [EQUIP_TYPE] [int] NULL,
            [TYPEID] [int] NOT NULL
    ) ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF
    Didn't know what "Typeid" was supposed to replace, so I just added it. -_-
  • 07-01-11
    mrNickname
    Re: Unable to channel or Does not show channel. [help Me please].
    That was fast, for you atleast, i've been working on that error for almost a week and overlooked the missing '_S4'. Now that code up there fixed my channels not being displayed problem.

    So there were only 2 errors in that repack one is Visa_Ref null table on 'INI3_PY_ACCOUNT' and TD_CHAR_EQUIP_S4 on 'Pangya_TH_S4' SQL.

    Your dbo.TD_CHAR_EQUIP_S4 did work however i searched TD_CHAR_EQUIP and seems like there are more then that line you posted, i added all with _S4 and that should be final..

    EDIT: Pardon my stupidity. Editing the SQL without proper knowledge is a bad idea.

    And for the addon, it seems like auto account creation can be done with the game client, any way to disable that?
  • 07-01-11
    terrorofdeath
    Re: Unable to channel or Does not show channel. [help Me please].
    Quote:
    Originally Posted by mrNickname View Post
    That was fast, for you atleast, i've been working on that error for almost a week and overlooked the missing '_S4'. Now that code up there fixed my channels not being displayed problem.

    EDIT: Pardon my stupidity. Editing the SQL without proper knowledge is a bad idea.
    Glad my solution helped. xD

    As for editing without knowledge, with the bits and pieces I've read here and a bit of playing around I'm learning it somewhat. Trying these things out isn't that bad of a way to learn SQL it seems (though it makes the confused really annoying, xD).