xuehuiit / fabric-explorer

Fabric-explorer is a simple, powerful, maintainable, open source fabric explorer
http://www.blockchainbrother.com/
Apache License 2.0
123 stars 58 forks source link

mysql . 导入数据的时候~报错 #23

Open jicki opened 6 years ago

jicki commented 6 years ago
ERROR 1064 (42000) at line 39: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
  `createdt` datetime DEFAULT NULL,
  `remark` text,
  PRIMARY KEY (`id`)
) ENG' at line 11
-- ----------------------------
--  Table structure for `chaincodes`
-- ----------------------------
DROP TABLE IF EXISTS `chaincodes`;
CREATE TABLE `chaincodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `peer_name` varchar(32) DEFAULT NULL,
  `channelname` varchar(128) DEFAULT NULL,
  `name` varchar(256) DEFAULT NULL,
  `version` varchar(256) DEFAULT NULL,
  `path` varchar(256) DEFAULT NULL,
  `escc` varchar(32) DEFAULT NULL,
  `vscc` varchar(32) DEFAULT NULL,
  `txcount` int(11) DEFAULT '0' ,
  `ccstatus` varchar(32) DEFAULT NULL COMMENT ,
  `createdt` datetime DEFAULT NULL,
  `remark` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='chaincode';
`ccstatus` varchar(32) DEFAULT NULL COMMENT , 没有值
jicki commented 6 years ago

@qq690712575

`ccstatus` varchar(32) DEFAULT NULL COMMENT ,

这一段里面 COMMENT 没有赋值 你可以删除 COMMENT 就可以导入成功