Komischer Fehler in der Syserr

[.σяаĸз.]

Hallo

ich wollte mir gerade mal die Syserr ziehen und dort sehe ich einen komischen Fehler der mehrmals auftritt.

SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000072, 'SET_SOCKET', '', '', 11269) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1, 0, 10000072, 'SET_SOCKET', '', '', 11269) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 10000072, 'SET_SOCKET', '', '', 11269) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 57712, 957081, 264834, 10000072, 'GM', 'Schuppenplattenpanzer+9', '5.***.***.***', 11269) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000073, 'SET_SOCKET', '', '', 11279) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1, 0, 10000073, 'SET_SOCKET', '', '', 11279) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 10000073, 'SET_SOCKET', '', '', 11279) errno: 1054)
SYSERR: Feb 25 15:02:05 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 57712, 957081, 264834, 10000073, 'GM', 'Gold-Plattenpanzer+9', '5.***.***.***', 11279) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 24, 1, 10000074, 'SET_ATTR', '', '', 11289) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 23, 2, 10000074, 'SET_ATTR', '', '', 11289) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000074, 'SET_SOCKET', '', '', 11289) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1, 0, 10000074, 'SET_SOCKET', '', '', 11289) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 10000074, 'SET_SOCKET', '', '', 11289) errno: 1054)
SYSERR: Feb 25 15:02:06 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 57712, 957081, 264834, 10000074, 'GM', 'Drachengott-Panzer+9', '5.***.***.***', 11289) errno: 1054)
SYSERR: Feb 25 15:02:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000075, 'SET_SOCKET', '', '', 11299) errno: 1054)
SYSERR: Feb 25 15:02:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1, 0, 10000075, 'SET_SOCKET', '', '', 11299) errno: 1054)
SYSERR: Feb 25 15:02:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 10000075, 'SET_SOCKET', '', '', 11299) errno: 1054)
SYSERR: Feb 25 15:02:07 :: ChildLoop: AsyncSQL: query failed: Unknown column 'vnum' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 57712, 957081, 264834, 10000075, 'GM', 'Schwarzstahl-Panzer+9', '5.***.***.***', 11299) errno: 1054)

Vielleicht weiß jemand woran dies liegt, oder ob es überhaupt ein Fehler ist.

Mit freundlichen Grüßen
.σяаĸз.

[.SoNiiC.]

deine log tabelle ist nicht komplett. es fehlen ein paar spalten

[.σяаĸз.]

Originally Posted by .SoNiiC.

deine log tabelle ist nicht komplett. es fehlen ein paar spalten

Danke, würdest du mir deine sql schicken falls du einen Server hast?

Mit freundlichen Grüßen
.σяаĸз.

[Mashkin]

ALTER TABLE log.log
ADD COLUMN 'vnum' int NULL AFTER 'ip';

Sollte funktionieren...

[.SoNiiC.]

probiere mal diese hier

[.σяаĸз.]

Originally Posted by M@shkin

ALTER TABLE log.log
ADD COLUMN 'vnum' int NULL AFTER 'ip';

Sollte funktionieren...

Danke, aber funktioniert nicht.

Originally Posted by .SoNiiC.

probiere mal diese hier

Vielen Dank klappt