記錄：Vitcie 1.2 安裝錯誤訊息

架Vitcie 1.2一直是很順利的，但不知何故，在許大哥的新空間卻頻頻出錯。安裝失敗，錯誤訊息：

VITCIE info: MySQL Query Error

Time: 2009-01-02 06:53 pm
Script: /vitcie/install.php

SQL: CREATE TABLE vte_language ( langid smallint(6) NOT NULL auto_increment, langname varchar(50) default '0', langdir varchar(250) default '0', copyright varchar(250) default '0', charset varchar(250) default '0', PRIMARY KEY (langid,langid), KEY langid_2 (langid)) TYPE=MyISAM
Error: Duplicate column name 'langid'
Errno.: 1060

An error report has been dispatched to our administrator.
Fatal error: Call to undefined function: sendmail() in /home/yourhome/public_html/vitcie/include/db_mysql_error.php on line 51

CREATE TABLE vte_language創建時發生錯誤，解決方式：

打開SQL檔案，找到PRIMARY KEY (langid,langid)
修改為PRIMARY KEY (langid,langname)

重新進行安裝後卡在CREATE TABLE vte_styles創建時，發生以下錯誤訊息：

VITCIE info: MySQL Query Error

Time: 2009-01-02 6:58 pm
Script: /vitcie/install.php

SQL: CREATE TABLE vte_styles ( styleid smallint(6) unsigned NOT NULL auto_increment, stylename varchar(20) NOT NULL default '0', tpldir varchar(50) NOT NULL default '0', imgdir varchar(50) NOT NULL default '0', copyright varchar(50) NOT NULL default '0', PRIMARY KEY (styleid,styleid), UNIQUE KEY styleid (styleid), KEY styleid_2 (styleid)) TYPE=MyISAM
Error: Duplicate column name 'styleid'
Errno.: 1060

An error report has been dispatched to our administrator.
Fatal error: Call to undefined function: sendmail() in /home/yourhome/public_html/vitcie/include/db_mysql_error.php on line 51

解決方式同上，找到PRIMARY KEY (styleid,styleid)
修改為PRIMARY KEY (styleid,stylename)

目前解決方式可安裝成功。