announcement_centre_1_0_1安裝問題

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

版主: 版主管理群譯文組

版面規則
請注意!您的提問必須遵守發問格式,違者砍文。
主題已鎖定
Hinckley
星球普通子民
星球普通子民
文章: 17
註冊時間: 2008-03-24 03:39

announcement_centre_1_0_1安裝問題

文章 Hinckley »

●主機作業系統:window
●安裝的程式: php + MySql
● phpBB 版本: phpBB 3.0.1
●網域名稱: joyfulpets-house.com
●phpBB 連結網址: http://www.joyfulpets-house.com/phpBB3/index.php
●安裝風格:subsilver2
●安裝外掛:announcement_centre_1_0_1

致心靈捕手老師,又有事情麻煩您!這個公告中心的外掛安裝我又出現問題,以下是我上存的檔案:

代碼: 選擇全部

root/adm/style/acp_announcement_centre.html, 
root/includes/functions_announcements.php, 
root/includes/acp/acp_announcements_centre.php, 
root/includes/acp/info/acp_announcements_centre.php, 
root/language/zh_cmn_hant/mods/announcement_centre.php,
root/language/zh_cmn_hant/mods/info_acp_announcement_centre.php,
root/language/en/mods/announcement_centre.php, 
root/language/en/mods/info_acp_announcement_centre.php, 
root/styles/subsilver2/template/announcement_centre.html, 
root/styles/subsilver2/template/announcement_smilies.html, 
root/styles/subsilver2/imageset/birthday.png 
root/contrib/upgrade030to100.xml
root/contrib/upgrade100bto101.xml
root/contrib/upgrade100to100b.xml
並且我已照install.xml修改以下的檔案:

代碼: 選擇全部

root/includes/constants.php, 
root/includes/functions.php, 
root/includes/functions_posting.php, 
root/language/en/common.php, 
root/language/zh_cmn_hant/common.php, 
root/posting.php, 
root/index.php, 
styles/subsilver2/template/overall_header.html 
然後我再進入ACP作增加模組,再進入「公告中心」一欄:
未命名1.JPG
未命名1.JPG (89.68 KiB) 已瀏覽 7795 次
結果便出現以下:
未命名.JPG
未命名.JPG (78.33 KiB) 已瀏覽 7792 次
當我進入「PHPMYADMIN」執行SQL時:
未命名3.JPG
未命名3.JPG (174.79 KiB) 已瀏覽 7792 次
想請教我在哪個步驟出錯?謝謝!
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8540
註冊時間: 2004-04-30 01:54
來自: Taiwan

Re: announcement_centre_1_0_1安裝問題

文章 心靈捕手 »

建議您:
進 phpMyAdmin
貼出論壇資料庫 (joyfulp_data) 的 '結構' 圖
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
~倉木麻衣~
竹貓忠實會員
竹貓忠實會員
文章: 1405
註冊時間: 2004-03-21 21:00

Re: announcement_centre_1_0_1安裝問題

文章 ~倉木麻衣~ »

從你貼的圖來看, 你資料庫的table_prefix名稱應該是phpbb3
但是這個外掛預設是以phpbb_當做為table_prefix
所以會發生找不到資料庫的錯誤

解決方式有二個
1.
刪除phpbb_announcement_centre資料表, 將後將原本的SQL語法

代碼: 選擇全部

CREATE TABLE phpbb_announcement_centre
改成
CREATE TABLE phpbb3announcement_centre
2.
直接進phpMyAdmin修改資料表名稱為phpbb3announcement_centre
先點選phpbb_announcement_centre資料表, 再按管理
資料表選項中有一個將資料表改名為的輸入框, 輸入phpbb3announcement_centre, 再按執行即可
謝絕所有私人訊息詢問外掛相關問題
有問題請直接於版上發表, 集思廣議絕對比專挑特定人士詢問來的好

竹貓禁止發表含破解相關的軟體, 違者砍文
不要跟我講別的地方都可以發, 為什麼竹貓就不行
免費不等於破解, 傻傻的搞不清楚
Hinckley
星球普通子民
星球普通子民
文章: 17
註冊時間: 2008-03-24 03:39

Re: announcement_centre_1_0_1安裝問題

文章 Hinckley »

~倉木麻衣~ 寫:從你貼的圖來看, 你資料庫的table_prefix名稱應該是phpbb3
但是這個外掛預設是以phpbb_當做為table_prefix
所以會發生找不到資料庫的錯誤

解決方式有二個
1.
刪除phpbb_announcement_centre資料表, 將後將原本的SQL語法

代碼: 選擇全部

CREATE TABLE phpbb_announcement_centre
改成
CREATE TABLE phpbb3announcement_centre
2.
直接進phpMyAdmin修改資料表名稱為phpbb3announcement_centre
先點選phpbb_announcement_centre資料表, 再按管理
資料表選項中有一個將資料表改名為的輸入框, 輸入phpbb3announcement_centre, 再按執行即可
謝謝倉木麻衣的指教,我已試過你所提及的兩種方法,結果仍未順利進行,以下是我的joyfulp_data結構圖:

代碼: 選擇全部

joyfulp_data (162) 

 phpbb3acl_groups 
 phpbb3acl_options 
 phpbb3acl_roles 
 phpbb3acl_roles_data 
 phpbb3acl_users 
 phpbb3announcement_centre 
 phpbb3attachments 
 phpbb3banlist 
 phpbb3bbcodes 
 phpbb3bookmarks 
 phpbb3bots 
 phpbb3config 
 phpbb3confirm 
 phpbb3disallow 
 phpbb3drafts 
 phpbb3extensions 
 phpbb3extension_groups 
 phpbb3forums 
 phpbb3forums_access 
 phpbb3forums_track 
 phpbb3forums_watch 
 phpbb3groups 
 phpbb3icons 
 phpbb3lang 
 phpbb3log 
 phpbb3moderator_cache 
 phpbb3modules 
 phpbb3poll_options 
 phpbb3poll_votes 
 phpbb3posts 
 phpbb3privmsgs 
 phpbb3privmsgs_folder 
 phpbb3privmsgs_rules 
 phpbb3privmsgs_to 
 phpbb3profile_fields 
 phpbb3profile_fields_data 
 phpbb3profile_fields_lang 
 phpbb3profile_lang 
 phpbb3ranks 
 phpbb3reports 
 phpbb3reports_reasons 
 phpbb3search_results 
 phpbb3search_wordlist 
 phpbb3search_wordmatch 
 phpbb3sessions 
 phpbb3sessions_keys 
 phpbb3sitelist 
 phpbb3smilies 
 phpbb3styles 
 phpbb3styles_imageset 
 phpbb3styles_imageset_data 
 phpbb3styles_template 
 phpbb3styles_template_data 
 phpbb3styles_theme 
 phpbb3topics 
 phpbb3topics_posted 
 phpbb3topics_track 
 phpbb3topics_watch 
 phpbb3users 
 phpbb3user_group 
 phpbb3warnings 
 phpbb3words 
 phpbb3zebra 
 phpbb3_announcement_centre 
 phpbb_announcement_centre 
 phpbb_auth_access 
 phpbb_banlist 
 phpbb_categories 
 phpbb_config 
 phpbb_configacl_groups 
 phpbb_configacl_options 
 phpbb_configacl_roles 
 phpbb_configacl_roles_data 
 phpbb_configacl_users 
 phpbb_configattachments 
 phpbb_configbanlist 
 phpbb_configbbcodes 
 phpbb_configbookmarks 
 phpbb_configbots 
 phpbb_configconfig 
 phpbb_configconfirm 
 phpbb_configdisallow 
 phpbb_configdrafts 
 phpbb_configextensions 
 phpbb_configextension_groups 
 phpbb_configforums 
 phpbb_configforums_access 
 phpbb_configforums_track 
 phpbb_configforums_watch 
 phpbb_configgallery_albums 
 phpbb_configgallery_comments 
 phpbb_configgallery_config 
 phpbb_configgallery_images 
 phpbb_configgallery_rates 
 phpbb_configgroups 
 phpbb_configicons 
 phpbb_configlang 
 phpbb_configlog 
 phpbb_configmoderator_cache 
 phpbb_configmodules 
 phpbb_configpoll_options 
 phpbb_configpoll_votes 
 phpbb_configposts 
 phpbb_configprivmsgs 
 phpbb_configprivmsgs_folder 
 phpbb_configprivmsgs_rules 
 phpbb_configprivmsgs_to 
 phpbb_configprofile_fields 
 phpbb_configprofile_fields_data 
 phpbb_configprofile_fields_lang 
 phpbb_configprofile_lang 
 phpbb_configranks 
 phpbb_configreports 
 phpbb_configreports_reasons 
 phpbb_configsearch_results 
 phpbb_configsearch_wordlist 
 phpbb_configsearch_wordmatch 
 phpbb_configsessions 
 phpbb_configsessions_keys 
 phpbb_configsitelist 
 phpbb_configsmilies 
 phpbb_configstyles 
 phpbb_configstyles_imageset 
 phpbb_configstyles_imageset_data 
 phpbb_configstyles_template 
 phpbb_configstyles_template_data 
 phpbb_configstyles_theme 
 phpbb_configtopics 
 phpbb_configtopics_posted 
 phpbb_configtopics_track 
 phpbb_configtopics_watch 
 phpbb_configusers 
 phpbb_configuser_group 
 phpbb_configwarnings 
 phpbb_configwords 
 phpbb_configzebra 
 phpbb_confirm 
 phpbb_disallow 
 phpbb_forums 
 phpbb_forum_prune 
 phpbb_groups 
 phpbb_posts 
 phpbb_posts_text 
 phpbb_privmsgs 
 phpbb_privmsgs_text 
 phpbb_ranks 
 phpbb_search_results 
 phpbb_search_wordlist 
 phpbb_search_wordmatch 
 phpbb_sessions 
 phpbb_sessions_keys 
 phpbb_smilies 
 phpbb_themes 
 phpbb_themes_name 
 phpbb_topics 
 phpbb_topics_watch 
 phpbb_users 
 phpbb_user_group 
 phpbb_vote_desc 
 phpbb_vote_results 
 phpbb_vote_voters 
 phpbb_words 
~倉木麻衣~
竹貓忠實會員
竹貓忠實會員
文章: 1405
註冊時間: 2004-03-21 21:00

Re: announcement_centre_1_0_1安裝問題

文章 ~倉木麻衣~ »

重新仔細看了一下錯誤訊息, 發現它去找的table竟然是phpbb_configannouncement_centre
看來你應該先檢查一下includes/constants.php有沒有改錯
謝絕所有私人訊息詢問外掛相關問題
有問題請直接於版上發表, 集思廣議絕對比專挑特定人士詢問來的好

竹貓禁止發表含破解相關的軟體, 違者砍文
不要跟我講別的地方都可以發, 為什麼竹貓就不行
免費不等於破解, 傻傻的搞不清楚
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8540
註冊時間: 2004-04-30 01:54
來自: Taiwan

Re: announcement_centre_1_0_1安裝問題

文章 心靈捕手 »

~倉木麻衣~ 寫:重新仔細看了一下錯誤訊息, 發現它去找的table竟然是phpbb_configannouncement_centre
看來你應該先檢查一下includes/constants.php有沒有改錯
奇怪! 他這個類似的錯誤怎麼老是發生呢?
http://phpbb-tw.net/phpbb/viewtopic.php?f=133&t=50937

我猜想:
他使用的資料表檔頭是 'phpbb_config'.
Hinckley 寫:謝謝倉木麻衣的指教,我已試過你所提及的兩種方法,結果仍未順利進行,以下是我的joyfulp_data結構圖:

代碼: 選擇全部

    joyfulp_data (162)

    phpbb3acl_groups
    phpbb3acl_options
    phpbb3acl_roles
    phpbb3acl_roles_data
    phpbb3acl_users
    phpbb3announcement_centre
    phpbb3attachments
    phpbb3banlist
    phpbb3bbcodes
    phpbb3bookmarks
    phpbb3bots
    phpbb3config
    phpbb3confirm
    phpbb3disallow
    phpbb3drafts
    phpbb3extensions
    phpbb3extension_groups
    phpbb3forums
    phpbb3forums_access
    phpbb3forums_track
    phpbb3forums_watch
    phpbb3groups
    phpbb3icons
    phpbb3lang
    phpbb3log
    phpbb3moderator_cache
    phpbb3modules
    phpbb3poll_options
    phpbb3poll_votes
    phpbb3posts
    phpbb3privmsgs
    phpbb3privmsgs_folder
    phpbb3privmsgs_rules
    phpbb3privmsgs_to
    phpbb3profile_fields
    phpbb3profile_fields_data
    phpbb3profile_fields_lang
    phpbb3profile_lang
    phpbb3ranks
    phpbb3reports
    phpbb3reports_reasons
    phpbb3search_results
    phpbb3search_wordlist
    phpbb3search_wordmatch
    phpbb3sessions
    phpbb3sessions_keys
    phpbb3sitelist
    phpbb3smilies
    phpbb3styles
    phpbb3styles_imageset
    phpbb3styles_imageset_data
    phpbb3styles_template
    phpbb3styles_template_data
    phpbb3styles_theme
    phpbb3topics
    phpbb3topics_posted
    phpbb3topics_track
    phpbb3topics_watch
    phpbb3users
    phpbb3user_group
    phpbb3warnings
    phpbb3words
    phpbb3zebra
    phpbb3_announcement_centre
    phpbb_announcement_centre
    phpbb_auth_access
    phpbb_banlist
    phpbb_categories
    phpbb_config
    phpbb_configacl_groups
    phpbb_configacl_options
    phpbb_configacl_roles
    phpbb_configacl_roles_data
    phpbb_configacl_users
    phpbb_configattachments
    phpbb_configbanlist
    phpbb_configbbcodes
    phpbb_configbookmarks
    phpbb_configbots
    phpbb_configconfig
    phpbb_configconfirm
    phpbb_configdisallow
    phpbb_configdrafts
    phpbb_configextensions
    phpbb_configextension_groups
    phpbb_configforums
    phpbb_configforums_access
    phpbb_configforums_track
    phpbb_configforums_watch
    phpbb_configgallery_albums
    phpbb_configgallery_comments
    phpbb_configgallery_config
    phpbb_configgallery_images
    phpbb_configgallery_rates
    phpbb_configgroups
    phpbb_configicons
    phpbb_configlang
    phpbb_configlog
    phpbb_configmoderator_cache
    phpbb_configmodules
    phpbb_configpoll_options
    phpbb_configpoll_votes
    phpbb_configposts
    phpbb_configprivmsgs
    phpbb_configprivmsgs_folder
    phpbb_configprivmsgs_rules
    phpbb_configprivmsgs_to
    phpbb_configprofile_fields
    phpbb_configprofile_fields_data
    phpbb_configprofile_fields_lang
    phpbb_configprofile_lang
    phpbb_configranks
    phpbb_configreports
    phpbb_configreports_reasons
    phpbb_configsearch_results
    phpbb_configsearch_wordlist
    phpbb_configsearch_wordmatch
    phpbb_configsessions
    phpbb_configsessions_keys
    phpbb_configsitelist
    phpbb_configsmilies
    phpbb_configstyles
    phpbb_configstyles_imageset
    phpbb_configstyles_imageset_data
    phpbb_configstyles_template
    phpbb_configstyles_template_data
    phpbb_configstyles_theme
    phpbb_configtopics
    phpbb_configtopics_posted
    phpbb_configtopics_track
    phpbb_configtopics_watch
    phpbb_configusers
    phpbb_configuser_group
    phpbb_configwarnings
    phpbb_configwords
    phpbb_configzebra
    phpbb_confirm
    phpbb_disallow
    phpbb_forums
    phpbb_forum_prune
    phpbb_groups
    phpbb_posts
    phpbb_posts_text
    phpbb_privmsgs
    phpbb_privmsgs_text
    phpbb_ranks
    phpbb_search_results
    phpbb_search_wordlist
    phpbb_search_wordmatch
    phpbb_sessions
    phpbb_sessions_keys
    phpbb_smilies
    phpbb_themes
    phpbb_themes_name
    phpbb_topics
    phpbb_topics_watch
    phpbb_users
    phpbb_user_group
    phpbb_vote_desc
    phpbb_vote_results
    phpbb_vote_voters
    phpbb_words 
建議您:
1. 確認論壇使用的資料表檔頭 ('phpbb_' 'phpbb_config' 或 'phpbb3' ?), 刪除不必要的資料表.
2. 若要外掛安裝順利, 則以保持預設的檔頭 'phpbb_' 為宜.
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
Hinckley
星球普通子民
星球普通子民
文章: 17
註冊時間: 2008-03-24 03:39

Re: announcement_centre_1_0_1安裝問題

文章 Hinckley »

致老師:
照你所言,其實我整個phpbb3架構是否存在問題?不況直言,若是?對我論壇影響是否很大?
另外我這個外掛,在PHPMYADMIN執行sql,照install.xml:

代碼: 選擇全部

CREATE TABLE phpbb_announcement_centre (
  announcement_show tinyint (1) NOT NULL,
  announcement_enable_guests tinyint (1) NOT NULL,
  announcement_show_birthdays tinyint (1) NOT NULL,
  announcement_birthday_avatar tinyint (1) NOT NULL,
  announcement_draft text NOT NULL,
  announcement_draft_bbcode_uid varchar(8) NOT NULL,
  announcement_draft_bbcode_bitfield varchar(255) NOT NULL,
  announcement_draft_bbcode_options mediumint(4) NOT NULL,
  announcement_text text NOT NULL,
  announcement_text_bbcode_uid varchar(8) NOT NULL,
  announcement_text_bbcode_bitfield varchar(255) NOT NULL,
  announcement_text_bbcode_options mediumint(4) NOT NULL,
  announcement_text_guests text NOT NULL,
  announcement_text_guests_bbcode_uid varchar(8) NOT NULL,
  announcement_text_guests_bbcode_bitfield varchar(255) NOT NULL,
  announcement_text_guests_bbcode_options mediumint(4) NOT NULL,
  announcement_title varchar(255) NOT NULL default '',
  announcement_title_guests varchar(255) NOT NULL default '',
  announcement_show_group varchar(255) NOT NULL default '')
  CHARACTER SET utf8 COLLATE utf8_bin;
  

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_enable', '1');

其中
第一行CREATE TABLE phpbb_announcement_centre 更改為CREATE TABLE phpbb3_announcement_centre
第二十二行INSERT INTO phpbb_announcement_centre 更改為INSERT INTO phpbb3_announcement_centre
我的ACP版面可以順利顯示出,但在論壇版面則無法顯示,希望老師可以指教,謝!
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8540
註冊時間: 2004-04-30 01:54
來自: Taiwan

Re: announcement_centre_1_0_1安裝問題

文章 心靈捕手 »

Hinckley 寫:致老師:
照你所言,其實我整個phpbb3架構是否存在問題?不況直言,若是?對我論壇影響是否很大?
另外我這個外掛,在PHPMYADMIN執行sql,照install.xml:

代碼: 選擇全部

CREATE TABLE phpbb_announcement_centre (
  announcement_show tinyint (1) NOT NULL,
  announcement_enable_guests tinyint (1) NOT NULL,
  announcement_show_birthdays tinyint (1) NOT NULL,
  announcement_birthday_avatar tinyint (1) NOT NULL,
  announcement_draft text NOT NULL,
  announcement_draft_bbcode_uid varchar(8) NOT NULL,
  announcement_draft_bbcode_bitfield varchar(255) NOT NULL,
  announcement_draft_bbcode_options mediumint(4) NOT NULL,
  announcement_text text NOT NULL,
  announcement_text_bbcode_uid varchar(8) NOT NULL,
  announcement_text_bbcode_bitfield varchar(255) NOT NULL,
  announcement_text_bbcode_options mediumint(4) NOT NULL,
  announcement_text_guests text NOT NULL,
  announcement_text_guests_bbcode_uid varchar(8) NOT NULL,
  announcement_text_guests_bbcode_bitfield varchar(255) NOT NULL,
  announcement_text_guests_bbcode_options mediumint(4) NOT NULL,
  announcement_title varchar(255) NOT NULL default '',
  announcement_title_guests varchar(255) NOT NULL default '',
  announcement_show_group varchar(255) NOT NULL default '')
  CHARACTER SET utf8 COLLATE utf8_bin;
  

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_enable', '1');

其中
第一行CREATE TABLE phpbb_announcement_centre 更改為CREATE TABLE phpbb3_announcement_centre
第二十二行INSERT INTO phpbb_announcement_centre 更改為INSERT INTO phpbb3_announcement_centre
我的ACP版面可以順利顯示出,但在論壇版面則無法顯示,希望老師可以指教,謝!
多說無益!

再次, 建議您:
1. 確認論壇使用的資料表檔頭 ('phpbb_' 'phpbb_config' 或 'phpbb3' ?), 刪除不必要的資料表.
2. 修改後, 貼出論壇資料庫 (joyfulp_data) 的 '結構' 圖
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
主題已鎖定

回到「[3.0.x] 外掛問題討論」