Komischer Fehler in der Syserr

02/25/2012 15:09 .σяаĸз.#1
Hallo

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

Code:
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
.σяаĸз.
02/25/2012 20:51 .SoNiiC.#2
deine log tabelle ist nicht komplett. es fehlen ein paar spalten
02/25/2012 21:22 .σяаĸз.#3
Quote:
Originally Posted by .SoNiiC. View Post
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
.σяаĸз.
02/25/2012 22:08 Mashkin#4
Code:
ALTER TABLE log.log
ADD COLUMN 'vnum' int NULL AFTER 'ip';
Sollte funktionieren...
02/26/2012 05:27 .SoNiiC.#5
probiere mal diese hier :)
02/26/2012 12:48 .σяаĸз.#6
Quote:
Originally Posted by M@shkin View Post
Code:
ALTER TABLE log.log
ADD COLUMN 'vnum' int NULL AFTER 'ip';
Sollte funktionieren...
Danke, aber funktioniert nicht.
Quote:
Originally Posted by .SoNiiC. View Post
probiere mal diese hier :)
Vielen Dank klappt ;)