Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

[已解决] 出现大问题了!!!!!!!!!!!

[复制链接]
yiyibushe 发表于 2012-4-8 11:36:40 | 显示全部楼层 |阅读模式
本帖最后由 yiyibushe 于 2012-4-8 11:46 编辑

添加表 pre_forum_thread 出错,请手工执行以下SQL语句后,再重新运行本升级程序:

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', 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) ) ENGINE=MYISAM DEFAULT CHARSET=gbk





这是怎么个回事????


本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?立即注册

x
12153556 发表于 2012-4-8 12:07:51 | 显示全部楼层
这个表是主题列表的表

怎么可以随便创建呢

如果手动添加的话,会导致主题列表丢失

如果有备份的话,恢复备份吧
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-10-1 00:25 , Processed in 0.099649 second(s), 19 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表