Not working: One or more FULLTEXT indices are missing

Did it work after recreating the index? Also, which host are you on? Some of the hosts have disallowed this plugin because of the FULLTEXT index

I’m having the same problem. I’ve clicked the “Recreate Index” button several times, but the plugin keeps telling me that “One or more FULLTEXT indices are missing”

I’m running a local development environment using MAMP 3.5.2 on a MacBook Pro with OS 10.9.5. (I’ve no idea how to run queries in phpMyAdmin.)

If you’re running MAMP, you can open up phpMyAdmin under Webstart > Tools. Open the table in the left. Then hit SQL tab and run the queries which are at the bottom of the Settings page. Typically this.

ALTER TABLE wp_posts DROP INDEX crp_related;
ALTER TABLE wp_posts DROP INDEX crp_related_title;
ALTER TABLE wp_posts DROP INDEX crp_related_content;
ALTER TABLE wp_posts ADD FULLTEXT crp_related (post_title, post_content);
ALTER TABLE wp_posts ADD FULLTEXT crp_related_title (post_title);
ALTER TABLE wp_posts ADD FULLTEXT crp_related_content (post_content);

Running those commands results in the following message:

Error

SQL query:

ALTER TABLE wp_posts DROP INDEX crp_related

MySQL said: Documentation
#1091 – Can’t DROP ‘crp_related’; check that column/key exists

I know the table exists. I have 150 posts and 3 woocommerce products in my development installation.

I have the same problem since I switched to version 5.0.2. I have other sites running under 4.9.9 and CRP works perfectly.

i have create this request

CREATE INDEX crp_related
ON wp_posts (post_title)

Response :

MySQL a répondu : Documentation

#1170 – La colonne ‘post_title’ de type BLOB est utilisée dans une définition d’index sans longueur d’index

What if you run only this command? It needs to be full text

ALTER TABLE wp_posts ADD FULLTEXT crp_related (post_title, post_content);

Requête SQL :

ALTER TABLE XXXXX_posts ADD FULLTEXT crp_related (post_title, post_content)

MySQL a répondu : Documentation

#1214 - Le type de table utilisé ne supporte pas les index FULLTEXT

En : #1214 – The type of table used does not support FULLTEXT indexes

that’s the problem.

I use this Norwegian web hosting company servetheworld.net – They told me that the issue most likely was that the MySQL was not up to date, and that they could update it for me but that it would be pretty pricey. I might update it myself though if you think this could be the a fix for it.

• This reply was modified 5 years, 10 months ago by alekseo.

I think you might have an InnoDB table for wp_posts from a much older version of mySQL which doesn’t support FULLTEXT.

This is a preferred storage engine for various reasons particularly if you have very huge number of posts.

If upgrading is not an option, you can always try to change this to myISAM which was the older engine, has FULLTEXT support and works for the older versions of mySQL.

You could change it using this code in phpMyAdmin:

ALTER TABLE XXXXX_posts ENGINE = MyISAM; And then run the code to create the FULLTEXT

Note, with the latest version of WordPress, the recommended requirements have changed.