[Discuz!] ucenter的用戶總數(shù)與論壇顯示的會(huì)員總數(shù)不一致的處理方法

很多網(wǎng)站出現(xiàn)過由于計(jì)劃任務(wù)的每日用戶表優(yōu)化自動(dòng)執(zhí)行遇到以下報(bào)錯(cuò)：Column count doesn't match value count at row，將提示信息的pre_common_member、pre_common_member_status這兩個(gè)表的歸檔表刪除，并以主表為基準(zhǔn)手工新建了兩個(gè)和主表數(shù)據(jù)一致的歸檔表，然后自動(dòng)執(zhí)行計(jì)劃任務(wù)的每日用戶表優(yōu)化就正常了，但是如此操作之后會(huì)造成UC中心的用戶總數(shù)與論壇顯示的會(huì)員總數(shù)不一致的情況，這個(gè)時(shí)候可以嘗試將存檔表合并到主表中，需要執(zhí)行的sql語(yǔ)句如下：

1. insert into pre_common_member select * from pre_common_member_archive;
   
2. insert into pre_common_member_count select * from pre_common_member_count_archive;
   
3. insert into pre_common_member_field_forum select * from pre_common_member_field_forum_archive;
   
4. insert into pre_common_member_field_home select * from pre_common_member_field_home_archive;
   
5. insert into pre_common_member_profile select * from pre_common_member_profile_archive;
   
6. insert into pre_common_member_status select * from pre_common_member_status_archive;

復(fù)制代碼

再執(zhí)行：

1. TRUNCATE TABLE  `pre_common_member_archive`;
   
2. TRUNCATE TABLE  `pre_common_member_count_archive`;
   
3. TRUNCATE TABLE  `pre_common_member_field_forum_archive`;
   
4. TRUNCATE TABLE  `pre_common_member_field_home_archive`;
   
5. TRUNCATE TABLE  `pre_common_member_profile_archive`;
   
6. TRUNCATE TABLE  `pre_common_member_status_archive`;

復(fù)制代碼

這樣就可以了。