Jump to content
×
×
  • Create New...
  • 0

Mysql crash


Berke58

Question

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)

...

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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;

 

  • Love 2
Link to comment
Share on other sites

  • 0

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 :)

  • Love 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.