[教學] attach_mod_v237 成功安裝法分享

[koach]

請問

如果phpbb2.000當初已經裝好了attach_mod

那麼現在phpbb升為2.017，那有關attach_mod的安裝，是否也要重來一次呢?

自問自答一下：ｐ

升為2.017之後，沒法用attach_mod，不過因為我沒有裝其它的mod，所以就去原始網站http://www.opentools.de/board/viewtopic.php?t= ... b3f9b41747
把Pre-modified files for phpBB 2.0.17 抓下來用\r
然後直接蓋過原來升級完的phpBB 2.0.17的根目錄，目前就是OK的了

[juke500]

佩服

[NOKIA]

辛苦了﹐
不過看見這些碼已經頭痛了﹐
其實有沒有簡單的方法﹖
比如說把修改好的檔給其他朋友COPY & PASTE﹖

[問題狂]

辛苦了﹐
不過看見這些碼已經頭痛了﹐
其實有沒有簡單的方法﹖
比如說把修改好的檔給其他朋友COPY & PASTE﹖

看看吧:
http://www.phpbb-tw.net/phpbb/viewtopic.php?t=22832
儲飛友人想提供給你已經修改完成的檔案

[kartwide]

呼..我也跟著改，成功囉!!
有點苦盡甘來的感覺 哈
謝謝大大這麼用心寫教學

[tory]

執行mod_table_inst.php(http://localhost/phpBB2/root/install/mod_table_inst.php)出現了以下的錯誤
(我用的是 phpBB 2.0.4，attach_mod_v239)
Warning: Failed opening './../extension.inc' for inclusion (include_path='') in d:\webservice\phpbb2
oot\install\mod_table_inst.php on line 26

Warning: Failed opening './../common.' for inclusion (include_path='') in d:\webservice\phpbb2
oot\install\mod_table_inst.php on line 27

Fatal error: Call to undefined function: session_pagestart() in d:\webservice\phpbb2
oot\install\mod_table_inst.php on line 29


請問是版本的問題嗎？還是我那裡弄錯了？麻煩大家了，謝謝！

請問一下 我跟你出現一樣的問題 請問你是修改哪些地方 最後才可以安裝成功阿??

[問題狂]

你檔案複製路就錯誤了
應該把Root內的檔案複製到PHPBB的根目錄才對
不是把整個Root資料夾複製到PHPBB內

[tory]

你檔案複製路就錯誤了
應該把Root內的檔案複製到PHPBB的根目錄才對
不是把整個Root資料夾複製到PHPBB內

出現以下錯誤

Installing Attachment Mod

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.14') -> 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

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

[問題狂]

可能是因為你已經執行過了
刪掉該檔即可

[tory]

你是說 刪掉 install ?

之後我去看 系統管理那 Attachments 和 Extensions

好像是新增的 點他的裡面的選項 都會出現錯誤的字 有些是 有出現表格 可以讓你改 可是 都沒有出現字那些

[問題狂]

請描述你的錯誤訊息\r

PS 建議你另開主題

[tory]

問題狂 我寄給你 帳號 密碼 你幫我去 系統管理看比較快 要不要?

先問過你 你好像叫我不要 發私人訊息給你>"<

[問題狂]

我想不必了
只要把你的錯誤代碼貼上來或是附張圖片即可\r

PS PM是用來聯絡私事 不是用來發問的 所以有問題還是在版面內發表比較好

[tory]

Control Panel 出現以下錯誤

Fatal error: Call to undefined function: get_var() in d:\appserv\www\phpbb2\admin\admin_attach_cp.php on line 62

管理選項 出現以下錯誤

表格沒有字出現\r

Quota limits 出現以下錯誤

表格沒有字出現\r


Sync attachments 出現以下錯誤

Sync Topics
.
..

Sync Posts


Sync Thumbnails

Extension group manage 出現以下錯誤

Fatal error: Call to undefined function: get_var() in d:\appserv\www\phpbb2\admin\admin_extensions.php on line 539

Special categories 出現以下錯誤

Fatal error: Call to undefined function: is_imagick() in d:\appserv\www\phpbb2\admin\admin_attachments.php on line 874

[問題狂]

我顯示因為你修改檔案時錯誤了
建議你全部重新再比對一次