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]

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

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

你進入其他table看看, 比對一下就知道了^^