Login Server Error
 

I've been fighting with this login server for several days now. I just saw an error that makes me suspect there is a typo in the sql that is embedded in the code.

The error message replies to 'tblloginlerveraccounts'. NO I DID NOT MISTYPE THIS!

To test this, I did a simple test. I duplicated the 'tblloginserveraccounts' table and renamed it 'tblloginlerveraccounts'. Guess what? IT WORKS!

This may explain why a lot of people have been having problems with the login server lately...

Riklin (HallsHavoc)

Here is the excerpt from the login log...

[Debug] [02.10.15 - 18:33:59] Logging System Init.
[Debug] [02.10.15 - 18:33:59] Config System Init.
[Debug] [02.10.15 - 18:33:59] MySQL Database Init.
[Debug] [02.10.15 - 18:33:59] Encryption Initialize.
[Debug] [02.10.15 - 18:33:59] Encryption Loaded Successfully.
[Debug] [02.10.15 - 18:33:59] Server Manager Initialize.
[Network] [02.10.15 - 18:33:59] ServerManager listening on port 5998
[Debug] [02.10.15 - 18:33:59] Client Manager Initialize.
[Network] [02.10.15 - 18:33:59] ClientManager listening on Titanium stream.
[Network] [02.10.15 - 18:33:59] ClientManager listening on SoD stream.
[Debug] [02.10.15 - 18:33:59] Server Started.
[Network] [02.10.15 - 18:34:00] New world server connection from 127.0.0.1:1299
[World] [02.10.15 - 18:34:00] Server Welcome to the Hall Brothers Sanitarium!(HallsHavocTest) successfully logged in.
[Network] [02.10.15 - 18:34:47] New SoD client connection from 127.0.0.1:56364
[Network] [02.10.15 - 18:34:47] Application packet received from client (size 14)
[Network] [02.10.15 - 18:34:47] Session ready received from client.
[Network] [02.10.15 - 18:34:47] Application packet received from client (size 36)
[Network] [02.10.15 - 18:34:47] Login received from client.
[Client] [02.10.15 - 18:34:47] User: ricktest2
[Client] [02.10.15 - 18:34:47] Hash: fe0c9562654f1aa5c1f5808261b2095043a38688
[Database] [02.10.15 - 18:34:47] Mysql query failed: SELECT LoginServerID, AccountPassword FROM tblloginlerveraccounts WHERE AccountName = 'ricktest2'
[Client Error] [02.10.15 - 18:34:47] Error logging in, user ricktest2 does not exist in the database.

Um... This was my fault, not a code error. Its getting the table name from the login.ini and I misstyped the table name there...

/e embarrassed


Riklin