Re: (1062) Duplicate entry '' for key '*UNKNOWN*'
Posted by:
James Yu
Date: August 05, 2014 04:13PM
Here is more information:
"result of SELECT Version()":
5.6.15-ndb-7.3.4-cluster-gpl
"SHOW CREATE TABLE" for all the included tables:
CREATE TABLE `pre_common_task` (
`taskid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
`relatedtaskid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`available` TINYINT(1) NOT NULL DEFAULT '0',
`name` VARCHAR(50) NOT NULL DEFAULT '',
`description` TEXT NOT NULL,
`icon` VARCHAR(150) NOT NULL DEFAULT '',
`applicants` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`achievers` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`tasklimits` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`applyperm` TEXT NOT NULL,
`scriptname` VARCHAR(50) NOT NULL DEFAULT '',
`starttime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`endtime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`period` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`periodtype` TINYINT(1) NOT NULL DEFAULT '0',
`reward` ENUM('credit','magic','medal','invite','group') NOT NULL DEFAULT 'credit',
`prize` VARCHAR(15) NOT NULL DEFAULT '',
`bonus` INT(10) NOT NULL DEFAULT '0',
`displayorder` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`version` VARCHAR(15) NOT NULL DEFAULT '',
PRIMARY KEY (`taskid`)
)
COLLATE='utf8_general_ci'
ENGINE=ndbcluster
AUTO_INCREMENT=38;
CREATE TABLE `pre_forum_medallog` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`medalid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`type` TINYINT(1) NOT NULL DEFAULT '0',
`dateline` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`expiration` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`status` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
INDEX `type` (`type`),
INDEX `status` (`status`, `expiration`),
INDEX `uid` (`uid`, `medalid`, `type`),
INDEX `dateline` (`dateline`)
)
COLLATE='utf8_general_ci'
ENGINE=ndbcluster
AUTO_INCREMENT=16534;
CREATE TABLE `pre_common_mytask` (
`uid` MEDIUMINT(8) UNSIGNED NOT NULL,
`username` CHAR(36) NOT NULL DEFAULT '',
`taskid` SMALLINT(6) UNSIGNED NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT '0',
`csc` CHAR(255) NOT NULL DEFAULT '',
`dateline` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`dateline_take` INT(10) UNSIGNED NULL DEFAULT NULL,
`dateline_done` INT(10) UNSIGNED NULL DEFAULT NULL,
`dateline_reward` INT(10) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`uid`, `taskid`),
INDEX `parter` (`taskid`, `dateline`)
)
COLLATE='utf8_general_ci'
ENGINE=ndbcluster;
CREATE TABLE `pre_common_member_count` (
`uid` MEDIUMINT(8) UNSIGNED NOT NULL,
`extcredits1` INT(10) NOT NULL DEFAULT '0',
`extcredits2` INT(10) NOT NULL DEFAULT '0',
`extcredits3` INT(10) NOT NULL DEFAULT '0',
`extcredits4` INT(10) NOT NULL DEFAULT '0',
`extcredits5` INT(10) NOT NULL DEFAULT '0',
`extcredits6` INT(10) NOT NULL DEFAULT '0',
`extcredits7` INT(10) NOT NULL DEFAULT '0',
`extcredits8` INT(10) NOT NULL DEFAULT '0',
`friends` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`posts` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`threads` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`digestposts` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`doings` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`blogs` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`albums` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`sharings` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`attachsize` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`views` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`oltime` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`todayattachs` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`todayattachsize` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`feeds` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`follower` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`following` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`newfollower` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`blacklist` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`photos` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`share` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`bestanswer` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`survey` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`event` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`archived` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '精華文',
`referralfriend` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '推薦朋友註冊',
`login` MEDIUMINT(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
INDEX `posts` (`posts`)
)
COLLATE='utf8_general_ci'
ENGINE=ndbcluster;