找回密码
 立即注册

只需一扫,快速开始

QQ登录

只需一步,快速开始

搜索
查看: 18691|回复: 0

[技术经验] 在Discuz!x 3.3 中common_member_archive表丢失的解决办法

[复制链接]

8万

主题

421

回帖

9万

积分

管理员

积分
94370
QQ
发表于 2017-7-5 11:04:29 | 显示全部楼层 |阅读模式
网上有很多解决办法,当然,可能都比较复杂,或者取消计划任务的勾勾不利于后期的维护


只需要执行以下sql即可。


  1. CREATE TABLE pre_common_member_archive LIKE pre_common_member;   
  2. INSERT INTO pre_common_member_archive SELECT * FROM pre_common_member;  

  3. CREATE TABLE pre_common_member_profile_archive LIKE pre_common_member_profile;   
  4. INSERT INTO pre_common_member_profile_archive SELECT * FROM pre_common_member_profile;  

  5. CREATE TABLE pre_common_member_field_forum_archive LIKE pre_common_member_field_forum;   
  6. INSERT INTO pre_common_member_field_forum_archive SELECT * FROM pre_common_member_field_forum;  

  7. CREATE TABLE pre_common_member_field_home_archive LIKE pre_common_member_field_home;   
  8. INSERT INTO pre_common_member_field_home_archive SELECT * FROM pre_common_member_field_home;

  9. CREATE TABLE pre_common_member_status_archive LIKE pre_common_member_status;   
  10. INSERT INTO pre_common_member_status_archive SELECT * FROM pre_common_member_status;  

  11. CREATE TABLE pre_common_member_count_archive LIKE pre_common_member_count;   
  12. INSERT INTO pre_common_member_count_archive SELECT * FROM pre_common_member_count;  
复制代码




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册   

本版积分规则

QQ|Archiver|手机版|小黑屋|站秘书 ( 蜀ICP备15034504号-3 )

GMT+8, 2024-3-29 23:27 , Processed in 0.084552 second(s), 32 queries .

Powered by Discuz! X3.5

Copyright © 2001-2024 Tencent Cloud.

快速回复 返回顶部 返回列表