Hello,

I have helbound server running on COEP and I have problem with characters on accounts.

When I log in to server, I can't see any char, when I trying to make new, I got message "Name alredy exist" (I tried many names)

When I look to db, I see that characters are created.

In CacheD server I have this:

07/27/2011 20:35:17.572, Error sql: EXEC lin_GetUserDataByCharId 1 (0)
07/27/2011 20:35:17.573, Error 42S22:[Microsoft][sql Native Client][sql Server]Invalid column name 's37'.
07/27/2011 20:35:17.573, [.\User.cpp][4243] undefined (or unregistered) char Id[1]
07/27/2011 20:35:17.573, --- call stack ---
07/27/2011 20:35:17.573, [0] void IOThread_common(void *arglist)
07/27/2011 20:35:17.573, [1] static bool CreateCharacterPacket(CSocket* pSocket, const unsigned char* packet)
07/27/2011 20:35:17.573, [2] CUserSP CUserDb::GetUser(int nUserId, bool bLoadIfNotExist)
07/27/2011 20:35:37.226, Error sql: EXEC lin_GetUserDataByCharId 2 (0)
07/27/2011 20:35:37.226, Error 42S22:[Microsoft][sql Native Client][sql Server]Invalid column name 's37'.
07/27/2011 20:35:37.226, [.\User.cpp][4243] undefined (or unregistered) char Id[2]
07/27/2011 20:35:37.226, --- call stack ---
07/27/2011 20:35:37.226, [0] void IOThread_common(void *arglist)
07/27/2011 20:35:37.226, [1] static bool CreateCharacterPacket(CSocket* pSocket, const unsigned char* packet)
07/27/2011 20:35:37.226, [2] CUserSP CUserDb::GetUser(int nUserId, bool bLoadIfNotExist)
07/27/2011 20:35:44.623, Error sql: EXEC lin_GetUserDataByCharId 3 (0)
07/27/2011 20:35:44.623, Error 42S22:[Microsoft][sql Native Client][sql Server]Invalid column name 's37'.
07/27/2011 20:35:44.623, [.\User.cpp][4243] undefined (or unregistered) char Id[3]
07/27/2011 20:35:44.623, --- call stack ---

 

Anybody know, what I need to change to make it correct? Thx for advices.

had something like that on off server. restarted and i was able to see chars again.

had something like that on off server. restarted and i was able to see chars again.

hmm restart didn't help, I think it could be some wrong sql, but I don't know, because it's downloaded from coep and that should be ok, I know many servers on coep which works ok and they didn't change anything...