最新发现用户论坛数据跟UCenter 不一致，咋解决 下面看将提示信息的pre_common_member、pre_common_member_status这两个表的归档表删除，并以主表为基准手工 新建了两个和主表数据一致的归档表，然后自动执行计划任务的每日用户表优化就正常了，但是如此操作之后会造成UC中心的用户总数与论坛显示的会员总数不一 致的情况，这个时候我们可以尝试将存档表合并到主表中，可以执行以下sql语句

insert into pre_common_member select * from pre_common_member_archive;
insert into pre_common_member_count select * from pre_common_member_count_archive;
insert into pre_common_member_field_forum select * from 
pre_common_member_field_forum_archive;
insert into pre_common_member_field_home select * from 
pre_common_member_field_home_archive;
insert into pre_common_member_profile select * from pre_common_member_profile_archive;
insert into pre_common_member_status select * from pre_common_member_status_archive;

接着这句

TRUNCATE TABLE `pre_common_member_archive`;
TRUNCATE TABLE `pre_common_member_count_archive`;
TRUNCATE TABLE `pre_common_member_field_forum_archive`;
TRUNCATE TABLE `pre_common_member_field_home_archive`;
TRUNCATE TABLE `pre_common_member_profile_archive`;
TRUNCATE TABLE `pre_common_member_status_archive`;

最后更新于 2022-06-24 23:30:59 并被添加「」标签，已有 1086 位网友阅读过。

本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处