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.
From the error log, your site’s getting an Illegal mix of collations error in your database.
To fix this, please navigate to 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
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.
You can follow the steps in this link to switch to Advanced Mode:
https://rankmath.com/kb/advanced-mode/
Hope that helps.
Hey,
Thanks but where does it come from? It looks like a spam post? Does this script say its executed and my website spams stuff?
Hello,
The error you’re seeing in the debug log is related to a collation issue between different character sets (utf8mb3 and utf8mb4) in your database, and it’s not caused by any spam activity. The error occurs when WordPress is trying to process certain queries and is encountering a mix of collations. This issue is likely due to some data (such as post titles, content, or even redirections) containing different character sets, possibly including special characters or text from different languages.
As for the content that appears to be spam in the query, it is just part of the database search. However, we recommend you also enable a security plugin or use moderation tools to prevent spam from being posted to your site.
Hope that helps, and please do not hesitate to let us know if you need our assistance with anything else.
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.
