I only had to set this up once 2 years ago, now i cant remember how and cannot find the link I had that had all the extra info that the wiki doesnt tell you.
Code:
[Database] [04.07.15 - 17:00:40] Mysql query failed: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Pirates'
[World] [04.07.15 - 17:00:40] Server Pirates(Pirates) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Database] [04.07.15 - 17:00:40] Mysql query failed: SELECT max(ServerID) FROM tblWorldServerRegistration
[Database] [04.07.15 - 17:00:40] Mysql query failed: UPDATE tblWorldServerRegistration SET ServerLastLoginDate = now(), ServerLastIPAddr = '25.146.178.221', ServerLongName = 'Pirates' WHERE ServerID = 0
[Network] [04.07.15 - 17:01:07] New SoD client connection from 127.0.0.1:55036
[Network] [04.07.15 - 17:01:07] Application packet received from client (size 14)
[Network] [04.07.15 - 17:01:07] Session ready received from client.
[Network] [04.07.15 - 17:01:07] Application packet received from client (size 36)
[Network] [04.07.15 - 17:01:07] Login received from client.
[Client] [04.07.15 - 17:01:07] User: unknown
[Client] [04.07.15 - 17:01:07] Hash: 9d5e879bd11b359899ecd96719f33460f46ee2fd
[Database] [04.07.15 - 17:01:07] Mysql query failed: SELECT LoginServerID, AccountPassword FROM tblLoginServerAccounts WHERE AccountName = 'unknown'
[Client Error] [04.07.15 - 17:01:07] Error logging in, user unknown does not exist in the database.
EDIT Is it possible the problem is because i took a backup of a previous database, wiped it, then started new on there?
EDIT Now no accounts work lolol.