Database error

#411021

Resolved Benn Warren
3 years, 5 months ago

Rank Math free

I have been searching the internet trying to resolve what seems to be a database issue with your plug in on one of the websites I look after, could you please help?

The Error

WordPress database error: [Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation ‘=’]
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 ( 949, 26, 12, 3, 14, 16, 846 ) and t1.created BETWEEN Now() – interval 36 day and Now() – interval 3 day GROUP BY t2.object_id

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

Reinelle
3 years, 5 months ago

Hello,

Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.

For initial troubleshooting, please click this button in Rank Math > Status & Tools > Database Tools:
https://rankmath.com/kb/rank-math-status-and-tools/#fix-analytics-table-collations

Please note that some options are only available when you enable the Advanced Mode in Rank Math. If it’s not showing, you must have chosen to use Easy Mode. Please follow the steps in this link to switch to Advanced Mode:
https://rankmath.com/kb/advanced-mode/

Once done, clear your website’s cache and check again.

Let us know how this goes.

Thank you.

Benn Warren
3 years, 5 months ago

Rank Math free

This worked thank you

Reinelle
3 years, 5 months ago

Hello,

We are super happy that this issue is already resolved. If you have any other questions in the future, know that we are here to help you.

If you don’t mind us asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

If you have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

Thank you.

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

The ticket ‘Database error’ is closed to new replies.