Discuz!用户账号串号登陆解决方案之一
故障说明：论坛用户在使用是出现用户串号登陆，A账号变成B账号登陆的情况，原因是Discuz!和UC内的用户id对不上，导致的。解决方法：必须将UC和DZ的UID统一起来
1.以UC为准的统一方法：
DELETE FROM `uc_members` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);
以上是7.2升级用户的统一代码
DELETE FROM `pre_ucenter_member` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);
以上是7.2升级后用老UC库的
2.以DZ为准的统一代码
SELECT uid FROM `pre_common_member` WHERE uidNOT IN (SELECT uid FROM `uc_members`);
以上是7.2升级用户的统一代码
DELETE FROM `pre_common_member` WHERE uid NOT IN(SELECT uid FROM `pre_ucenter_member`);
以上是安装Discuz!
SQL语句执行有危险！
请备份被改动的数据表：pre_common_member ，pre_ucenter_member ，uc_members
页:
[1]