竹貓星球

發表於 : **2004-06-24 15:23**

問題外掛： i-Stock-Market RC 1 / 虛擬股市
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=26706
使用版本：phpBB 2.0.3
狀況描述：執行此段sql語法

CREATE TABLE phpbb_stocks (
   stock_id mediumint(8) DEFAULT '0' NOT NULL,
   stock_des text,
   stock_name char(100) DEFAULT '0' NOT NULL,
   stock_start_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_volume mediumint(8) DEFAULT '0' NOT NULL,
   stock_yesterday_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_today_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_maximum_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_minimum_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_onhold mediumint(8) DEFAULT '0' NOT NULL,
   stock_buy mediumint(8) DEFAULT '0' NOT NULL,
   stock_sell mediumint(8) DEFAULT '0' NOT NULL,
   stock_stopped tinyint(1) DEFAULT '0' NOT NULL,
   stock_stopped_time varchar(255) DEFAULT '0' NOT NULL,
   KEY stock_id (stock_id),
);

會出現錯誤訊息(sql傳回)

代碼: 選擇全部

#1064 - You have an error in your SQL syntax near ')' at line 16

該不會又是我版本太舊的關係吧!嗚嗚..各為大大救救我吧!!

發表於 : **2004-06-24 17:14**

應該是寫錯了

執行這一段就OK

代碼: 選擇全部

CREATE TABLE phpbb_stocks (
   stock_id mediumint(8) DEFAULT '0' NOT NULL,
   stock_des text,
   stock_name char(100) DEFAULT '0' NOT NULL,
   stock_start_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_volume mediumint(8) DEFAULT '0' NOT NULL,
   stock_yesterday_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_today_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_maximum_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_minimum_value mediumint(8) DEFAULT '0' NOT NULL,
   stock_onhold mediumint(8) DEFAULT '0' NOT NULL,
   stock_buy mediumint(8) DEFAULT '0' NOT NULL,
   stock_sell mediumint(8) DEFAULT '0' NOT NULL,
   stock_stopped tinyint(1) DEFAULT '0' NOT NULL,
   stock_stopped_time varchar(255) DEFAULT '0' NOT NULL,
   KEY stock_id (stock_id));

其餘不變

竹貓星球

[問題]虛擬股市無法執行sql

[問題]虛擬股市無法執行sql