Log tábla hiba (K)

[djmester]

Sziasztok olyan gondom lenne , hogy ezt találtam a ch1 core1 syserr-be
Addig jutottem, és mondták páran , hogy log tábla hiba. de senkinek nincs ötlete-hogyan kéne javítani..

Kód Kijelölés Kibont

SYSERR: Dec 26 19:13:10 :: Process: SEQUENCE 290d0000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 19:13:10 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 19:26:58 :: Process: SEQUENCE 290cf000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 19:26:58 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 19:55:46 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 3901, 64819) errno: 1136)
SYSERR: Dec 26 20:30:19 :: Process: SEQUENCE 33068000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 20:30:19 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 20:35:47 :: Process: SEQUENCE 33068000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 20:35:47 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 20:39:31 :: Process: SEQUENCE 33068000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 20:39:31 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 20:55:45 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 171, 3) errno: 1136)
SYSERR: Dec 26 20:55:45 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 3901, 4) errno: 1136)
SYSERR: Dec 26 21:25:13 :: Process: SEQUENCE 290cf000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 21:25:13 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 21:28:56 :: Process: SEQUENCE 290cf000 mismatch 0xaf != 0x64 header 254
SYSERR: Dec 26 21:28:56 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Dec 26 21:55:43 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 3902, 213843) errno: 1136)
SYSERR: Dec 26 21:55:43 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 3902, 4) errno: 1136)
SYSERR: Dec 26 22:01:18 :: 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, 0, 0, 10002608, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Dec 26 22:01:38 :: 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, 1752, 0, 10002608, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Dec 26 22:01:39 :: 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, 59, 0, 10002608, 'SET_SOCKET', '', '', 72701) errno: 1054)


[DonNodus]

Kód Kijelölés Kibont

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(200) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT NULL,
  `hint` varchar(200) CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT NULL,
  `ip` varchar(30) COLLATE big5_bin DEFAULT NULL,
  `vnum` varchar(30) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

CREATE TABLE `money_log` (
  `time` time DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL,
  `nemtom` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;




[djmester]

Nyah egy kis magyar szöveget kapok mellé ? :Dmit hova? >< köszönöm

[bakura1998]

Ez amit DonNudos küldött az kód, ami létre hozza a táblázatot.

Az alá kellenek a query-k és utána elmenteni .sql-be és feltölteni navicatba

[djmester]

De azt a kódot, hova másoljam? melyik lau ba? vagy merre? :/

[Ken]

navicat/log ott nyomd f6 oda bemásolod és enter.

[djmester]

köszi ^^