很多網站出現過由于計劃任務的每日用戶表優化自動執行遇到以下報錯:Column count doesn't match value count at row,將提示信息的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`;
這樣就可以了。
此文由 網站目錄_網站網址收錄與提交入口 編輯,未經允許不得轉載?。?!--首頁 > 站長文章 > dz論壇 » ucenter的用戶總數與論壇顯示的會員總數不一致的處理方法-->