完美銀行終結版 V2.0 (繁體版本)'s Problem
全新安裝
說明﹕適用于沒有安裝任何銀行的用戶。(從2.2升級到2.5的用戶也要求2.2中沒有安裝銀行)
1。升級數據庫
CODE: [Copy to clipboard]
--------------------------------------------------------------------------------
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;
It show this problem:
Discuz! info: MySQL Query Error
User: kelvinxp
Time: 2005-10-17 10:51pm
Script: /forum/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.
|