在Discuz!x 3.3 中common_member_archive表丢失的解决办法

admin

网上有很多解决办法，当然，可能都比较复杂，或者取消计划任务的勾勾不利于后期的维护


只需要执行以下sql即可。

1. 
   
2. CREATE TABLE pre_common_member_archive LIKE pre_common_member;   
   
3. INSERT INTO pre_common_member_archive SELECT * FROM pre_common_member;  
   
4. 
   
5. CREATE TABLE pre_common_member_profile_archive LIKE pre_common_member_profile;   
   
6. INSERT INTO pre_common_member_profile_archive SELECT * FROM pre_common_member_profile;  
   
7. 
   
8. CREATE TABLE pre_common_member_field_forum_archive LIKE pre_common_member_field_forum;   
   
9. INSERT INTO pre_common_member_field_forum_archive SELECT * FROM pre_common_member_field_forum;  
   
10. 
    
11. CREATE TABLE pre_common_member_field_home_archive LIKE pre_common_member_field_home;   
    
12. INSERT INTO pre_common_member_field_home_archive SELECT * FROM pre_common_member_field_home;
    
13. 
    
14. CREATE TABLE pre_common_member_status_archive LIKE pre_common_member_status;   
    
15. INSERT INTO pre_common_member_status_archive SELECT * FROM pre_common_member_status;  
    
16. 
    
17. CREATE TABLE pre_common_member_count_archive LIKE pre_common_member_count;   
    
18. INSERT INTO pre_common_member_count_archive SELECT * FROM pre_common_member_count;  

复制代码