原帖由 winter0706 于 2005-6-9 18:06 发表
for2.0/2.1/2.1增强修改版
[code]ALTER TABLE `cdb_members` DROP `money`;
ALTER TABLE `cdb_members` DROP `bank`;
ALTER TABLE `cdb_members` DROP `savemt`;
ALTER TABLE `cdb_members` DROP `bankstat ...
执行反安装代码时出错
Discuz! info: MySQL Query Error
User: admin
Time: 2005-6-12 9:16am
Script: /admincp.php
SQL: ALTER TABLE `cdb_members` DROP `money`
Error: Can't DROP 'money'. Check that column/key exists
Errno.: 1091
An error report has been dispatched to our administrator.
我执行全新安装代码的 第一段时也出错!
Discuz! info: MySQL Query Error
User: admin
Time: 2005-6-12 9:18am
Script: /admincp.php
SQL: ALTER TABLE `cdb_members` ADD `money` INT(10) DEFAULT '100' NOT NULL, ADD `bank` INT(10) DEFAULT '0' NOT NULL, ADD `savemt` INT(10) DEFAULT '0' NOT NULL, ADD `bankstatus` tinyint(1) DEFAULT '0' NOT NULL, ADD `bankmimi` INT(10) DEFAULT '0' NOT NULL, ADD `bankpass` int(5) DEFAULT '8888' NOT NULL, ADD `savemimi` INT(10) DEFAULT '0' NOT NULL;
Error: Duplicate column name 'bank'
Errno.: 1060
An error report has been dispatched to our administrator.
[ 本帖最后由 xinkai 于 2005-6-12 09:13 编辑 ] |