[問題]vault問題

[德仔]

請問大大~~

phpBB : Critical Error

Could not query config information in admin_board

DEBUG MODE

SQL Error : 1146 Table 'phpbb.vault_general_table' doesn't exist

SELECT * FROM VAULT_GENERAL_TABLE

Line : 33
File : c:\appserv\www\phpbb\admin\\admin_vault_exchange.php

怎辦?

[一刀流]

你沒有執行sql語法嗎?

[德仔]

http://phpbb-tw.net/phpbb/viewtopic.php ... ight=vault
內的步驟都做了

[webspirit]

可是 phpbb.vault_general_table 這個表並不存在啊

[flower]

仔細看看安裝說明中關於 SQL 的部份
#--------------[ SQL ]-------------
內的都要執行 看錯誤訊息是 phpbb_vault_general table 並不存在\r
應該是 SQL 指令沒執行或是執行不完全\r

因為 SQL 指令內有以下這段\r

代碼: 選擇全部

CREATE TABLE phpbb_vault_general (
  config_name varchar(255) NOT NULL default '',
  config_value int(15) NOT NULL default '0',
  PRIMARY KEY  (config_name)
) TYPE=MyISAM;

[德仔]

我巳打了
INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_name', 'Vault');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_use', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_time', '86400');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_last_change', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_profile', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_topics', '0');

CREATE TABLE phpbb_vault_blacklist (
user_id int(8) NOT NULL default '0',
user_due int(8) NOT NULL default '0',
PRIMARY KEY (user_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_vault_exchange (
stock_id int(8) NOT NULL default '0',
stock_name varchar(40) NOT NULL default '',
stock_desc varchar(255) NOT NULL default '',
stock_price int(8) NOT NULL default '0',
stock_previous_price int(8) NOT NULL default '0',
stock_best_price int(8) NOT NULL default '0',
stock_worst_price int(8) NOT NULL default '0',
PRIMARY KEY (stock_id)
) TYPE=MyISAM;

INSERT INTO phpbb_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);
INSERT INTO phpbb_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);
INSERT INTO phpbb_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);

CREATE TABLE phpbb_vault_exchange_users (
stock_id mediumint(8) NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
stock_amount mediumint(8) NOT NULL default '0',
KEY stock_id (stock_id),
KEY user_id (user_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_vault_general (
config_name varchar(255) NOT NULL default '',
config_value int(15) NOT NULL default '0',
PRIMARY KEY (config_name)
) TYPE=MyISAM;

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('vault_loan_enable', 1);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_rate', 4);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_time', 86400);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests', 15);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests_time', 864000);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_max_sum', 5000);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_requirements', 0);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_max_change', 10);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_min_change', 0);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('base_amount', 10);
INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('num_items', 30);

CREATE TABLE phpbb_vault_users (
owner_id int(8) NOT NULL default '0',
account_id int(8) NOT NULL default '0',
account_sum int(8) NOT NULL default '0',
account_time int(11) NOT NULL default '0',
loan_sum int(8) NOT NULL default '0',
loan_time int(11) NOT NULL default '0',
account_protect tinyint(1) NOT NULL default '0',
loan_protect tinyint(1) NOT NULL default '0',
newsletter tinyint(1) NOT NULL default '0',
PRIMARY KEY (owner_id)
) TYPE=MyISAM;

但回應是\r
MySQL 傳回：


#1062 - Duplicate entry 'vault_enable' for key 1

[webspirit]

CREATE TABLE phpbb_vault_general (
config_name varchar(255) NOT NULL default '',
config_value int(15) NOT NULL default '0',
PRIMARY KEY (config_name)
) TYPE=MyISAM;
你若有執行這段 SQL 指令，就不會有前述的訊息\r
而 Duplicate entry 'vault_enable' for key 1 是說此值已存在

[德仔]

做了
#1050 - Table 'phpbb_vault_general' already exists

[webspirit]

所以現在 phpbb_vault_general 這個表已存在啦　^^

[德仔]

但還是出\r
phpBB : Critical Error

Could not query config information in admin_board

DEBUG MODE

SQL Error : 1146 Table 'phpbb.vault_general_table' doesn't exist

SELECT * FROM VAULT_GENERAL_TABLE

Line : 33
File : c:\appserv\www\phpbb\admin\admin_vault_exchange.php

[webspirit]

見鬼了咧\r
你把 admin/admin_vault_exchange.php 裡的 FROM " . VAULT_GENERAL_TABLE ;
改成 FROM " VAULT_GENERAL_TABLE ;
或 FROM " _VAULT_GENERAL_TABLE ;
試試看

[德仔]

我放棄了= =搞了兩天都搞不好-_-

[webspirit]

那篇是動機大發的
不妨問他看看
只是他理不理你就不知道了　^^

[德仔]

謝謝各位