Account Creating Problem - Not Accepting NULL

Results 1 to 4 of 4
  1. #1
    Enthusiast Zemu is offline
    MemberRank
    Feb 2009 Join Date
    47Posts

    Account Creating Problem - Not Accepting NULL

    Hello RaGEZONE,

    Edit: Okay I´ve done it with VMWare Player 3.0.0.

    Now I´ve got another Problem, while making an Account.

    I´ve made a new Query for ACCOUNT Database. I typed the command for new Account, but became this Error:

    -----
    Meldung 515, Ebene 16, Status 2, Prozedur cabal_tool_registerAccount, Zeile 10
    Der Wert NULL kann in die 'Password'-Spalte, 'ACCOUNT.dbo.cabal_auth_table'-Tabelle nicht eingefügt werden. Die Spalte lässt NULL-Werte nicht zu. Fehler bei INSERT.
    Die Anweisung wurde beendet.
    Meldung 515, Ebene 16, Status 2, Prozedur cabal_tool_registerAccount, Zeile 16
    Der Wert NULL kann in die 'UserNum'-Spalte, 'ACCOUNT.dbo.cabal_charge_auth'-Tabelle nicht eingefügt werden. Die Spalte lässt NULL-Werte nicht zu. Fehler bei INSERT.
    Die Anweisung wurde beendet.

    (1 Zeile(n) betroffen)
    -----

    It means, that it doesn´t accept NULL (ZERO , 0) in dbo.cabal_auth_table and dbo.cabal_charge_auth .

    I went into the cabal_auth_table and set the ACCEPT NULL point to YES instead NO.
    I could create Account, with the Command, but not with GM Tool. In the Password row still was NULL. I connected and it said: Acc Name or Password wrong. I Changed the Password Row manually from NULL to my password and tried connecting again. Now it fails to connect the server. Anyone got any idea?
    Last edited by Zemu; 06-01-10 at 11:45 AM.


  2. #2
    Novice ButtCabal is offline
    MemberRank
    Jan 2010 Join Date
    1Posts

    Re: Account Creating Problem - Not Accepting NULL

    Here are the Logfiles in a rar Data: http://uploaded.to/file/s02z0y

    We turned off Services
    Deleted Logs
    Started Services
    Tried to logged in 5 times
    Copied Logs

  3. #3
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,517Posts

    Re: Account Creating Problem - Not Accepting NULL

    You forgot to add xp_md5.dll or you didn't add it correctly.

  4. #4
    Enthusiast Zemu is offline
    MemberRank
    Feb 2009 Join Date
    47Posts

    Re: Account Creating Problem - Not Accepting NULL

    AAAAH now it works! I got it :)

    Used this:

    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    go

    ALTER FUNCTION [dbo].[fn_md5] (@data varchar(255))
    RETURNS CHAR(32) AS
    BEGIN
    return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @data)), 3, 32)
    END


    And now it is no problem.
    Thank you for your Reply, anyone can close it now.



Advertisement