Nach einem Reboot erschien folgender Fehler.
Ich hatte versucht die Logs wie Command_log einzusehen, es erschien ein Fehler, dass die Table nicht existiert.
Code:
SYSERR: Jul 25 19:38:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 19192, 0, 10000928, 'SET_SOCKET', '', '', 17029) errno: 1054) SYSERR: Jul 25 19:38:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 17305, 0, 10000929, 'SET_SOCKET', '', '', 16009) errno: 1054) SYSERR: Jul 25 19:38:37 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=4 AND pid=57724) errno: 1146) SYSERR: Jul 25 19:38:37 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146) SYSERR: Jul 25 19:38:37 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57724, 853294, 459008, 0, 'LOGOUT', '', '80.133.250.132') errno: 1054) SYSERR: Jul 25 19:38:37 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 49, 0, 10000091, 'SET_SOCKET', '', '', 72702) errno: 1054) SYSERR: Jul 25 19:38:50 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(57721, 999, '46.166.179.37', 1, 'Nexus', 'reload', NOW()) errno: 1146) SYSERR: Jul 25 19:38:55 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(57721, 999, '46.166.179.37', 1, 'Nexus', 'shutdown', NOW()) errno: 1146) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=1 AND pid=57721) errno: 1146) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57721, 53326, 169622, 0, 'LOGOUT', '', '46.166.179.37') errno: 1054) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 17011, 0, 10000931, 'SET_SOCKET', '', '', 14029) errno: 1054) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 17275, 0, 10000929, 'SET_SOCKET', '', '', 16009) errno: 1054) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 19162, 0, 10000928, 'SET_SOCKET', '', '', 17029) errno: 1054) SYSERR: Jul 25 19:38:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 20, 0, 10000048, 'SET_SOCKET', '', '', 72702) errno: 1054) SYSERR: Jul 25 19:39:31 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 25 19:56:02 :: socket_connect: HOST localhost:15000, could not connect.