出现 Errno: 1062 的解决方法

但我的表名是:supe_robotitems
出错如下，该怎么解决?谢谢!!!

Error: Duplicate entry '15921' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

搬家的朋友们，这帖能不顶吗？？？

TMD!厉害!不顶的不男不女!

very very 谢谢

支持好帖

好东西啊

我在备份数据库的时候出现
Discuz! info: MySQL Query Error

User: 蝴蝶风
Time: 2006-9-10 6:26pm
Script: /admincp.php

SQL: SHOW CREATE TABLE cdb_mobdom
Error: Table 'a05241635134.cdb_mobdom' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

这个是为什么啊，拜托谁告诉我啊

ALTER TABLE `cdb_posts` CHANGE `pid` `pid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
按此升级数据库了，但问题还是没解决

真得很不错，我用这个解决了大问题，感谢楼主！


下面是一次全部导入的

1. ALTER TABLE `cdb_adminnotes` CHANGE `id` `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
   
2. ALTER TABLE `cdb_advertisements` CHANGE `advid` `advid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
   
3. ALTER TABLE `cdb_announcements` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
   
4. ALTER TABLE `cdb_attachments` CHANGE `aid` `aid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
   
5. ALTER TABLE `cdb_attachtypes` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
   
6. ALTER TABLE `cdb_banned` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
   
7. ALTER TABLE `cdb_bbcodes` CHANGE `id` `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
   
8. ALTER TABLE `cdb_crons` CHANGE `cronid` `cronid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
   
9. ALTER TABLE `cdb_forumlinks` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
   
10. ALTER TABLE `cdb_forums` CHANGE `fid` `fid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
11. ALTER TABLE `cdb_medals` CHANGE `medalid` `medalid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
12. ALTER TABLE `cdb_members` CHANGE `uid` `uid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
    
13. ALTER TABLE `cdb_pluginhooks` CHANGE `pluginhookid` `pluginhookid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
    
14. ALTER TABLE `cdb_plugins` CHANGE `pluginid` `pluginid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
15. ALTER TABLE `cdb_pluginvars` CHANGE `pluginvarid` `pluginvarid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
    
16. ALTER TABLE `cdb_pms` CHANGE `pmid` `pmid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT;
    
17. ALTER TABLE `cdb_pmsearchindex` CHANGE `searchid` `searchid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT;
    
18. ALTER TABLE `cdb_posts` CHANGE `pid` `pid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    
19. ALTER TABLE `cdb_profilefields` CHANGE `fieldid` `fieldid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
20. ALTER TABLE `cdb_ranks` CHANGE `rankid` `rankid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
21. ALTER TABLE `cdb_searchindex` CHANGE `searchid` `searchid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
    
22. ALTER TABLE `cdb_smilies` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
23. ALTER TABLE `cdb_styles` CHANGE `styleid` `styleid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
24. ALTER TABLE `cdb_stylevars` CHANGE `stylevarid` `stylevarid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
25. ALTER TABLE `cdb_templates` CHANGE `templateid` `templateid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
26. ALTER TABLE `cdb_threads` CHANGE `tid` `tid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
    
27. ALTER TABLE `cdb_threadtypes` CHANGE `typeid` `typeid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
28. ALTER TABLE `cdb_usergroups` CHANGE `groupid` `groupid` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;
    
29. ALTER TABLE `cdb_words` CHANGE `id` `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT;

复制代码

[ 本帖最后由 kbc 于 2006-9-28 20:06 编辑 ]

There seems to have been a problem with the database of your Discuz!
Board

Discuz! info: MySQL Query Error

Time: 2006-10-17 2:23am
Script: /register.php

SQL: INSERT INTO cdb_members (username, password, secques, gender,
adminid, groupid, regip, regdate, lastvisit, lastactivity, posts, credits,
extcredits1, extcredits2, extcredits3, extcredits4, extcredits5,
extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp,
styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible,
timeoffset)
                VALUES ('戊酸软化', 'b62577994e54c475345fb5f5f015c417', '0d43d0b8',
'0', '0', '10', '219.133.142.101', '1161022985', '1161022985',
'1161022985', '0', 1,1,2,0,0,0,0,0,0, 'qwivnhzq@kejxos.com', '0000-00-00', '0',
'0', '0', '', '', '12', '', '0', '1', '0', '+8')
Error:  Duplicate entry '戊酸软化' for key 2
Errno.:  1062

Please check-up your MySQL server and forum scripts, similar errors
will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz!
Community http://www.Discuz.net.