some weird problem with sql

hello RZ

i have ran into a problem i havent encountered before.

[Wed Oct 6 2010 01:06:41.368195 3034426272]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Wed Oct 6 2010 01:06:41.368234 3034426272]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Difference of two datetime columns caused overflow at runtime.
[Wed Oct 6 2010 01:06:41.368252 3034426272]: [##ERROR##] DB ERROR(CODE) : 535
[Wed Oct 6 2010 01:06:41.368269 3034426272]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 6 2010 01:06:41.368285 3034426272]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Wed Oct 6 2010 01:06:41.368316 3034426272]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Wed Oct 6 2010 01:06:41.373335 3034426272]: Database Connect success!
[Wed Oct 6 2010 01:06:41.373360 3034426272]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Wed Oct 6 2010 01:06:41.373412 3034426272]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

this is from globaldbagent.log

if this was at the begining of setting everything up i wouldnt be surprised, but i have had my server runing for over 1 year and i had never seen this problem. i searched a bit around the forums but every thread i encountered this problem was unsolved or unclear.

i use mssql 2000.

it seems i can still use whatever info i have on my db, i just cant insert and use any new i try to add at the moment. if i try to add a new account for example, it wont add it and i wont be able to log on it.

i would like getting a clear solution on what to do to fix this :thumbup:

p.s all my other logs are error free.

Difference of two datetime could be caused by a difference between your Game Server and your SQL Server time. It can cause a failure in the calculation of the dates.

or Try THIS...

as i specified on my post, this is a new error, on a server+db that is over 1 year old, and without any new changes as of late. i did not change anything date-time related and it always worked just fine. i have no clue why this actualy started happening now..

p.s can anyone tell me how to change the date/time of the server anyways? centos 4.7

A quick google found me this:

Quote:

---

To set the date/time:

$ sudo date MMDDhhmmYYYY

Example:

$ sudo date 043017212008

(that is the time of my posting)

MM - Two digit month number
DD - Two digit date
hh - Two digit 24 hour system hour
mm - Two digit minute
YYYY - Four digit year code

---

For the other issue i *think* it is going to be the same as the one below. That one usually affects Brazilian languages and can randomly show up after the server has been running for quite a long time.

http://forum.ragezone.com/f451/urgent-please-685761/

centos time is now exactly the same as windows, and i made what you sugested in the other thread, but still the same error occurs and new accounts still dont work.

any more sugestions?

If you use sql2000 then you have a profiler. I hope you know how to use it like all good SQL admins should. It is your best friend ;)

You need to configure the profiler to check cabal_sp_auth stored procedure and run it. Now try causing the bug a few times and check what shows up in the profiler. You can see the exact data going into cabal_sp_auth and recreate the problem to figure out why it happens. I will need this data to solve it if you can't after seeing the data (PM if you don't want to post sensitive data).

check your pms chumpy