Chumpys GMtool

[50roller]

Hi guys i have a problem with the GM tool from Chumpy if i'm trying to create an Account i get an error

Dublicate Row. Player already Exist?

thats the error.

i'm using MSSQL 2005, chumpy's GMTools v0.62a

i tryed to use anouther name and pw but no one works pls help guys

thx

[EDIT]
I found a post from Chumpy
I have had another report of this from somebody else on my server. They got the exact same error, yet when i ran the tools on the db server itself and added the exact same details it worked which was a bit weird.

I'm going to add some more checks to that function tonight and do some testing to see if i can work it out. I'll update later once i know more.

EDIT: I know what is causing this now. There is a weird date/time format bug causing it. If you play around with your date/time format and get both machines to match you can get around it for now until i can fix it.


What doe you mean with both Machines do you mean the Linux and the windows? or what
__________________

[MentaL]

[chumpywumpy]

There are 2 possible causes of that error in the 0.6x tools. One is xp_md5 not working and so passwords get encoded to an empty string which the server will not accept and the other is date/time formats and the second one is harder to pin down without me testing the same exact settings.

First run the query below on sql:

select account.dbo.fn_md5('test')

If you get "NULL" back then xp_md5 is the problem not the date format (very few date formats cause problems). The fix below is the easiest one and works on 32 or 64-bit, but only on sql 2005 or later.

http://forum.ragezone.com/f459/fix-l...64-dll-608699/

[50roller]

ok Problem solved thx now everything works =)