升级好像有点问题,解决一下。Discuz! info: MySQL Query Error
User: mmx1234
Time: 2006-2-8 6:54pm
Script: /court_stp.php
SQL:
CREATE TABLE cdb_court_litigation (
id Integer NOT NULL AUTO_INCREMENT,
accuser Varchar(255) NOT NULL,
appellee Varchar(255) NOT NULL,
lititype Tinyint(1) NOT NULL DEFAULT '1',
litititle Varchar(50) NOT NULL,
lititext Text NOT NULL,
litiproof Text NOT NULL,
liticlaimid Tinyint(2) NOT NULL DEFAULT '1',
liticlaimtext Varchar(20) NOT NULL,
litiappsay Text NOT NULL,
pacification1 Tinyint(1) NOT NULL,
pacification2 Tinyint(1) NOT NULL,
pacification3 Tinyint(1) NOT NULL,
lititime Varchar(16) NOT NULL DEFAULT '0',
judgement Tinyint(1) NOT NULL DEFAULT '0',
judgetimes Integer NOT NULL DEFAULT '0',
judgeuser Varchar(255) NOT NULL,
judgeclaimid Tinyint(2) NOT NULL,
judgeclaimtext Varchar(20) NOT NULL,
judgetext Text NOT NULL,
judgetime Varchar(16) NOT NULL DEFAULT '0',
PRIMARY KEY(id)
);
Error: Table 'cdb_court_litigation' already exists
Errno.: 1050
An error report has been dispatched to our administrator.
刚才看了下安装文件,没有判断存在的语句哦,最好可以加上去,以方便用户升级。另外,如果把这些表都重建了,原来的数据还不在?
[ 本帖最后由 mmx1234 于 2006-2-8 19:19 编辑 ] |