Discuz!用户账号串号登陆解决方案之一

故障说明：论坛用户在使用是出现用户串号登陆，A账号变成B账号登陆的情况，原因是Discuz!和UC内的用户id对不上，导致的。

解决方法：必须将UC和DZ的UID统一起来

1.以UC为准的统一方法：

1. DELETE FROM `uc_members` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);

复制代码

以上是7.2升级用户的统一代码

1. DELETE FROM `pre_ucenter_member` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);

复制代码

以上是7.2升级后用老UC库的

2.以DZ为准的统一代码

1. SELECT uid FROM `pre_common_member` WHERE uid  NOT IN (SELECT uid FROM `uc_members`);

复制代码

以上是7.2升级用户的统一代码

1. 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