[求助]D3FB3升级D4第二步出现这样的问题

Discuz! info: MySQL Query Error

Time: 2005-12-27 4:34pm
Script: /d3ftod4.php

SQL: ALTER TABLE cdb_admingroups ADD allowmodpost TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowstickthread , ADD allowmassprune TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowdelpost ,ADD allowrefund TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowmassprune ,ADD allowcensorword TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowrefund , ADD allowbanip TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowviewip ,ADD allowedituser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowbanip ,
ADD allowmoduser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowedituser , ADD allowbanuser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowmoduser , ADD allowpostannounce TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowbanuser , ADD allowviewlog TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowpostannounce
Error: Duplicate column name 'allowmodpost'
Errno.: 1060

An error report has been dispatched to our administrator.


请指教

第3步也是错误
Discuz! info: MySQL Query Error

Time: 2005-12-27 5:31pm
Script: /d3ftod4.php

SQL: ALTER TABLE cdb_admingroups ADD allowmodpost TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowstickthread , ADD allowmassprune TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowdelpost ,ADD allowrefund TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowmassprune ,ADD allowcensorword TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowrefund , ADD allowbanip TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER
allowviewip ,ADD allowedituser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowbanip ,
ADD allowmoduser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowedituser , ADD allowbanuser TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowmoduser , ADD allowpostannounce TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowbanuser , ADD allowviewlog TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowpostannounce
Error: Duplicate column name 'allowmodpost'
Errno.: 1060

An error report has been dispatched to our administrator.

Error: Duplicate column name 'allowmodpost'
这个错误升级时很常见,可能是由于楼主安装过某些插件造成的.
这个错误好像是报键值重复,注释掉相关的SQL升级语句就可以了