[問題] vault_100 股票市場 SQL 語法 (自解了)

文章由 **kkt** » 2006-05-10 18:16

問題外掛 : vault_100 股票市場
參考連結 : http://phpbb-tw.net/phpbb/viewtopic.php ... =vault_100

已裝可能有關連的外掛

WaterMonster RPG Full Version - 水怪 RPG 完整安裝版 1.0.3
Cash Mod 金錢外掛 2.2.2a
付費瀏覽 1.09

裝在版本 : 2.015
論壇語言編碼 : big-5
資料庫語言編碼 : utf-8 版本 : phpMyAdmin 2.6.4-pl4
MySQL 版本 4.1.10a-standard

=======================================

狀況描述 :

我在phpMyAdmin 執行 SQL 語法, 結果有一行傳回錯誤, 查不出原因 :

代碼: 選擇全部

SQL 語法: 

INSERT INTO kktfriend_vault_exchange( stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price ) 
VALUES ( 1, 'Vault_action_name_1', 'Vault_action_desc_1', 30, 100, 100, 100, 100, 2 ) 
MySQL 傳回：  

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

意思好像說 : #1136 - 列計算的價值不匹配在第1 排數

但我除了資料表頭外, 沒改動過其他數值, 請問大大或師長知原因嗎 ? 謝謝!!

自解了: 反覆執行失敗後, 刪除再用 vault_db_update.php 在後台單獨執行該部份語法. 成功了.
.

文章由 **心靈捕手** » 2006-05-11 06:43

仔細比較此外掛關於 '資料庫更新' 的檔案, 可能有部分必須修正.
1. Vault.txt
2. root/vault_db_update.php

以下的修改, 提供您參考:
#
#-----[ OPEN ]-----
#
vault_db_update.php

#
#-----[ FIND ]-----
#

$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 100, 100, 100, 100)";
$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 200, 200, 200, 200)";
$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 300, 300, 300, 300)";

#
#-----[ REPLACE WITH ]-----
#

$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 100, 100, 100, 100, 2)";
$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 200, 200, 200, 200, 2)";
$sql[] = "INSERT INTO " . $table_prefix . "vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 300, 300, 300, 300, 2)";

#
#-----[ OPEN ]-----
#
Vault.txt

#
#-----[ FIND ]-----
#

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 30, 100, 100, 100, 100,2 );
INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 30, 200, 200, 200, 200,2 );
INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 30, 300, 300, 300, 300,2 );

#
#-----[ REPLACE WITH ]-----
#

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 30, 100, 100, 100, 100, 2);
INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 30, 200, 200, 200, 200, 2);
INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total, stock_price, stock_previous_price, stock_best_price, stock_worst_price, chairman) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 30, 300, 300, 300, 300, 2);

#
#-----[ SAVE & CLOSE ]-----
#
#EoM

文章由 **kkt** » 2006-05-11 20:05

多謝老師大清早留言指導.

我現有的情況是:

除了上文執行 SQL 語法遇到執行上出現錯誤.

安裝後衹需先行買入股票, 接菁出現錯誤. (正是所有裝此外掛的所遭遇一樣)

但不理會它, 再進入股票版面. 操作便正常了.

============================================

請問老師一句, 我目前的操作及功能, 沒有異常. 那要不要再從新執行老師的 SQL 好呢 ? 這 chairman 加入後有何影響性 ?

我絕非躲懶不想執行, 其實我發覺原作者應該是未完成此外掛的. 我也改動了 10% 以上.

因為這外掛執行真的很不順利, 我重刪執行也幾次, 每次都有一段半段失敗!! 有點沒信心保證能否再寫入.

多謝老師!!

.

文章由 **心靈捕手** » 2006-05-11 21:52

kkt 寫:
請問老師一句, 我目前的操作及功能, 沒有異常. 那要不要再從新執行老師的 SQL 好呢 ? 這 chairman 加入後有何影響性 ?

1. 這是寫給別人參考用的, 尤其是一樣有需要, 用手動輸入 SQL 指令者;
您不必重新輸入.
1. 加不加 'chairman' 沒有影響, 因為預設值為 '2'.