ich hoffe bei diesem Fehler krieg ich mal irgendeine Antwort. Ich habe folgendes Problem:
Ich schlage ein Monster, kriege 2 - 3 Sekunden danach einen Kick.
In der Welt der Serverfiles bin ich noch etwas neu, deswegen weiß ich nicht wie ich den Fehler angehen soll.
Inhalt der Syserr nach Kick:
SYSERR: Apr 14 11:24:24 :: 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(), 57697, 472745, 954123, 5, 'GM_LOGIN', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:24 :: 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(), 57697, 472745, 954123, 0, 'LOGIN', '192.168.178.23 1213705908 1 1 200000', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:24 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57697, inet_aton('192.168.178.23'), '') errno: 1146)
SYSERR: Apr 14 11:24:24 :: 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, 0, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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(), 57697, 472899, 961681, 0, 'WARP', '[ADMIN]David MapIdx 1 DestMapIdx0 DestX391700 DestY1293100 Empire1', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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(), 57697, 472899, 961681, 0, 'LOGOUT', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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, 36, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:24:49 :: ItemLoad: cannot create item by vnum 99491 (name [ADMIN]David id 10000034)
SYSERR: Apr 14 11:24:49 :: ItemLoad: cannot create item by vnum 99191 (name [ADMIN]David id 10000037)
SYSERR: Apr 14 11:24:49 :: 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(), 57697, 391700, 1293100, 5, 'GM_LOGIN', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:49 :: 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(), 57697, 391700, 1293100, 0, 'LOGIN', '192.168.178.23 1213705908 1 202 200000', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:49 :: 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, 0, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:25:24 :: 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, 54, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:25:31 :: Process: SEQUENCE 3e468000 mismatch 0xcd != 0x54 header 7
SYSERR: Apr 14 11:25:31 :: Process: SEQUENCE_LOG [[ADMIN]David]-------------
[007 : 0xde]
[007 : 0x31]
[007 : 0x16]
[007 : 0xbb]
[007 : 0xeb]
[011 : 0x9e]
[007 : 0xc0]
[011 : 0x83]
[011 : 0x2e]
[011 : 0x3c]
[007 : 0xe]
[011 : 0x36]
[011 : 0xde]
[007 : 0xa2]
[061 : 0x56]
[011 : 0x86]
[011 : 0x80]
[007 : 0x32]
[011 : 0x82]
[011 : 0xe6]
[007 : 0xcd]
SYSERR: Apr 14 11:25:31 :: 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(), 57697, 380805, 1283861, 0, 'LOGOUT', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:25:31 :: 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, 53, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:24:24 :: 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(), 57697, 472745, 954123, 0, 'LOGIN', '192.168.178.23 1213705908 1 1 200000', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:24 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57697, inet_aton('192.168.178.23'), '') errno: 1146)
SYSERR: Apr 14 11:24:24 :: 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, 0, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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(), 57697, 472899, 961681, 0, 'WARP', '[ADMIN]David MapIdx 1 DestMapIdx0 DestX391700 DestY1293100 Empire1', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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(), 57697, 472899, 961681, 0, 'LOGOUT', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:47 :: 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, 36, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:24:49 :: ItemLoad: cannot create item by vnum 99491 (name [ADMIN]David id 10000034)
SYSERR: Apr 14 11:24:49 :: ItemLoad: cannot create item by vnum 99191 (name [ADMIN]David id 10000037)
SYSERR: Apr 14 11:24:49 :: 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(), 57697, 391700, 1293100, 5, 'GM_LOGIN', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:49 :: 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(), 57697, 391700, 1293100, 0, 'LOGIN', '192.168.178.23 1213705908 1 202 200000', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:24:49 :: 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, 0, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:25:24 :: 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, 54, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
SYSERR: Apr 14 11:25:31 :: Process: SEQUENCE 3e468000 mismatch 0xcd != 0x54 header 7
SYSERR: Apr 14 11:25:31 :: Process: SEQUENCE_LOG [[ADMIN]David]-------------
[007 : 0xde]
[007 : 0x31]
[007 : 0x16]
[007 : 0xbb]
[007 : 0xeb]
[011 : 0x9e]
[007 : 0xc0]
[011 : 0x83]
[011 : 0x2e]
[011 : 0x3c]
[007 : 0xe]
[011 : 0x36]
[011 : 0xde]
[007 : 0xa2]
[061 : 0x56]
[011 : 0x86]
[011 : 0x80]
[007 : 0x32]
[011 : 0x82]
[011 : 0xe6]
[007 : 0xcd]
SYSERR: Apr 14 11:25:31 :: 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(), 57697, 380805, 1283861, 0, 'LOGOUT', '', '192.168.178.23') errno: 1054)
SYSERR: Apr 14 11:25:31 :: 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, 53, 0, 10000135, 'SET_SOCKET', '', '', 70052) errno: 1054)
Grüße
RoleS
€: Server läuft auf 2500 MB RAM