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.. :(
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)
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;
Nyah egy kis magyar szöveget kapok mellé ? :Dmit hova? >< köszönöm
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 :D
De azt a kódot, hova másoljam? :D melyik lau ba? vagy merre? :/
navicat/log ott nyomd f6 oda bemásolod és enter.
köszi ^^