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

admin · 发表于 2017-7-5 11:04:29

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

只需要执行以下sql即可。

CREATE TABLE pre_common_member_archive LIKE pre_common_member;
INSERT INTO pre_common_member_archive SELECT * FROM pre_common_member;
CREATE TABLE pre_common_member_profile_archive LIKE pre_common_member_profile;
INSERT INTO pre_common_member_profile_archive SELECT * FROM pre_common_member_profile;
CREATE TABLE pre_common_member_field_forum_archive LIKE pre_common_member_field_forum;
INSERT INTO pre_common_member_field_forum_archive SELECT * FROM pre_common_member_field_forum;
CREATE TABLE pre_common_member_field_home_archive LIKE pre_common_member_field_home;
INSERT INTO pre_common_member_field_home_archive SELECT * FROM pre_common_member_field_home;
CREATE TABLE pre_common_member_status_archive LIKE pre_common_member_status;
INSERT INTO pre_common_member_status_archive SELECT * FROM pre_common_member_status;
CREATE TABLE pre_common_member_count_archive LIKE pre_common_member_count;
INSERT INTO pre_common_member_count_archive SELECT * FROM pre_common_member_count;

复制代码

		自动登录	找回密码
密码			立即注册

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