【未知错误】Error: Duplicate entry '0' for key 1[此问题已经解决]

加公告我的也是 这样
Discuz! info: MySQL Query Error

User: webmaster
Time: 2007-8-26 9:48am
Script: /admincp.php

SQL: INSERT INTO [Table]announcements (author, subject, type, starttime, endtime, message, groups)
VALUES ('webmaster', '论坛道具中心系统开放', '0', '1188057600', '0', '为丰富社区活动，现在奖励大家发贴，发贴一次增加双倍积分。您可以通过所得积分去道具中心购买自己喜欢的道具使用。', '')
Error: Duplicate entry '0' for key 1
Errno.: 1062

Discuz! info: MySQL Query Error

Time: 2007-10-9 5:27pm
Script: /bbs/register.php

SQL: INSERT INTO [Table]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 ('yatoo', 'b59c67bf196a4758191e42f76670ceba', '', '0', '0', '10', '218.79.207.95', '1191922024', '1191922024', '1191922024', '0', 0,0,0,0,0,0,0,0,0, 'dfs@sikm.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '0' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

我现在论坛出现这个问题  ？  待高手解决！！

后台 系统工具 数据库升级：

ALTER TABLE `cdb_members` CHANGE `uid` `uid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;

我的问题解决了，呵呵。

Discuz! info: MySQL Query Error

Time: 2008-9-2 11:25am
Script: /register.php

SQL: INSERT INTO [Table]members (uid, 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 ('8', 'aybbs', '80660eb0f8c0379eb1c1908e30efe384', '', '0', '0', '10', '222.139.117.107', '1220325906', '1220325906', '1220325906', '0', 0,0,0,0,0,0,0,0,0, 'linmingnet@163.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '8' for key 1
Errno.: 1062

Similar error report has beed dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案

我的提示这个是什么原因啊

已解决的问题 请勿回复

请发帖说明出问题前具体的操作 以及版本

https://discuz.dismall.com/viewth ... xtra=&frombbs=1
谢谢我已经发了.帮忙看一下

解决了啊啊

原帖由 下砂 于 2007-10-9 17:29 发表
后台 系统工具 数据库升级：

ALTER TABLE `cdb_members` CHANGE `uid` `uid` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT;

我的没用啊
SupeSite info: MySQL Query Error

User: root
Time: 2008-10-1 1:13pm
Script: /upload/admincp.php

SQL: INSERT INTO [Table]friendlinks (name, url, displayorder, description, logo) VALUES ('SoOne和田玉网', 'http://www.soone.net', '1', '', 'http://www.soone.net/images/default/联盟.gif')
Error: Duplicate entry '0' for key 1
Errno.: 1062

谢谢大家的解答，我的问题升级以后，也已经解决了。