why?
Code: Select all
SQL ERROR [ mysqli ]
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/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/search/fulltext_mysql.php
LINE: 779
CALL: dbal_mysqli->sql_query()
FILE: includes/acp/acp_search.php
LINE: 365
CALL: fulltext_mysql->create_index()
FILE: includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_search->main()
FILE: adm/index.php
LINE: 77
CALL: p_master->load_active()
[edit]Fixed with this sql[/edit]
Step 1
Code: Select all
ALTER TABLE phpbb_acl_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_attachments CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_banlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bbcodes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bookmarks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bots CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_config CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_confirm CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_disallow CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_drafts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extensions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extension_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_access CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_icons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_log CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_moderator_cache CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_modules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_votes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_posts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_folder CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_rules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_to CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_ranks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports_reasons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_results CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordmatch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions_keys CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sitelist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_smilies CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_theme CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_posted CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_user_group CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_warnings CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_words CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_zebra CONVERT TO CHARACTER SET utf8;
Code: Select all
ALTER TABLE `phpbb_posts` ADD FULLTEXT (
`post_text`
)