1 頁 (共 1 頁)

全文索引 SQL error

文章發表於 : 2008-12-06, 21:01
bananasims
一般性錯誤
SQL ERROR [ mysql4 ]

Column 'post_text' cannot be part of FULLTEXT index [1283]

SQL

ALTER TABLE phpbb_posts ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/search/fulltext_mysql.php
LINE: 738
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_search.php
LINE: 363
CALL: fulltext_mysql->create_index()

FILE: includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_search->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

又唔知搞乜鬼…

Re: 全文索引 SQL error

文章發表於 : 2008-12-07, 07:34
bananasims
搞掂,posts 資料表入面既 post_subject 同埋 post_text 改做 utf8_unicode_ci 就得。(原本 utf8_bin)