[RELEASE]correct errors in DB (goldlog, cube, etc..)

pis30xd · 10/15/2012, 00:48

Gold log error:

Code:

SYSERR: Oct 14 22:30:23 :: ChildLoop: AsyncSQL: query failed: Table 'log.goldlog' doesn't exist (query: INSERT DELAYED INTO goldlog (date, time, pid, what, how, hint) VALUES(CURDATE(), CURTIME(), 58399, 70583267, 'BUY', '') errno: 1146)

Solution:

Code:

DROP TABLE IF EXISTS `goldlog`;
CREATE TABLE `goldlog` (
  `pid` int(50) DEFAULT NULL,
  `date` date NOT NULL,
  `time` datetime NOT NULL,
  `what` varchar(50) CHARACTER SET latin1 NOT NULL,
  `how` varchar(50) CHARACTER SET latin1 NOT NULL,
  `hint` varchar(50) CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Cube error:

Code:

SYSERR: Oct 14 22:15:12 :: ChildLoop: AsyncSQL: query failed: Unknown column 'x' in 'field list' (query: INSERT DELAYED INTO cube (pid, time, x, y, item_vnum, item_uid, item_count, success) VALUES(58354, NOW(), 967746, 265564, 50801, 70582126, 1, 1) errno: 1054)

Solution:

Code:

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;

I hope I helped!

'oShet · 10/15/2012, 17:12

Do you have for command_log?
I dont know but for me it doesnt really work..

Code:

ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'command_log' (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(57701, 999, '127.0.0.1', 1, '[SA]Admin', 'n [SA]Admin ist Online', NOW())  errno: 1616)

iSouli~ · 10/15/2012, 17:26

Quote:

Originally Posted by 'oShet

Do you have for command_log?
I dont know but for me it doesnt really work..

Code:

ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'command_log' (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(57701, 999, '127.0.0.1', 1, '[SA]Admin', 'n [SA]Admin ist Online', NOW())  errno: 1616)

Code:

CREATE TABLE `command_log` (
  `userid` int(11) DEFAULT NULL,
  `server` int(11) DEFAULT NULL,
  `ip` text,
  `port` int(11) DEFAULT NULL,
  `username` varchar(12) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
  `command` varchar(20) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1

thespeedyy · 10/15/2012, 19:25

SYSERR: Oct 15 18:21:55 :: ChildLoop: AsyncSQL: query failed: Unknown column 'logout_time' in 'field list' (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1054)
^\\\

pis30xd · 10/15/2012, 21:21

Code:

DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` text,
  `is_gm` int(11) DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  `channel` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `client_version` text,
  `ip` text,
  `logout_time` datetime DEFAULT NULL,
  `playtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14102 DEFAULT CHARSET=latin1;

" id=@i" WTF??