DZ6.1新用户无法注册，SQL: INSERT INTO ...............

admin

错误提示：-------------------------------------------------
Discuz! info: MySQL Query Error

Time: 2008-7-2 4:19am
Script: /register.php

SQL: INSERT INTO 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 ('3960', 'fsodighoas', '7ad2235d671ac441a4871b37c52e7068', '', '0', '0', '10', '60.191.172.172', '1214943568', '1214943568', '1214943568', '0', 0,0,0,0,0,0,0,0,0, 'fsodighoas@kekor.com', '0000-00-00', '0', '0', '0', '', '0', '0', '1', '1', '1', '0', '9999')
Error: Duplicate entry '3960' for key 1
Errno.: 1062

解决办法：-----------------------------------------------------------------------
OK`~自己解决了.沙发.呵呵留下有类似问题的朋友吧原来是 uc_members  和cdb_members 里的用户不同步..

依次执行以下4句话。作之前要备份好uc数据。

truncate table uc_members

truncate table uc_memberfields

insert into uc_members
(uid,username,password,email,myid,myidkey,regip,regdate,lastloginip,lastlogintime,salt)
select uid,username,md5(password+'123456'),email,'','',regip,regdate,lastip,lastvisit,'123456'
from cdb_members

insert into uc_memberfields (uid,blacklist)
select uid,'' from cdb_members

这个方法可以补回所有会员，使登陆无碍，但dz6.1后注册的新用户会密码失效。

所谓具体问题具体分析，这里只写了UC只有一个论坛，而且UC与论坛放在同一数据库的情况，更复杂的也可以同理补充