这个是我以前的求助贴
https://discuz.dismall.com/redirect.php?fid=2&tid=31742
[跪求]没发备份数据,显示帖子数量进去却看不到?
我是从rc1-rc2-rc3-----1.0----1.01升级的,到了1.01之后,论坛首页能够显示各栏目帖子的数目,发表日期,
可是进到每个栏目里面之后却什么也看不到
现在用的是1。01版本,想升级到2。0可是总是出现错误:运行upgrade2时
显示
Discuz! info: MySQL Query Error
Time: 2003-9-24 9:14am
Script:
SQL: ALTER TABLE ciet_settings ADD styleid smallint(6) UNSIGNED NOT NULL AFTER moddisplay
Error: Table 'ciet.ciet_settings' doesn't exist
数据表缺失,请恢复备份数据
Similar error report has beed dispatched to administrator before
请各位大哥帮帮忙,看是什么地方出现了错误
[ Last edited by zt6108 on 2003-9-24 at 05:19 PM ]
------------------------------------------------------------------------------
重新安装1.01 倒入备份出来的sql文件后出现
语句: CREATE TABLE ciet_settings ( bbname varchar(50) NOT NULL, regstatus tinyint(1) NOT NULL, censoruser text NOT NULL, doublee tinyint(1) NOT NULL, emailcheck tinyint(1) NOT NULL, bbrules tinyint(1) NOT NULL, bbrulestxt text NOT NULL, welcommsg tinyint(1) NOT NULL, welcommsgtxt text NOT NULL, bbclosed tinyint(1) NOT NULL, closedreason text NOT NULL, sitename varchar(50) NOT NULL, siteurl varchar(60) NOT NULL, theme varchar(30) NOT NULL, credittitle varchar(20) NOT NULL, creditunit varchar(10) NOT NULL, moddisplay enum('flat','selectbox') NOT NULL default 'flat', floodctrl smallint(6) unsigned NOT NULL, karmactrl smallint(6) unsigned NOT NULL, hottopic tinyint(3) unsigned NOT NULL, topicperpage tinyint(3) unsigned NOT NULL, postperpage tinyint(3) unsigned NOT NULL, memberperpage tinyint(3) unsigned NOT NULL, maxpostsize smallint(6) unsigned NOT NULL, maxavatarsize tinyint(3) unsigned NOT NULL, smcols tinyint(3) unsigned NOT NULL, postcredits tinyint(3) NOT NULL, digistcredits tinyint(3) NOT NULL, whosonlinestatus tinyint(1) NOT NULL, vtonlinestatus tinyint(1) NOT NULL, chcode tinyint(1) NOT NULL, gzipcompress tinyint(1) NOT NULL, hideprivate tinyint(1) NOT NULL, fastpost tinyint(1) NOT NULL, memliststatus tinyint(1) NOT NULL, statstatus tinyint(1) NOT NULL, debug tinyint(1) NOT NULL, reportpost tinyint(1) NOT NULL, bbinsert tinyint(1) NOT NULL, smileyinsert tinyint(1) NOT NULL, editedby tinyint(1) NOT NULL, dotfolders tinyint(1) NOT NULL, attachimgpost tinyint(1) NOT NULL, timeformat varchar(5) NOT NULL, dateformat varchar(10) NOT NULL, timeoffset char(3) NOT NULL, version varchar(30) NOT NULL, onlinerecord varchar(20) NOT NULL, lastmember varchar(25) NOT NULL, KEY bbrulestxt (bbrulestxt), KEY bbname (bbname))
错误: BLOB column 'bbrulestxt' used in key specification without a key length
错误号: 1170
================================================== |