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.
Step – 3. Now you will see Status and Tools, you have to click on it.
Step – 4. Then you have to click on system status. Where by scrolling down you will see this message in the Error Log.
Step – 5. 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.
1. First Check Your 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.
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.
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.