Hello every one, i have problem with game 34 when i upgrade some item in game i have lang and my server is shut down the problem in syserr is
SYSERR: Mar 22 19:23:32 :: ChildLoop: AsyncSQL: query failed: Unknown column 'success' in 'field list' (query: INSERT DELAYED INTO cube (pid, time, x, y, item_vnum, item_uid, item_count, success) VALUES(57715, NOW(), 64639, 166696, 50802, 10002323, 1, 1) errno: 1054)
i have in table "succes" no "success" :/ but i cant change it, i delete table cube and when i want to make new table i have error .
its query :
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
`pid` int(50) DEFAULT NULL,
`time` varchar(50) COLLATE big5_bin NOT NULL DEFAULT 'SEMTEMPO',
`x` varchar(50) COLLATE big5_bin NOT NULL,
`y` varchar(50) COLLATE big5_bin NOT NULL,
`item_vnum` varchar(50) COLLATE big5_bin NOT NULL,
`item_uid` varchar(50) COLLATE big5_bin NOT NULL,
`item_count` varchar(50) COLLATE big5_bin NOT NULL,
`success` varchar(50) COLLATE big5_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;
and it's error
[Err] 1005 - Can't create table 'cube' (errno: 13)
but on other data base, this query working in 100% , but i dont know why :/
I'm waiting for answer, greet !!!