推荐应用
discuz提示(1146) Table 'pre.common_member_archive' doesn't exist的解决方法
发布于 2013-05-13
错误文字(类似这样的)
首先后台,站长,数据库,升级
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这个表错误首先后台,站长,数据库,升级
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;