WordPress database error Illegal mix of collations - utf8mb4_unicode_520_ci - Support

Resolved Anonymous
1 year, 5 months ago

Rank Math free

I upgraded to new version of Rank Math, but it doesn’t work well. Constant errors with: WordPress database error Illegal mix of collations – utf8mb4_unicode_520_ci and utf8mb4_unicode_c. Mr. developer, maybe you don’t know what unicode collation you need to assign? I will say that the module must contain utf8mb4_general_ci in all db fields. Quickly make corrections so that the module is not thrown by error and check all fields to have the necessary utf settings.

Code sample:

WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query SELECT t2.object_id, SUM(t1.pageviews) AS traffic FROM wp_rank_math_analytics_ga AS t1 Left JOIN wp_rank_math_analytics_objects AS t2 ON t1.page=t2.page WHERE t2.object_id IN ( 27049, 23135, 22899, 22613, 22592, 22534, 22044, 21879, 21877, 21875, 21869, 21864, 21830, 21377, 21235, 21232, 21126, 21103, 20959, 20800 ) and t1.created BETWEEN Now() - inte

Viewing 3 replies - 1 through 3 (of 3 total)

RankBot
1 year, 5 months ago
Hello,

I apologize for the issue you are facing with the Rank Math module and the database collations error. It seems like there is a mismatch in the collations used in your WordPress database, causing the error message “Illegal mix of collations – utf8mb4_unicode_520_ci and utf8mb4_unicode_ci.”

To resolve this issue, you can follow these steps:
1. Check the Database charset of your WordPress site by navigating to WordPress Dashboard → Tools → Site Health → Info → Database. Ensure that the Database charset is set to utf8mb4, as recommended by WordPress.
2. If the charset is not set to utf8mb4, contact your web host to update the charset and then update the library again.
If these steps do not resolve the issue, please reply to this ticket, and a human agent from the Rank Math Support team will assist you further.

Thank you for bringing this concern to our attention. We are here to help you with any further assistance you may need.

Warm regards.

Sources:
Resolving Rank Math Analytics Related Issues » Rank Math
How to Use RankBot, Your Own AI-Powered Chat Assistant » Rank Math
WordPress Database Error Commands Out of Sync; You Can’t Run This Command Now » Rank Math
How to Fix the Error Establishing a Database Connection in WordPress » Rank Math
How to Fix the Error Establishing a Database Connection in WordPress » Rank Math
Anonymous
1 year, 5 months ago

Rank Math free

Database charset is set to utf8mb4, as recommended by WordPress.

Rakibuzzaman Siam
1 year, 5 months ago

Hello,

Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.

The “Illegal mix of collations” error in WordPress occurs when there is a mismatch in collation settings between different database tables or columns.

To fix this, please navigate to WP Dashboard > Rank Math > Status & Tools > Database Tools and click on the button “Fix Collations”: https://rankmath.com/kb/rank-math-status-and-tools/#fix-analytics-table-collations

Let us know how it goes. Looking forward to helping you.

Thank you.

RankBot
1 year, 4 months ago

Hello,

Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)

The ticket ‘WordPress database error Illegal mix of collations – utf8mb4_unicode_520_ci’ is closed to new replies.