FlashLearners

Education And Career Blog

  • HOME
  • APPS
  • VIDEOS
Home / Blogging

Solution To Yoast Plugin Unable to Create Database Tables After Update

Yoas Object Indexing

Modified On Apr 28, 2020

After updating my Yoast SEO Plugin to the Latest Version, I got a warning that Yoast SEO was unable to create the database tables required and as such will not function correctly. You may be experiencing the same issue.

I tried following the link to the “helpful article” provided by Yoast. The article stated that Yoast SEO shows an error message when unable to create database tables automatically and you need to contact your hosting to do it for you. The good news is that you can fix the issue yourself without any live chat with Hostgator, Godaddy, Namecheap, Bluehost, iPage, etc.

To fix this issue of Unable to create Database after Yoast SEO Plugin update, simply login to your Cpanel, locate file manage and open the wp-config.php file. Look for the line define(‘DB_COLLATE’, ‘utf8mb4_unicode_ci’); and change it to define(‘DB_COLLATION’, ‘utf8_general_ci’);

Step By Step Guide To Solve Yoast SEO Database Creation Issue

Yoast Site Speed Up

  1. Login to your hosting Control Panel (Cpanel)
  2. Locate File Manage
  3. Click on Your Site (Open Public_html if your site is in the root)
  4. Scroll down to wp-config.php
  5. Look for the line define(‘DB_COLLATE’, ‘utf8mb4_unicode_ci’);
  6. Replace it with define(‘DB_COLLATION’, ‘utf8_general_ci’);
  7. Log in to your WordPress Dashboard
  8. Clear all Caches if you are using Cloudflare or Caching Plugin
  9. Refresh the error page in your Wp-admin
  10. Yoast can now speed up your site, Click to speed up your site
  11. Wait for Indexation, don’t close the page or change Tab to avoid error (We’re processing all of your content to speed it up! This may take a few minutes).
  12. Good job! You’ve sped up your site.

Recommended: Onpage SEO Guide

Note: if you found define(‘DB_COLLATION’, ‘utf8_general_ci’); in your wp-config.php instead of the later, you can still replace it with define(‘DB_COLLATE’, ‘utf8mb4_unicode_ci’);. This will solve your problem. You may also want to backup your database before taking any action.

Comment below if this solves your problem. Do not fail to share with others using the share buttons below. I wish you happy blogging…

Related

How To Skip Gutenberg And Keep Using The Old WordPress Editor
bloggers and computer
Bloggers How Many Hours Do You Spend On Your Blog Daily?
blog niche, domain, hosting
Why You Should Use Hostgator Web Hosting
Avatar

About FlashIsaac

FlashLearners CEO, Students Advocate, SEO Expert And YouTuber

6 Comments

  1. shaikat says

    This tips not solve my sissue, still show the error.

    Reply
    • Isaac Inegbenehi says

      Update it to the latest version now. The new Yoast Update has fixed the issue

      Reply
  2. David says

    For me, this was not the solution :-(. I have to say than I did not have a line with “define(‘DB_COLLATE’, ‘utf8mb4_unicode_ci’);” on my “wp-config.php”; My line had “define(‘DB_COLLATE’, ”);”

    Reply
    • Isaac Inegbenehi says

      How did you resolve your own? Or did you wait for the next Yoast SEO Update?

      Reply
  3. sam says

    Mine is doing something else wrong…

    “Object 50866 of 1391 processed.” and still increasing!

    Reply
    • Isaac Inegbenehi says

      Stop and restart the process

      Reply

Leave a Reply Cancel reply

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

CHOOSE TOPIC

  • FlashLearners Videos
  • Special Study Guide
  • FlashLearners Tech
  • Ongoing Scholarships
  • Flash Learners Quiz
  • Jamb And Direct Entry
  • National Youth Service
  • Blogging & SEO Guide
  • Complete O'Level Guide

STUDY GUIDE

Covenant University (CU) Departments And Courses

10 Reasons You Perform Poorly In External Exams

Hot Cake Steps To Pass IELTS In 2023

33 Categories Of Students In Any School [2023]

Continue ↠

© 2016 - 2023 FlashLearners

Home · About · Contact · Privacy · Disclaimer