Administrator Posted July 24, 2013 Share Posted July 24, 2013 If you have a database that was installed as innodb or was perhaps converted to innodb, it won't have the full text index on the tables after converting it back to Myisam. After converting, run the following queries to add back the stock full text indexs ALTER TABLE posts ADD FULLTEXT KEY post (post);ALTER TABLE topics ADD FULLTEXT KEY title (title);ALTER TABLE forums_archive_posts ADD FULLTEXT KEY archive_content (archive_content);ALTER TABLE message_posts ADD FULLTEXT KEY msg_post (msg_post);ALTER TABLE message_topics ADD FULLTEXT KEY mt_title (mt_title);ALTER TABLE blog_entries ADD FULLTEXT KEY entry_name (entry_name);ALTER TABLE cal_events ADD FULLTEXT (event_content);ALTER TABLE cal_events ADD FULLTEXT (event_title);ALTER TABLE downloads_files ADD FULLTEXT(file_desc);ALTER TABLE downloads_files ADD FULLTEXT(file_name);ALTER TABLE nexus_packages ADD FULLTEXT KEY p_name (p_name);ALTER TABLE nexus_packages ADD FULLTEXT KEY p_desc (p_desc);ALTER TABLE nexus_support_requests ADD FULLTEXT KEY r_title (r_title);ALTER TABLE nexus_support_replies ADD FULLTEXT KEY reply_post (reply_post); Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now