ACP Announcement Centre (公告中心)安裝問題(SQL)

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

版主: 版主管理群譯文組

版面規則
請注意!您的提問必須遵守發問格式,違者砍文。
主題已鎖定
野比小雄
星球公民
星球公民
文章: 129
註冊時間: 2005-02-17 18:08
來自: 107年後的某處
聯繫:

ACP Announcement Centre (公告中心)安裝問題(SQL)

文章 野比小雄 »

●主機作業系統:Linux
●您安裝的程式:MySql 4.0.27
●您的 phpBB 版本:phpBB 3.0.1

●安裝外掛:announcement_centre_1_0_1
http://phpbb-tw.net/phpbb/viewtopic.php?f=132&t=50829

於PHPMYADMIN輸入:

代碼: 選擇全部

CREATE TABLE phpbb3_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 phpbb3_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 phpbb3_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb3_config (config_name, config_value) VALUES ('announcement_enable', '1');
出現EEROR

代碼: 選擇全部

錯誤

SQL 語法:

CREATE TABLE phpbb3_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;

MySQL 傳回: 說明文件
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_bin' at line 21 
是否我的SQL SERVER過舊?

jwxinst
竹貓忠實會員
竹貓忠實會員
文章: 945
註冊時間: 2006-03-31 10:07
來自: New York, USA     學業狀況: 當天才...       個人狀況: 臭蛋
聯繫:

Re: ACP Announcement Centre (公告中心)安裝問題(SQL)

文章 jwxinst »

對, 這句不要就可以了
) CHARACTER SET utf8 COLLATE utf8_bin;
你的是4.0.27, 這是常見的問題
因為set是4.1以後的事情

你create了以後, 你只要自己手動去set utf8和utf8_bin就好了

你進入其他table看看, 比對一下就知道了^^
目前狀態圖檔
GoKo Music進度: 10%

問個問題不要緊可是沒有發文格式、問題不夠詳細情況,難道要用猜嗎?
新手必讀
[教學] 基本認識、學習、隨我架設phpBB的新手通 -更新至2.0.22
問問題的技巧
http://www.phpbb-tw.net/phpbb/viewtopic.php?t=44340
MOD安裝教學及轉碼
http://www.phpbb-tw.net/phpbb/viewtopic.php?t=22832

主題已鎖定

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