[問題] 安裝水怪SQL的問題

文章由 **minotaur** » 2005-08-05 10:50

INSERT INTO phpbb_rpg_items VALUES("108", "阿丁鳳凰號", "?#125;著這台鳳凰號, 可以讓您的速度達到每秒18倍光速！", "0", "0", "0", NULL, NULL, NULL, "15000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_items VALUES("109", "初級回復咒文", "回復10% / 50 * 職業Lv", "3", "3", "0", "3", NULL, NULL, "10000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "PL", "50");

我安裝水怪匯入SQL的時候109這項之後(含)都匯不進去耶,單選擇一行也不能,為什麼阿??

代碼: 選擇全部

INSERT INTO phpbb_rpg_items VALUES("109", "初級回復咒文", "回復10% / 50 * 職業Lv", "3", "3", "0", "3", NULL, NULL, "10000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "PL", "50");

錯誤訊息\r

代碼: 選擇全部

SQL 語法: 

INSERT INTO phpbb_rpg_items
VALUES (

"109", "初級回復咒文", "回復10% / 50 * 職業Lv", "3", "3", "0", "3", NULL , NULL , "10000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "PL", "50"
) 
MySQL 傳回：  

#1136 - Column count doesn't match value count at row 1

文章由 **minotaur** » 2005-08-05 11:31

代碼: 選擇全部

CREATE TABLE `phpbb_rpg_items` (
  `item_id` mediumint(8) unsigned NOT NULL auto_increment,
  `item_name` varchar(60) default NULL,
  `item_description` varchar(255) default NULL,
  `in_which_store` tinyint(1) default '0',
  `need_level` smallint(5) default '0',
  `custom_made` mediumint(8) default '0',
  `need_class` varchar(10) default NULL,
  `item_addition1` varchar(60) default NULL,
  `item_addition2` varchar(60) default NULL,
  `item_price` int(11) NOT NULL default '0',
  `item_spec_price` smallint(5) NOT NULL default '0',
  `item_type` tinyint(4) NOT NULL default '0',
  `item_position` tinyint(4) NOT NULL default '0',
  `item_order` smallint(5) default '0',
  `need_to_use` tinyint(1) default '0',
  `attack_property` decimal(4,1) default '0.0',
  `defense_property` decimal(4,1) default '0.0',
  `magic_property` decimal(4,1) default '0.0',
  `speed_property` decimal(4,1) default '0.0',
  `hp_property` decimal(4,1) default '0.0',
  `mp_property` decimal(4,1) default '0.0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;

看起來是不是多個欄位阿??

可是...哪兒是多出來的呢\r

109那行之後都是23格欄位耶\r

補充一點
我水怪是下載心靈捕手大大站上的版本

文章由 **心靈捕手** » 2005-08-05 15:54

minotaur 寫:

代碼: 選擇全部

CREATE TABLE `phpbb_rpg_items` (
  `item_id` mediumint(8) unsigned NOT NULL auto_increment,
  `item_name` varchar(60) default NULL,
  `item_description` varchar(255) default NULL,
  `in_which_store` tinyint(1) default '0',
  `need_level` smallint(5) default '0',
  `custom_made` mediumint(8) default '0',
  `need_class` varchar(10) default NULL,
  `item_addition1` varchar(60) default NULL,
  `item_addition2` varchar(60) default NULL,
  `item_price` int(11) NOT NULL default '0',
  `item_spec_price` smallint(5) NOT NULL default '0',
  `item_type` tinyint(4) NOT NULL default '0',
  `item_position` tinyint(4) NOT NULL default '0',
  `item_order` smallint(5) default '0',
  `need_to_use` tinyint(1) default '0',
  `attack_property` decimal(4,1) default '0.0',
  `defense_property` decimal(4,1) default '0.0',
  `magic_property` decimal(4,1) default '0.0',
  `speed_property` decimal(4,1) default '0.0',
  `hp_property` decimal(4,1) default '0.0',
  `mp_property` decimal(4,1) default '0.0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;

看起來是不是多個欄位阿??

可是...哪兒是多出來的呢\r

109那行之後都是23格欄位耶\r

補充一點
我水怪是下載心靈捕手大大站上的版本

很抱歉! 此處應該是( 原作者或本人) 當初在整合時有所疏忽.

您可以試試, 先執行後面的語法, 補足 2 個欄位:

代碼: 選擇全部

# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;

ps. 原外掛之 SQL.sql 已同步更新.

文章由 **minotaur** » 2005-08-08 00:37

心靈捕手寫: 您可以試試, 先執行後面的語法, 補足 2 個欄位:
代碼: 選擇全部
# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;
ps. 原外掛之 SQL.sql 已同步更新.

不能哦\r

代碼: 選擇全部

# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;

這個要在108-109中間加入\r
加在108之前會造成1~108錯誤 (欄位不足寫入)
例如:

代碼: 選擇全部

INSERT INTO phpbb_rpg_items VALUES("108", "阿丁鳳凰號", "?#125;著這台鳳凰號, 可以讓您的速度達到每秒18倍光速！", "0", "0", "0", NULL, NULL, NULL, "15000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0");

# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;

INSERT INTO phpbb_rpg_items VALUES("109", "初級回復咒文", "回復10% / 50 * 職業Lv", "3", "3", "0", "3", NULL, NULL, "10000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "PL", "50");

剛剛測試過
一定得加在108-109中間

文章由 **心靈捕手** » 2005-08-10 15:11

minotaur 寫:

心靈捕手寫: 您可以試試, 先執行後面的語法, 補足 2 個欄位:
代碼: 選擇全部
# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;
ps. 原外掛之 SQL.sql 已同步更新.

不能哦\r

代碼: 選擇全部

# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;

這個要在108-109中間加入\r
加在108之前會造成1~108錯誤 (欄位不足寫入)
例如:

代碼: 選擇全部

INSERT INTO phpbb_rpg_items VALUES("108", "阿丁鳳凰號", "?#125;著這台鳳凰號, 可以讓您的速度達到每秒18倍光速！", "0", "0", "0", NULL, NULL, NULL, "15000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0");

# ?#93;法特技學園
ALTER TABLE phpbb_rpg_items ADD need_mp1 varchar(4) default '0', ADD need_mp2 varchar(4) default '0';
DELETE FROM phpbb_rpg_items where in_which_store = 3;

INSERT INTO phpbb_rpg_items VALUES("109", "初級回復咒文", "回復10% / 50 * 職業Lv", "3", "3", "0", "3", NULL, NULL, "10000000", "0", "0", "0", "0", "0", "0.0", "0.0", "0.0", "0.0", "0.0", "0.0", "PL", "50");

剛剛測試過
一定得加在108-109中間

呵! 呵!
難怪會有很多人安裝水怪, 執行資料庫更新時, 出了問題.

用力回憶,...
此處應該是當初我自己把它" 弄巧成拙" 了.

原版應該不會有這個問題才對!
感謝指正!