PHPWind 7.3=> Discuz! 7.0 UC 转换程序出现以下代码

XConvert info: MySQL Query Error

Time: 2009-6-17 9:13am
SQL: INSERT INTO v100409.uchome_friend (uid, fuid, fusername, status, gid, note, num, dateline) VALUES ( '73', '140', 'ljquan0605', '1', '1', '', '0', '1213577321');
Error: Duplicate entry '73-140' for key 1
Errormsg.: 字段值重复，入库失败
Errno.: 1062

字段值重复，删除重复字段
再转换试试

在哪删除重复字段

可以尝试执行以下SQL命令语句，操作前请先备份数据

1. 
   
2. CREATE TABLE uchome_friend (
   
3.   uid mediumint(8) unsigned NOT NULL default '0',
   
4.   fuid mediumint(8) unsigned NOT NULL default '0',
   
5.   fusername char(15) NOT NULL default '',
   
6.   status tinyint(1) NOT NULL default '0',
   
7.   gid smallint(6) unsigned NOT NULL default '0',
   
8.   note char(50) NOT NULL default '',
   
9.   num mediumint(8) unsigned NOT NULL default '0',
   
10.   dateline int(10) unsigned NOT NULL default '0',
    
11.   PRIMARY KEY  (uid,fuid),
    
12.   KEY fuid (fuid),
    
13.   KEY status (uid, status, num, dateline)
    
14. ) ENGINE=MyISAM;
    

复制代码