Hello,
I apologize for the server error you are experiencing. Unfortunately, I cannot access external links or content outside of this platform. If you can provide me with the details or error message directly here, I’ll do my best to assist you. Feel free to share the error message or any relevant details so we can troubleshoot the issue together.
Thank you for your understanding.
Sources:
Why Am I Getting “API Error: HTTP 400” Error » Rank Math
How to Fix the ‘Blocked Due to Other 4xx Issue’ Error » Rank Math
How To Fix Blocked Due to Access Forbidden (403) Error in Google Search Console » Rank Math
Hello,
To fix this, 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/
Hope that helps.
Sorry, what do you mean by “fix this” please?
I don’t understand how your answer relates to my question.
For clarity I also posted one of those errors here as it was possible to post it without being blocked:
https://wordpress.org/support/topic/server-errors-3/
Hello,
The error shows that there are some issues with how data is sorted and compared in the database and using the ‘Fix Collation’ tool will fix the issue on your website.
Please head over to WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click the Fix Collations button to fix the collations in the database:
Let us know how this goes.
Thank you.
Thanks Adetayo, I see what you mean.
Nevertheless, I see that some portions of this error reference spammy links and Chinese characters that are nowhere to be found at my site, like those:
WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%👉k8seo.com👈谷歌官方seo外推-谷歌外推工具下载官网281%’) OR (wp_posts.post_excerpt LIKE ‘%👉k8seo.com👈谷歌官方seo外推-谷歌外推工具下载官网281%’) OR (wp_posts.post_content LIKE ‘%👉k8seo.com👈谷歌官方seo外推-谷歌外推工具下载官网281%’))) AND
and those:
FROM wp_rank_math_redirections WHERE status = ‘active’ AND ( sources like ‘%a:2:{s:7:”pattern”;s:75:”?s=👉k8seo.com👈谷歌官方seo外推-谷歌外推工具下载官网281″;s:10:”comparison”;s:5:”exact”;}%’ or sources like ‘%?s=👉k8seo%’ or sources like ‘%com👈谷歌官方seo外推%’ or sources like ‘%谷歌外推工具下载官网281%’ ) ORDER BY updated DESC made by require(‘wp-blog-header.php’)…
Are those something to be further investigated or do they sound like to only relate to “collations” that you mention?
Thanks.
Hello,
Those characters pertain to data that is available on the database of the website but that is outside the control of our plugin.
The first example is looking for the post title which contains those strings and emojis but we don’t have any control over the post title as that is added by the people writing on the website.
Don’t hesitate to get in touch if you have any other questions.
Hello, all passwords have now been changed but those errors continue flooding the server.
We are only 2 admins that can post content on this site and we cannot find any trace of those posts.
In addition, I just found that the related posts, although not published, are also listed in Google Search Console (see captures below) and I really cannot understand how they can be listed there – even if not indexed – if there is no trace of them in the DB or elsewhere. Any clues? Thanks.
GSC screen captures: https://cloudup.com/clYlOlsPPoE
Hello,
Given that the pages on GSC it means that your website is currently with malware so you really need to make a complete security audit of the website and clean any malware you see on it.
You can also do a live test of one of those pages on GSC and see what is the referring page so you can check where Google is picking them up.
Don’t hesitate to get in touch if you have any other questions.
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.
