Mysql crash

[Berke58 94]

Hi devs any can help me? have in mysql crash syserr

 

SYSERR: Oct 15 07:04:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'is_gm' in 'field list' (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 10088, inet_aton('192.168.1.3'), '') errno: 1054)

...

[M.Sorin 276]

Try this:

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `loginlog2`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `is_gm` varchar(1) 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` varchar(11) DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `playtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=390511 DEFAULT CHARSET=latin1;

 

[Berke58 94]

Try this:

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `loginlog2`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog2`;
CREATE TABLE `loginlog2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `is_gm` varchar(1) 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` varchar(11) DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `logout_time` datetime DEFAULT NULL,
  `playtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=390511 DEFAULT CHARSET=latin1;

 

Thanks for ur reply, problem solved bro