[問題]執行mod_table_inst.php出現網頁錯誤[問題解決]

phpBB 2 MOD Support
無論是官方或非官方認證之外掛，安裝與使用問題討論。
(發表文章請按照公告格式發表，違者砍文)

版主: 版主管理群

主題已鎖定
小翔
星球普通子民
星球普通子民
文章: 5
註冊時間: 2004-12-20 20:14
來自: taipei
聯繫:
聯繫 小翔

[問題]執行mod_table_inst.php出現網頁錯誤[問題解決]

文章 由 小翔 »

●架設主機作業系統：Windows 2003 Server
●快速架站程式：Appserv 2.4.2
●您的上網方式：SeedNet ADSL 2mb/512kb
●您安裝的程式：Apache + php + MySql 2.4.2
●您的 phpBB2 版本：phpBB 2.1.1
●您的 domain(網域名稱) ：phspub.idv.tw
●安裝外掛：Attachment Mod Version 2.3.11 +v2.39的中文語系\r
●您的 phpBB2 連結網址： http://www.phspub.idv.tw/phpbb/install/ ... e_inst.php

網頁錯誤:[ code ]Running :: CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) ) -> FAILED ---> Table 'phpbb_attachments_config' already exists

Running :: CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) ) -> FAILED ---> Table 'phpbb_forbidden_extensions' already exists

Running :: CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) ) -> FAILED ---> Table 'phpbb_extension_groups' already exists

Running :: CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) ) -> FAILED ---> Table 'phpbb_extensions' already exists

Running :: CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) ) -> FAILED ---> Table 'phpbb_attachments_desc' already exists

Running :: CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) ) -> FAILED ---> Table 'phpbb_attachments' already exists

Running :: CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) ) -> FAILED ---> Table 'phpbb_quota_limits' already exists

Running :: CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) ) -> FAILED ---> Table 'phpbb_attach_quota' already exists

Running :: ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'auth_download'

Running :: ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'auth_download'

Running :: ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'post_attachment'

Running :: ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'topic_attachment'

Running :: ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'privmsgs_attachment'

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files') -> FAILED ---> Duplicate entry 'upload_dir' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/icon_clip.gif') -> FAILED ---> Duplicate entry 'upload_img' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/icon_clip.gif') -> FAILED ---> Duplicate entry 'topic_icon' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0') -> FAILED ---> Duplicate entry 'display_order' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144') -> FAILED ---> Duplicate entry 'max_filesize' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800') -> FAILED ---> Duplicate entry 'attachment_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144') -> FAILED ---> Duplicate entry 'max_filesize_pm' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3') -> FAILED ---> Duplicate entry 'max_attachments' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1') -> FAILED ---> Duplicate entry 'max_attachments_pm' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0') -> FAILED ---> Duplicate entry 'disable_mod' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1') -> FAILED ---> Duplicate entry 'allow_pm_attach' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0') -> FAILED ---> Duplicate entry 'attachment_topic_review' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0') -> FAILED ---> Duplicate entry 'allow_ftp_upload' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0') -> FAILED ---> Duplicate entry 'show_apcp' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.3.11') -> FAILED ---> Duplicate entry 'attach_version' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0') -> FAILED ---> Duplicate entry 'default_upload_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0') -> FAILED ---> Duplicate entry 'default_pm_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','') -> FAILED ---> Duplicate entry 'ftp_server' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','') -> FAILED ---> Duplicate entry 'ftp_path' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','') -> FAILED ---> Duplicate entry 'download_path' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','') -> FAILED ---> Duplicate entry 'ftp_user' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','') -> FAILED ---> Duplicate entry 'ftp_pass' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1') -> FAILED ---> Duplicate entry 'ftp_pasv_mode' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1') -> FAILED ---> Duplicate entry 'img_display_inlined' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0') -> FAILED ---> Duplicate entry 'img_max_width' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0') -> FAILED ---> Duplicate entry 'img_max_height' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0') -> FAILED ---> Duplicate entry 'img_link_width' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0') -> FAILED ---> Duplicate entry 'img_link_height' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0') -> FAILED ---> Duplicate entry 'img_create_thumbnail' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000') -> FAILED ---> Duplicate entry 'img_min_thumb_filesize' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '') -> FAILED ---> Duplicate entry 'img_imagick' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0') -> FAILED ---> Duplicate entry 'use_gd2' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0') -> FAILED ---> Duplicate entry 'wma_autoplay' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0') -> FAILED ---> Duplicate entry 'flash_autoplay' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi') -> FAILED ---> Duplicate entry '7' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (7,'Flash Files',3,0,1,'',0,'') -> FAILED ---> Duplicate entry '7' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1,'gif', '') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1,'png', '') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1,'jpg', '') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1,'tif', '') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1,'tga', '') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2,'gtar', '') -> FAILED ---> Duplicate entry '7' for key 1
\n
Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2,'gz', '') -> FAILED ---> Duplicate entry '8' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2,'tar', '') -> FAILED ---> Duplicate entry '9' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2,'zip', '') -> FAILED ---> Duplicate entry '10' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2,'rar', '') -> FAILED ---> Duplicate entry '11' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2,'ace', '') -> FAILED ---> Duplicate entry '12' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3,'txt', '') -> FAILED ---> Duplicate entry '13' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3,'c', '') -> FAILED ---> Duplicate entry '14' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3,'h', '') -> FAILED ---> Duplicate entry '15' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3,'cpp', '') -> FAILED ---> Duplicate entry '16' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3,'hpp', '') -> FAILED ---> Duplicate entry '17' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3,'diz', '') -> FAILED ---> Duplicate entry '18' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4,'xls', '') -> FAILED ---> Duplicate entry '19' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4,'doc', '') -> FAILED ---> Duplicate entry '20' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4,'dot', '') -> FAILED ---> Duplicate entry '21' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4,'pdf', '') -> FAILED ---> Duplicate entry '22' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4,'ai', '') -> FAILED ---> Duplicate entry '23' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4,'ps', '') -> FAILED ---> Duplicate entry '24' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4,'ppt', '') -> FAILED ---> Duplicate entry '25' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5,'rm', '') -> FAILED ---> Duplicate entry '26' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6,'wma', '') -> FAILED ---> Duplicate entry '27' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (28, 7,'swf', '') -> FAILED ---> Duplicate entry '28' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144) -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152) -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880) -> FAILED ---> Duplicate entry '3' for key 1


COMPLETE!

Some queries failed.
This is sometimes due to tables already there (from a previous installation), therefore please READ the errors and warnings and use common sense in interpreting them. Support is offered at http://www.opentools.de for questions you might have regarding those errors/warnings.

NOW DELETE THIS FILE
[ /code ]

●錯誤狀態：我把root裡的檔案跟語系檔複製到PHPBB的資料夾以後，執行mod_table_inst.php就出現了這樣的網頁錯誤，請問各位前輩，有辦法幫幫我解決這樣的問題嗎??謝謝...
最後由 小翔 於 2004-12-25 14:00 編輯，總共編輯了 1 次。
如果真心喜歡一個人，是對還是錯?
要是喜歡的人，不喜歡自己，那還有必要繼續喜歡下去嗎?
回頂端
webspirit
竹貓忠實會員
竹貓忠實會員
文章: 1354
註冊時間: 2004-02-16 12:01
來自: 精靈國度

文章 由 webspirit »

看來你已經裝過，因資料表與欄位值都已存在\r

你的

代碼: 選擇全部

 標籤幹嘛打成 [ code ]？
你送出前都不預覽的嗎？
回頂端
[ffs]hunej
星球公民
星球公民
文章: 260
註冊時間: 2004-08-22 14:34

文章 由 [ffs]hunej »

太危險了
你的網站可輕易進入phpMyAdmin
撿到一疊鈔票，原來是玩具鈔票，空歡喜一場。~~卡好勒

http://www.freepgs.com/hunej/phpBB2/
phpBB2 portal project+foxfireXD templates
回頂端
webspirit
竹貓忠實會員
竹貓忠實會員
文章: 1354
註冊時間: 2004-02-16 12:01
來自: 精靈國度

文章 由 webspirit »

昏倒！！！
任何人都能進資料庫！　 :-o :-o :-o
回頂端
小翔
星球普通子民
星球普通子民
文章: 5
註冊時間: 2004-12-20 20:14
來自: taipei
聯繫:
聯繫 小翔

文章 由 小翔 »

webspirit 寫:看來你已經裝過，因資料表與欄位值都已存在\r

你的

代碼: 選擇全部

 標籤幹嘛打成 [ code ]？
你送出前都不預覽的嗎？[/quote]


我把PHPBB整個都移除掉才安裝的.怎麼會安裝過呢??
請問大大 現在要怎麼辦???
那我在把Appserv 整ㄍ重新移除再安裝一次看看好了...
如果真心喜歡一個人，是對還是錯?
要是喜歡的人，不喜歡自己，那還有必要繼續喜歡下去嗎?
回頂端
小翔
星球普通子民
星球普通子民
文章: 5
註冊時間: 2004-12-20 20:14
來自: taipei
聯繫:
聯繫 小翔

文章 由 小翔 »

webspirit 寫:看來你已經裝過，因資料表與欄位值都已存在\r

你的

代碼: 選擇全部

 標籤幹嘛打成 [ code ]？
你送出前都不預覽的嗎？[/quote]



整個移除掉後，再重新安裝已經完全解決問題，感謝前輩的回應指教^^
如果真心喜歡一個人，是對還是錯?
要是喜歡的人，不喜歡自己，那還有必要繼續喜歡下去嗎?
回頂端
webspirit
竹貓忠實會員
竹貓忠實會員
文章: 1354
註冊時間: 2004-02-16 12:01
來自: 精靈國度

文章 由 webspirit »

我說「已經裝過」，指的是那外掛
其實只要把該外掛新增的資料表刪除後重新安裝該外掛即可\r
你的工程浩大了些，但似也解決了前述任何人可進資料庫的問題
恭喜　^^
回頂端
主題已鎖定

回到「外掛問題討論」