Wie kann ich das fixxen

[.#Nion]

 Hilfe

SYSERR: Jun 14 07:20: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) VALUES('CHARACTER', NOW(), 57701, 957141, 255446, 5, 'GM_LOGIN', '', '') errno: 1054)
SYSERR: Jun 14 07:20: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) VALUES('CHARACTER', NOW(), 57701, 957141, 255446, 0, 'LOGIN', ' 0 1 41 0', '') errno: 1054)
SYSERR: Jun 14 07:20:38 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57701, inet_aton(''), '') errno: 1366)
SYSERR: Jun 14 07:20:52 :: 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, 22, 10, 10000023, 'SET_ATTR', '', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 1, 0, 10000023, 'SET_SOCKET', '', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000023, 'SYSTEM', 'Schwert+9', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 1, 0, 10000024, 'SET_SOCKET', '', '', 11209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000024, 'SYSTEM', 'Mönchsplattenpanzer+9', '', 11209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000025, 'SYSTEM', 'Traditioneller Helm+9', '', 12209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000026, 'SYSTEM', 'Roter Trank(G)', '', 27003) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000027, 'SYSTEM', 'Blauer Trank(G)', '', 27006) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 3000, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000028, 'SYSTEM', 'Windschuhe', '', 72702) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000029, 'SYSTEM', 'Geschwindigkeitstrank', '', 71050) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000030, 'SYSTEM', 'Tapferkeitsumhang', '', 70038) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000031, 'SYSTEM', 'Schlachtschild+9', '', 13009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000032, 'SYSTEM', 'Holzarmband+9', '', 14009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000033, 'SYSTEM', 'Lederschuhe+9', '', 15009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000034, 'SYSTEM', 'Holzhalskette+9', '', 16009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000035, 'SYSTEM', 'Holzohrringe+9', '', 17009) errno: 1054)
SYSERR: Jun 14 07:20:56 :: 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, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1054)

[.Karuzo]

Originally Posted by .#Nion

 Hilfe

SYSERR: Jun 14 07:20: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) VALUES('CHARACTER', NOW(), 57701, 957141, 255446, 5, 'GM_LOGIN', '', '') errno: 1054)
SYSERR: Jun 14 07:20: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) VALUES('CHARACTER', NOW(), 57701, 957141, 255446, 0, 'LOGIN', ' 0 1 41 0', '') errno: 1054)
SYSERR: Jun 14 07:20:38 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57701, inet_aton(''), '') errno: 1366)
SYSERR: Jun 14 07:20:52 :: 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, 22, 10, 10000023, 'SET_ATTR', '', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 1, 0, 10000023, 'SET_SOCKET', '', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000023, 'SYSTEM', 'Schwert+9', '', 19) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 1, 0, 10000024, 'SET_SOCKET', '', '', 11209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000024, 'SYSTEM', 'Mönchsplattenpanzer+9', '', 11209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000025, 'SYSTEM', 'Traditioneller Helm+9', '', 12209) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000026, 'SYSTEM', 'Roter Trank(G)', '', 27003) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000027, 'SYSTEM', 'Blauer Trank(G)', '', 27006) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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, 3000, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000028, 'SYSTEM', 'Windschuhe', '', 72702) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000029, 'SYSTEM', 'Geschwindigkeitstrank', '', 71050) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000030, 'SYSTEM', 'Tapferkeitsumhang', '', 70038) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000031, 'SYSTEM', 'Schlachtschild+9', '', 13009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000032, 'SYSTEM', 'Holzarmband+9', '', 14009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000033, 'SYSTEM', 'Lederschuhe+9', '', 15009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000034, 'SYSTEM', 'Holzhalskette+9', '', 16009) errno: 1054)
SYSERR: Jun 14 07:20:52 :: 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(), 57701, 957141, 255446, 10000035, 'SYSTEM', 'Holzohrringe+9', '', 17009) errno: 1054)
SYSERR: Jun 14 07:20:56 :: 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, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1054)

Hallo Nion,

deine Log scheint nicht vorhanden/beschädigt zu sein.
Führe folgende Query aus und der Fehler sollte behoben sein:

 Spoiler

PHP Code:

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `type` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `time` time DEFAULT NULL,
  `who` int(11) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `what` int(11) DEFAULT NULL,
  `how` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `hint` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `ip` text CHARACTER SET latin1,
  `vnum` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin; 


Mfg.

[Kampfzwerg!]

hättest du eine lösung für dieses Problem?

SYSERR: Jun 15 11:38:33 :: load: ANI directory = (null)
SYSERR: Jun 15 11:40:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'last_play' in 'field list'
query: UPDATE account SET last_play=NOW() WHERE id=787


SYSERR: Jun 15 11:38:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun 15 11:38:31 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist
query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry
SYSERR: Jun 15 11:38:31 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)


SYSERR: Jun 15 11:40:08 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 28159, 967759, 277727, 0, 'LOGIN', '192.168.178.30 898605 1 41 20841', '192.168.178.30') errno: 1406)
SYSERR: Jun 15 11:40:08 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 787, 28159, inet_aton('192.168.178.30'), '') errno: 1366)

SYSERR: Jun 15 11:41:02 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 28159, 956797, 269050, 0, 'LOGOUT', '192.168.178.30 898605 1 41 20841', '192.168.178.30') errno: 1406)

#edit

wen du irgendwelche querys von meiner datenbank brauchst bitte sagen^^