故障说明:论坛用户在使用是出现用户串号登陆,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 uid NOT 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 |
|