discuz提示(1146) Table 'pre.common_member_archive' doesn't exist的解决方法

Demonづ锐少

错误提示是这样的！

1. Discuz! Database Error
   
2. (1146) Table 'pre.common_member_field_home_archive' doesn't exist
   
3. SELECT * FROM common_member_field_home_archive WHERE `uid` IN('1257','1428','1574')
   
4. PHP Debug
   
5. 
   
6. No. File Line Code
   
7. 1 forum.php 115 require(%s)
   
8. 2 source/module/forum/forum_viewthread.php 662 discuz_table_archive->fetch_all(Array)
   
9. 3 source/class/discuz/discuz_table_archive.php 41 table_common_member_field_home_archive->fetch_all(Array)
   
10. 4 source/class/table/table_common_member_field_home_archive.php 30 discuz_database::query(%s)
    
11. 5 source/class/discuz/discuz_database.php 136 db_driver_mysql->query(%s, false, false)
    
12. 6 source/class/db/db_driver_mysql.php 151 db_driver_mysql->halt(%s, %d, %s)
    
13. 7 source/class/db/db_driver_mysql.php 218 break()

复制代码

注意：一定要是pre.common_member_archive这个表错误

首先执行SQL语句

1. DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';

复制代码

如果不可以再执行sql语句

1. DROP TABLE IF EXISTS pre_home_follow_feed_archiver;
   
2. CREATE TABLE pre_home_follow_feed_archiver (
   
3.   feedid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
4.   uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
5.   username varchar(15) NOT NULL DEFAULT '',
   
6.   tid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
7.   note text NOT NULL,
   
8.   dateline int(10) unsigned NOT NULL DEFAULT '0',
   
9.   PRIMARY KEY (feedid),
   
10.   KEY uid (uid,dateline)
    
11. ) TYPE=MyISAM;

复制代码