数据库转存出错
[Err] 1291 – Column ‘nature’ has duplicated value ‘婆婆妈妈’ in SET
[Err] CREATE TABLE `dede_member_person` (
`mid` mediumint(8) unsigned NOT NULL default ‘0’,
`onlynet` tinyint(1) unsigned NOT NULL default ‘1’,
`sex` enum(‘男’,’女’,’保密’) NOT NULL default ‘男’,
`uname` char(30) NOT NULL default ”,
`qq` char(12) NOT NULL default ”,
`msn` char(50) NOT NULL default ”,
`tel` varchar(15) NOT NULL default ”,
`mobile` varchar(15) NOT NULL default ”,
`place` smallint(5) unsigned NOT NULL default ‘0’,
`oldplace` smallint(5) unsigned NOT NULL default ‘0’,
`birthday` date NOT NULL default ‘1980-01-01’,
`star` smallint(6) unsigned NOT NULL default ‘1’,
`income` smallint(6) NOT NULL default ‘0’,
`education` smallint(6) NOT NULL default ‘0’,
`height` smallint(5) unsigned NOT NULL default ‘160’,
`bodytype` smallint(6) NOT NULL default ‘0’,
`blood` smallint(6) NOT NULL default ‘0’,
`vocation` smallint(6) NOT NULL default ‘0’,
`smoke` smallint(6) NOT NULL default ‘0’,
`marital` smallint(6) NOT NULL default ‘0’,
`house` smallint(6) NOT NULL default ‘0’,
`drink` smallint(6) NOT NULL default ‘0’,
`datingtype` smallint(6) NOT NULL default ‘0’,
`language` set(‘普通话’,’上海话’,’广东话’,’英语’,’日语’,’韩语’,’法语’,’意大利语’,’德语’,’西班牙语’,’俄语’,’阿拉伯语’) default NULL,
`nature` set(‘性格外向’,’性格内向’,’活泼开朗’,’豪放不羁’,’患得患失’,’冲动’,’幽默’,’稳重’,’轻浮’,’沉默寡言’,’多愁善感’,’时喜时悲’,’附庸风雅’,’能说会道’,’坚强’,’脆弱’,’幼稚’,’成熟’,’快言快语’,’损人利己’,’狡猾善变’,’交际广泛’,’优柔寡断’,’自私’,’真诚’,’独立’,’依赖’,’难以琢磨’,’悲观消极’,’郁郁寡欢’,’胆小怕事’,’乐观向上’,’任性’,’自负’,’自卑’,’拜金’,’温柔体贴’,’小心翼翼’,’暴力倾向’,’逆来顺受’,’不拘小节’,’暴躁’,’倔强’,’豪爽’,’害羞’,’婆婆妈妈’,’敢做敢当’,’助人为乐’,’耿直’,’虚伪’,’孤僻’,’老实’,’守旧’,’敏感’,’迟钝’,’婆婆妈妈’,’武断’,’果断’,’刻薄’) default NULL,
`lovemsg` varchar(100) NOT NULL default ”,
`address` varchar(50) NOT NULL default ”,
`uptime` int(10) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[Msg] Finished – Unsuccessfully
————————————————–
nature里面有两个‘婆婆妈妈’ 去掉一个即可
