|
|
发表于 2016-11-15 10:33:38
|
显示全部楼层
你论坛的 pre_forum_thread 主题表不存在啊,论坛不完整撒,后台校验下文件用官方文件覆盖下,缺少的数据库表,自己手工建立下撒~
手机建表SQL语句:【以下SQL语句请在phpmyadmin中你的论坛数据库下执行SQL,或论坛后台——站长——数据库——升级】
- DROP TABLE IF EXISTS pre_forum_thread;
- CREATE TABLE pre_forum_thread (
- tid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- fid mediumint(8) unsigned NOT NULL DEFAULT '0',
- posttableid smallint(6) unsigned NOT NULL DEFAULT '0',
- typeid smallint(6) unsigned NOT NULL DEFAULT '0',
- sortid smallint(6) unsigned NOT NULL DEFAULT '0',
- readperm tinyint(3) unsigned NOT NULL DEFAULT '0',
- price smallint(6) NOT NULL DEFAULT '0',
- author char(15) NOT NULL DEFAULT '',
- authorid mediumint(8) unsigned NOT NULL DEFAULT '0',
- `subject` char(80) NOT NULL DEFAULT '',
- dateline int(10) unsigned NOT NULL DEFAULT '0',
- lastpost int(10) unsigned NOT NULL DEFAULT '0',
- lastposter char(15) NOT NULL DEFAULT '',
- views int(10) unsigned NOT NULL DEFAULT '0',
- replies mediumint(8) unsigned NOT NULL DEFAULT '0',
- displayorder tinyint(1) NOT NULL DEFAULT '0',
- highlight tinyint(1) NOT NULL DEFAULT '0',
- digest tinyint(1) NOT NULL DEFAULT '0',
- rate tinyint(1) NOT NULL DEFAULT '0',
- special tinyint(1) NOT NULL DEFAULT '0',
- attachment tinyint(1) NOT NULL DEFAULT '0',
- moderated tinyint(1) NOT NULL DEFAULT '0',
- closed mediumint(8) unsigned NOT NULL DEFAULT '0',
- stickreply tinyint(1) unsigned NOT NULL DEFAULT '0',
- recommends smallint(6) NOT NULL DEFAULT '0',
- recommend_add smallint(6) NOT NULL DEFAULT '0',
- recommend_sub smallint(6) NOT NULL DEFAULT '0',
- heats int(10) unsigned NOT NULL DEFAULT '0',
- `status` smallint(6) unsigned NOT NULL DEFAULT '0',
- isgroup tinyint(1) NOT NULL DEFAULT '0',
- favtimes mediumint(8) NOT NULL DEFAULT '0',
- sharetimes mediumint(8) NOT NULL DEFAULT '0',
- stamp tinyint(3) NOT NULL DEFAULT '-1',
- icon tinyint(3) NOT NULL DEFAULT '-1',
- pushedaid mediumint(8) NOT NULL DEFAULT '0',
- cover smallint(6) NOT NULL DEFAULT '0',
- replycredit smallint(6) NOT NULL DEFAULT '0',
- relatebytag char(255) NOT NULL DEFAULT '0',
- maxposition int(8) unsigned NOT NULL DEFAULT '0',
- bgcolor char(8) NOT NULL DEFAULT '',
- comments int(10) unsigned NOT NULL DEFAULT '0',
- hidden smallint(6) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (tid),
- KEY digest (digest),
- KEY sortid (sortid),
- KEY displayorder (fid,displayorder,lastpost),
- KEY typeid (fid,typeid,displayorder,lastpost),
- KEY recommends (recommends),
- KEY heats (heats),
- KEY authorid (authorid),
- KEY isgroup (isgroup,lastpost),
- KEY special (special)
- ) TYPE=MyISAM;
复制代码
|
|