升級資料庫時!
1。升級數據庫
- ALTER TABLE `cdb_members` 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;
复制代码
發生以下錯誤!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Discuz! info: MySQL Query Error
User: terryk
Time: 2005-5-30 1:14pm
Script: /terryk/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 'money'
Errno.: 1060
Similar error report has beed dispatched to administrator before. |