error on stored procedure persist!

[magraopb]

My error persist yet
new accounts can't connect on server, i already make this fix by chumpy, work only one day and return error

Ah this problem again. It is because of the mssql server language and date formats.

Find:

    -- Free time (everyday PM 21~22)
    DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
    SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) +  '21:00:00'
    SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
    IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and  GETDATE() < @EndFreeTime
    BEGIN
        SET @rType = 2
        SET @rExpireDate = @EndFreeTime
    END

Change to:

/*  ! WARNING ! Causes problems on some languages
    -- Free time (everyday PM 21~22)
    DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
    SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) +  '21:00:00'
    SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
    IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and  GETDATE() < @EndFreeTime
    BEGIN
        SET @rType = 2
        SET @rExpireDate = @EndFreeTime
    END
*/

Unless you use the "free time" premium setting this isn't used anyway ;)

My erros:

[Tue Apr 13 2010 00:04:34.000783 3075464080]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Tue Apr 13 2010 00:04:34.000870 3075464080]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Tue Apr 13 2010 00:04:34.000912 3075464080]: [##ERROR##] DB ERROR(CODE) : 242
[Tue Apr 13 2010 00:04:34.000943 3075464080]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Apr 13 2010 00:04:34.000973 3075464080]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Tue Apr 13 2010 00:04:34.001003 3075464080]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Tue Apr 13 2010 00:04:34.010615 3075464080]: Database Connect success!
[Tue Apr 13 2010 00:04:34.010663 3075464080]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Tue Apr 13 2010 00:04:34.010701 3075464080]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Tue Apr 13 2010 00:27:30.096478 3054484368]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Tue Apr 13 2010 00:27:30.096589 3054484368]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
[Tue Apr 13 2010 00:27:30.096633 3054484368]: [##ERROR##] DB ERROR(CODE) : 242
[Tue Apr 13 2010 00:27:30.096677 3054484368]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Apr 13 2010 00:27:30.096721 3054484368]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Tue Apr 13 2010 00:27:30.096763 3054484368]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Tue Apr 13 2010 00:27:30.108506 3054484368]: Database Connect success!
[Tue Apr 13 2010 00:27:30.108570 3054484368]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Tue Apr 13 2010 00:27:30.108611 3054484368]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

[MentaL]

[LostSpirit]

Well this error occurs when the hours/GMT, windows and linux are not synchronized.