DZ6.1新用户无法注册，SQL: INSERT INTO ...............
错误提示：-------------------------------------------------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与论坛放在同一数据库的情况，更复杂的也可以同理补充
页:
[1]