[Help]Syserr

Chip' · 01/13/2013, 01:36

Hay Leute in meiner Syserr steht.

Code:

SYSERR: Jan 12 17:42:42 :: 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(), 57714, 57908, 168100, 0, 'LOGIN', 'xxx 652340920 1 21 16778', 'xxx') errno: 1054)
SYSERR: Jan 12 17:42:42 :: 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, 10000141, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 12 17:43:13 :: 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(), 0, 66, 0, 10001809, 'SET_SOCKET', '', '', 50300) errno: 1054)
SYSERR: Jan 12 17:43:16 :: 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(), 57714, 58379, 166793, 10001809, 'GET', 'Fertigkeitsbuch 1 50300', 'xxx', 50300) errno: 1054)
SYSERR: Jan 12 17:43:23 :: 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(), 57729, 57516, 167046, 5, 'GM_LOGIN', '', 'xxx') errno: 1054)
SYSERR: Jan 12 17:43:23 :: 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(), 57729, 57516, 167046, 0, 'LOGIN', 'xxx 0 1 21 300000', 'xxx') errno: 1054)
SYSERR: Jan 12 17:43:23 :: 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, 10001703, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jan 12 17:43:23 :: 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(), 57714, 58379, 166793, 8027, 'STONE_KILL', '1 21', 'xxx) errno: 1054)
SYSERR: Jan 12 17:43:36 :: 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, 1652, 0, 10001703, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jan 12 17:43:38 :: 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, 1606, 0, 10000141, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jan 12 17:43:39 :: 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(), 57729, 58386, 167010, 2315, 'DEAD_BY_NPC', 'Roter böser Baum', 'xxx') errno: 1054)
SYSERR: Jan 12 17:43:45 :: 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(), 57714, 58379, 166793, 2, 'USE_ITEM', 'Segen des Drachen 28', 'xxx', 71020) errno: 1054)
SYSERR: Jan 12 17:43:50 :: 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(), 57729, 58257, 166904, 80, 'USE_ITEM', 'Segen des Drachen 111', 'xxx', 71020) errno: 1054)
SYSERR: Jan 12 17:43:53 :: 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(), 57714, 58811, 166970, 8027, 'STONE_KILL', '1 21', 'xxx') errno: 1054)
SYSERR: Jan 12 17:43:53 :: 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(), 0, 66, 0, 10001813, 'SET_SOCKET', '', '', 50300) errno: 1054)
SYSERR: Jan 12 17:43:53 :: 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(), 57714, 58811, 166970, 8027, 'STONE_KILL', '1 21', 'xxx') errno: 1054)
SYSERR: Jan 12 17:44:00 :: 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(), 57714, 58811, 166970, 10001812, 'GET', 'Morsche Holzkiste 1 50124', 'xxx', 50124) errno: 1054)

xxx war eine IP die hab ich natürlich rausgenommen :P
Weiß jemand wie ich das weg bekomme.
Bis jetzt stört mich das nicht weiter, aber das müllt mir die syserr zu, in ca 3-4 Stunden 1800 Zeilen in meiner Syserr

Für jede Hilfreiche antwort gibts natürlich nen Thanks.
Gruß Verifizierung

Mashkin · 01/13/2013, 06:35

Deine Log-Tabelle hat keine IP-Spalte.

Die Query fügt die Spalte hinzu:

Code:

ALTER TABLE log.log ADD COLUMN ip varchar (15) AFTER hint;

Ich würde dir empfehlen, die Log-Tabelle regelmäßig zu leeren. Bei einem gut besuchten Server kommt man schonmal auf über 1 Mio. Einträge in 1-2 Tagen.