disconnected - ERROR 0

11/27/2011 00:00 tracker62#1
hello the server is running green arrow I change the password of Shaiya shaiya123 and I run the game it says server with has-been disconnected - ERROR 0

bonjour le serveur fonctionne fleche verte j'ai changer le mot passe de Shaiya shaiya123 et je lance le game sa me dit with server has been disconnected - ERROR 0


:confused:
11/27/2011 00:50 JohnHeatz#2
1- Check that you successfully changed the PW on every needed file
2- Check the created logs to be able to notice where is that you are having issues
11/27/2011 01:20 tracker62#3
2011-11-27 00:57:10 PS_USERLOG__system log start (UserLog)

2011-11-27 00:57:12 connect

2011-11-27 00:57:18 connect

2011-11-27 00:57:19 connect

2011-11-27 01:18:15 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2011-11-27 01:18:15 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 6,3383914757248516097,104,'1236'

2011-11-27 01:18:15 VerifyReConnect : The Connection has been lost, SQLHDBC=af89f0

2011-11-27 01:18:15 SDatabasePool::Reconnect:: success...

__________________________________________________ _____
2011-11-27 00:57:18 PS_LOGIN__system log start (Login01)

2011-11-27 00:59:25 <Console input> /vchkoff

2011-11-27 00:59:25 <Console output> cmd version chk off ok

2011-11-27 01:17:57 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2011-11-27 01:17:57 SDatabase::GetErrorMsg:: disconnected...

2011-11-27 01:17:57 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','ADMIN123', 3383914679939104769,'83.152.163.35', [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Erreur réseau générale. Consultez la documentation relative à votre réseau., SQL STATE: 08S01, NATIVE ERROR: 11 (0xB)

2011-11-27 01:17:57 SDatabasePool::Reconnect:: success...
11/27/2011 08:24 Da Boss#4
usp_Try_GameLogout_R

Find this Stored Procedure, and fix the problem, normally it will have something like Db.Ps_GameDefs instead of the real table, and stuff like that, :)
11/27/2011 10:07 RakiReid#5
Quote:
Originally Posted by Da Boss View Post
usp_Try_GameLogout_R

Find this Stored Procedure, and fix the problem, normally it will have something like Db.Ps_GameDefs instead of the real table, and stuff like that, :)
Da Boss is correct you also need to make sure you change the password database side as well