Solution To Yoast Plugin Unable to Create Database Tables After Update

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.

Blast 2021 Exams With Flash Learners

Applications: Get Jamb CBT App, Waec App, Bece App, Ncee App, Ijmb & Ican App.

Win Prizes: Install Any Flashlearners App to Win Up ₦30,000 While Learning.

 CLICK HERE TO INSTALL & EARN 

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

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…

Other Ways Flash Learners Can Boost Your Academic Performance

Subjects: Learn Mathematics, English, Chemistry, Physics, Art And Social Science Subjects.

Exams: Free Classes For Ncee, Bece, Waec, Neco, Jamb, Post Utme, Ijmb and ICAN.

 CLICK HERE TO START LEARNING

RECOMMENDED

1. WAEC AND JAMB APPLICATIONS
2. GET MY NEW POSTS FOR FREE

WHAT ELSE DO YOU WANT?

1. SEARCH FLASH LEARNERS
2. COMPLETE JAMB GUIDE
3. ABOUT BECE, WAEC AND NECO
4. VACANCIES AND JOBS GUIDE
5. NEWS FROM YOUR SCHOOL
6. ACADEMIC AND CAREER GUIDE
7. SPECIAL TOPICS FOR PARENTS

• Author
• Recent Posts

Follow me

Isaac Inegbenehi

CEO at Flashlearners

Welcome To Flashlearners: I'm Flashisaac; Students Advocate, SEO Expert And A Blogger From The Future. Learn More

Follow me

Latest posts by Isaac Inegbenehi (see all)

• The Best CBT Apps - Apr 15, 2021
• Jamb Score 2021 That Guarantees Your Admission - Apr 15, 2021
• Jamb CBT Update To Boost Your Jamb 2021 Score - Apr 15, 2021