And using straight db_dump.sql the end result is inability to see servers again. If I import the updates in the /sql/svn repo I can again see my server and log in, but right back to the original issue.
login log file (appeared with the error prior to update)
Code:
[Debug] [09.11.11 - 06:29:59] Logging System Init.
[Debug] [09.11.11 - 06:29:59] Config System Init.
[Debug] [09.11.11 - 06:29:59] MySQL Database Init.
[Debug] [09.11.11 - 06:29:59] Encryption Initialize.
[Debug] [09.11.11 - 06:29:59] Encryption Loaded Successfully.
[Debug] [09.11.11 - 06:29:59] Server Manager Initialize.
[Network] [09.11.11 - 06:29:59] ServerManager listening on port 5999
[Debug] [09.11.11 - 06:29:59] Client Manager Initialize.
[Network] [09.11.11 - 06:29:59] ClientManager listening on Titanium stream.
[Network] [09.11.11 - 06:29:59] ClientManager listening on SoD stream.
[Debug] [09.11.11 - 06:29:59] Server Started.
[Network] [09.11.11 - 06:30:06] New world server connection from 127.0.0.1:50299
[Database] [09.11.11 - 06:30:06] 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.ServerLongName = 'Reign of Anarchy' AND WSR.ServerShortName = 'RoA PvP'
[World] [09.11.11 - 06:30:06] Server Reign of Anarchy(RoA PvP) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Database] [09.11.11 - 06:30:06] Mysql query failed: INSERT INTO tblWorldServerRegistration SET ServerID = 2, ServerLongName = 'Reign of Anarchy', ServerShortName = 'RoA PvP', ServerListTypeID = 3, ServerAdminID = 0, ServerTrusted = 0, ServerTagDescription = ''
[Network] [09.11.11 - 06:30:23] World server disconnected from the server, removing server and freeing connection.