Skip to content

The fulltext index fails to create on wp_posts

When you choose to use fulltext indexes, an admin notice will appear allowing you to create the fulltext index.

If the fulltext index on wp_posts fails to create, it is likely because the collation of one of the columns (post_title, post_content or post_excerpt) in your fulltext index is different from the others.

Inside MySQL (or the SQL executioner plugin) you can run this code to view your collations:

SHOW FULL COLUMNS FROM wp_posts;

In the example above, the post_excerpt column has a different collation from post_title and post_content. To change the collation, run the following SQL:

ALTER TABLE wp_posts modify column post_excerpt text not null collate utf8mb4_unicode_ci;

(change the collation after the word ‘collate’ to whatever collation you are using)

Once the ALTER TABLE command has completed, refresh your wp-admin page and click the button in the admin notice once more to create your fulltext index.

Did this article answer your question?

Leave a Reply

Your email address will not be published. Required fields are marked *


CYBERFUNDAY 40% discount coupon extended to Friday 9th December + join our Discord community and read the rules for an extra 20% discount coupon.