【论坛站务】论坛登录异常问题已经修复了（大概

0xAA55

    论坛之前有登录异常问题，是因为Discuz! X3.2的存档表用户无法登录所致。这种事情虽然以前出现过一次并且我手动合并了一次存档表，但还是再次出现了。
    现在发现是“每日用户表优化”（cron_member_optimize_daily.php）会定期把长期不登录的用户移动到存档表里。为了解决这个问题，我禁用了这个计划任务。现在所有的用户都在主表里，不会出现无法登录的问题了。
    欢迎大家访问技术宅的结界，并且进行后续维护的协助，告知我有关登录问题的状况。谢谢配合。

技术宅的结界管理组 2018-11-4

0xAA55

有关存档表合并的SQL语句如下，使用时请注意先备份数据库。

1. # pre_common_member
   
2. 
   
3. drop table if exists pre_common_member_bak;
   
4. drop table if exists pre_common_member_temp;
   
5. drop table if exists pre_common_member_archive_bak;
   
6. 
   
7. # 备份表
   
8. create table pre_common_member_temp like pre_common_member;
   
9. insert into pre_common_member_temp select * from pre_common_member;
   
10. create table pre_common_member_archive_bak like pre_common_member_archive;
    
11. insert into pre_common_member_archive_bak select * from pre_common_member_archive;
    
12. 
    
13. insert ignore into pre_common_member_temp select * from pre_common_member_archive;
    
14. insert ignore into pre_common_member_temp select * from pre_common_member;
    
15. 
    
16. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
    
17. alter table pre_common_member RENAME TO pre_common_member_bak;
    
18. alter table pre_common_member_temp RENAME TO pre_common_member;
    
19. truncate table pre_common_member_archive;
    
20. 
    
21. # pre_common_member_count
    
22. 
    
23. drop table if exists pre_common_member_count_bak;
    
24. drop table if exists pre_common_member_count_temp;
    
25. drop table if exists pre_common_member_count_archive_bak;
    
26. 
    
27. # 备份表
    
28. create table pre_common_member_count_temp like pre_common_member_count;
    
29. insert into pre_common_member_count_temp select * from pre_common_member_count;
    
30. create table pre_common_member_count_archive_bak like pre_common_member_count_archive;
    
31. insert into pre_common_member_count_archive_bak select * from pre_common_member_count_archive;
    
32. 
    
33. insert ignore into pre_common_member_count_temp select * from pre_common_member_count_archive;
    
34. insert ignore into pre_common_member_count_temp select * from pre_common_member_count;
    
35. 
    
36. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
    
37. alter table pre_common_member_count RENAME TO pre_common_member_count_bak;
    
38. alter table pre_common_member_count_temp RENAME TO pre_common_member_count;
    
39. truncate table pre_common_member_count_archive;
    
40. 
    
41. # pre_common_member_field_home
    
42. 
    
43. drop table if exists pre_common_member_field_home_bak;
    
44. drop table if exists pre_common_member_field_home_temp;
    
45. drop table if exists pre_common_member_field_home_archive_bak;
    
46. 
    
47. # 备份表
    
48. create table pre_common_member_field_home_temp like pre_common_member_field_home;
    
49. insert into pre_common_member_field_home_temp select * from pre_common_member_field_home;
    
50. create table pre_common_member_field_home_archive_bak like pre_common_member_field_home_archive;
    
51. insert into pre_common_member_field_home_archive_bak select * from pre_common_member_field_home_archive;
    
52. 
    
53. insert ignore into pre_common_member_field_home_temp select * from pre_common_member_field_home_archive;
    
54. insert ignore into pre_common_member_field_home_temp select * from pre_common_member_field_home;
    
55. 
    
56. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
    
57. alter table pre_common_member_field_home RENAME TO pre_common_member_field_home_bak;
    
58. alter table pre_common_member_field_home_temp RENAME TO pre_common_member_field_home;
    
59. truncate table pre_common_member_field_home_archive;
    
60. 
    
61. # pre_common_member_field_forum
    
62. 
    
63. drop table if exists pre_common_member_field_forum_bak;
    
64. drop table if exists pre_common_member_field_forum_temp;
    
65. drop table if exists pre_common_member_field_forum_archive_bak;
    
66. 
    
67. # 备份表
    
68. create table pre_common_member_field_forum_temp like pre_common_member_field_forum;
    
69. insert into pre_common_member_field_forum_temp select * from pre_common_member_field_forum;
    
70. create table pre_common_member_field_forum_archive_bak like pre_common_member_field_forum_archive;
    
71. insert into pre_common_member_field_forum_archive_bak select * from pre_common_member_field_forum_archive;
    
72. 
    
73. insert ignore into pre_common_member_field_forum_temp select * from pre_common_member_field_forum_archive;
    
74. insert ignore into pre_common_member_field_forum_temp select * from pre_common_member_field_forum;
    
75. 
    
76. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
    
77. alter table pre_common_member_field_forum RENAME TO pre_common_member_field_forum_bak;
    
78. alter table pre_common_member_field_forum_temp RENAME TO pre_common_member_field_forum;
    
79. truncate table pre_common_member_field_forum_archive;
    
80. 
    
81. # pre_common_member_profile
    
82. 
    
83. drop table if exists pre_common_member_profile_bak;
    
84. drop table if exists pre_common_member_profile_temp;
    
85. drop table if exists pre_common_member_profile_archive_bak;
    
86. 
    
87. # 备份表
    
88. create table pre_common_member_profile_temp like pre_common_member_profile;
    
89. insert into pre_common_member_profile_temp select * from pre_common_member_profile;
    
90. create table pre_common_member_profile_archive_bak like pre_common_member_profile_archive;
    
91. insert into pre_common_member_profile_archive_bak select * from pre_common_member_profile_archive;
    
92. 
    
93. insert ignore into pre_common_member_profile_temp select * from pre_common_member_profile_archive;
    
94. insert ignore into pre_common_member_profile_temp select * from pre_common_member_profile;
    
95. 
    
96. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
    
97. alter table pre_common_member_profile RENAME TO pre_common_member_profile_bak;
    
98. alter table pre_common_member_profile_temp RENAME TO pre_common_member_profile;
    
99. truncate table pre_common_member_profile_archive;
    
100. 
     
101. # pre_common_member_status
     
102. 
     
103. drop table if exists pre_common_member_status_bak;
     
104. drop table if exists pre_common_member_status_temp;
     
105. drop table if exists pre_common_member_status_archive_bak;
     
106. 
     
107. # 备份表
     
108. create table pre_common_member_status_temp like pre_common_member_status;
     
109. insert into pre_common_member_status_temp select * from pre_common_member_status;
     
110. create table pre_common_member_status_archive_bak like pre_common_member_status_archive;
     
111. insert into pre_common_member_status_archive_bak select * from pre_common_member_status_archive;
     
112. 
     
113. insert ignore into pre_common_member_status_temp select * from pre_common_member_status_archive;
     
114. insert ignore into pre_common_member_status_temp select * from pre_common_member_status;
     
115. 
     
116. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
     
117. alter table pre_common_member_status RENAME TO pre_common_member_status_bak;
     
118. alter table pre_common_member_status_temp RENAME TO pre_common_member_status;
     
119. truncate table pre_common_member_status_archive;
     
120. 
     
121. # pre_home_follow_feed
     
122. 
     
123. drop table if exists pre_home_follow_feed_bak;
     
124. drop table if exists pre_home_follow_feed_temp;
     
125. drop table if exists pre_home_follow_feed_archiver_bak;
     
126. 
     
127. # 备份表
     
128. create table pre_home_follow_feed_temp like pre_home_follow_feed;
     
129. insert into pre_home_follow_feed_temp select * from pre_home_follow_feed;
     
130. create table pre_home_follow_feed_archiver_bak like pre_home_follow_feed_archiver;
     
131. insert into pre_home_follow_feed_archiver_bak select * from pre_home_follow_feed_archiver;
     
132. 
     
133. insert ignore into pre_home_follow_feed_temp select * from pre_home_follow_feed_archiver;
     
134. insert ignore into pre_home_follow_feed_temp select * from pre_home_follow_feed;
     
135. 
     
136. # 主表改成bak备份，临表二改成主表名，清空存档表的数据
     
137. alter table pre_home_follow_feed RENAME TO pre_home_follow_feed_bak;
     
138. alter table pre_home_follow_feed_temp RENAME TO pre_home_follow_feed;
     
139. truncate table pre_home_follow_feed_archiver;
     
140. 
     
141. # 如果不想保留备份，则执行这里的语句删除备份
     
142. drop table if exists pre_common_member_bak;
     
143. drop table if exists pre_common_member_temp;
     
144. drop table if exists pre_common_member_archive_bak;
     
145. drop table if exists pre_common_member_count_bak;
     
146. drop table if exists pre_common_member_count_temp;
     
147. drop table if exists pre_common_member_count_archive_bak;
     
148. drop table if exists pre_common_member_field_home_bak;
     
149. drop table if exists pre_common_member_field_home_temp;
     
150. drop table if exists pre_common_member_field_home_archive_bak;
     
151. drop table if exists pre_common_member_field_forum_bak;
     
152. drop table if exists pre_common_member_field_forum_temp;
     
153. drop table if exists pre_common_member_field_forum_archive_bak;
     
154. drop table if exists pre_common_member_profile_bak;
     
155. drop table if exists pre_common_member_profile_temp;
     
156. drop table if exists pre_common_member_profile_archive_bak;
     
157. drop table if exists pre_common_member_status_bak;
     
158. drop table if exists pre_common_member_status_temp;
     
159. drop table if exists pre_common_member_status_archive_bak;
     
160. drop table if exists pre_home_follow_feed_bak;
     
161. drop table if exists pre_home_follow_feed_temp;
     
162. drop table if exists pre_home_follow_feed_archiver_bak;

复制代码