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 *


We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.