Digital Marketing

WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) | How To Fix?

WordPress database error Illegal mix of collations1
Written by Editor N4GM

Hello friends, if you are also struggling to get your post indexed, then there can be many reasons for this which you can easily solve by watching many videos on YouTube. But I know why you are seeing this post because the knowledge given on YouTube is not useful to you.

Because even today people on YouTube are limited to only submitting your link to Google Search Console. But this issue is different, it is a part of Technical SEO. And this is visible in Error Log of your Rank Math plugin.

So first of all you do not have to worry about this because we are here to help you.

Where To Check “WordPress database error Illegal mix of collations” Issue?

Here are few steps you should take to check – WordPress database error Illegal mix of collations Error:

Step – 1. To see this error, you will have to login to the admin panel of your WordPress.

Step – 2. After this, you will move your mouse cursor over the Rank Math plugin visible on the left side and make a single click.

WordPress database error Illegal mix of collations

Step – 3. Now you will see Status and Tools, you have to click on it.

Learn More - Solved: Fatal Error: Uncaught TypeError: Array_merge(): Rankmath

Step – 4. Then you have to click on system status. Where by scrolling down you will see this message in the Error Log.

click on system status

Step – 5. Now Check the Status of your Error

Now Check the Status of your Error

“WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE)”

How To Solve The “WordPress database error Illegal mix of collations” Issue:

To solve this problem, you will first have to understand why this problem has arisen. According to me, this problem mainly arises due to one reason which is your php file not being updated.

Most of us setup our blog on WordPress, As we do not have much knowledge of coding due to which we only check the upcoming updates in the admin panel, But are not able to update the PHP version in our hosting c-pannel due to which this problem occurs.

Check It: How To Fix Failed Lightspeed Cache Purged?

1. First Check Your WordPress and Plugins Update

Wordpress and Plugins Update

The very first step you should take is to check your wordpress and plugins update. If any of them require to update keep update it.

2. Check Your PHP Version

Be sure to check the PHP version of your WordPress block. If you use Hostinger, then I will tell you how to check your PHP version and how to update it. You follow the steps I am writing; it is very easy.

Step – 1. First of all login to your C-Panel.

Step – 2. There, go to the website section and select the domain whose PHP version you want to check or update.

Learn More - Why You Should Always Back Up Your Git Repository

Step – 3. Now go to WordPress Overview and check the PHP version of your WordPress. If it is not the latest version, then click on the latest version given there and press the Update button given below.

 check the PHP version of your WordPress

Step – 4. Finish Update!

2. Download and Install “Database Collation Fix” Plugin

In most of such cases, I have seen that after the new update of the RankMath plugin, it is no longer compatible with the 7.0, 7.1, 7.2 and 7.3 or more version of PHP.

Due to which problems related to this type of database keep arising. In this situation, some files in the database get corrupted (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE). So it starts showing the error of WordPress database error Illegal mix of collations.

Fix Database Collation

To solve this issue you should download Database Collation Fix Plugin, After installing this plugin you should repair both the database files, by clicking on “Fix Database Collation” Button.

About the author

Editor N4GM

He is the Chief Editor of n4gm. His passion is SEO, Online Marketing, and blogging. Sachin Sharma has been the lead Tech, Entertainment, and general news writer at N4GM since 2019. His passion for helping people in all aspects of online technicality flows the expert industry coverage he provides. In addition to writing for Technical issues, Sachin also provides content on Entertainment, Celebs, Healthcare and Travel etc... in n4gm.com.

Leave a Comment