discuz提示(1146) Table 'pre.common_member_archive' doesn't exist的解决方法
错误提示是这样的！Discuz! Database Error
(1146) Table 'pre.common_member_field_home_archive' doesn't exist
SELECT * FROM common_member_field_home_archive WHERE `uid` IN('1257','1428','1574')
PHP Debug
No. File Line Code
1 forum.php 115 require(%s)
2 source/module/forum/forum_viewthread.php 662 discuz_table_archive->fetch_all(Array)
3 source/class/discuz/discuz_table_archive.php 41 table_common_member_field_home_archive->fetch_all(Array)
4 source/class/table/table_common_member_field_home_archive.php 30 discuz_database::query(%s)
5 source/class/discuz/discuz_database.php 136 db_driver_mysql->query(%s, false, false)
6 source/class/db/db_driver_mysql.php 151 db_driver_mysql->halt(%s, %d, %s)
7 source/class/db/db_driver_mysql.php 218 break() 注意：一定要是pre.common_member_archive这个表错误
首先执行SQL语句
DELETE FROM `pre_common_setting` WHERE `skey` = 'membersplit';如果不可以再执行sql语句
DROP TABLE IF EXISTS pre_home_follow_feed_archiver;
CREATE TABLE pre_home_follow_feed_archiver (
feedid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
username varchar(15) NOT NULL DEFAULT '',
tid mediumint(8) unsigned NOT NULL DEFAULT '0',
note text NOT NULL,
dateline int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (feedid),
KEY uid (uid,dateline)
) TYPE=MyISAM;
页:
[1]