• Resolved John

    (@dsl225)


    Hello,

    Since 2 days I’m getting some errors on server log file similar to this one:

    [12-May-2024 19:40:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
    					 FROM wp_posts 
    					 WHERE 1=1  AND (((wp_posts.post_title LIKE '%[tpsuc.com]cpu%') OR (wp_posts.post_excerpt LIKE '%[tpsuc.com]cpu%') OR (wp_posts.post_content LIKE '%[tpsuc.com]cpu%')) AND ((wp_posts.post_title LIKE '%slot??offline%') OR (wp_posts.post_excerpt LIKE '%slot??offline%') OR (wp_posts.post_content LIKE '%slot??offline%')) AND ((wp_posts.post_title LIKE '%slot%') OR (wp_posts.post_excerpt LIKE '%slot%') OR (wp_posts.post_content LIKE '%slot%')) AND ((wp_posts.post_title LIKE '%games??945%') OR (wp_posts.post_excerpt LIKE '%games??945%') OR (wp_posts.post_content LIKE '%games??945%')))  AND (wp_posts.post_password = '')  AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish')))
    					 
    					 ORDER BY (CASE WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 1 WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu%' AND wp_posts.post_title LIKE '%slot??offline%' AND wp_posts.post_title LIKE '%slot%' AND wp_posts.post_title LIKE '%games??945%' THEN 2 WHEN wp_posts.post_title LIKE '%[tpsuc.com]cpu%' OR wp_posts.post_title LIKE '%slot??offline%' OR wp_posts.post_title LIKE '%slot%' OR wp_posts.post_title LIKE '%games??945%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 4 WHEN wp_posts.post_content LIKE '%[tpsuc.com]cpu slot??offline slot games??945%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
    					 LIMIT 0, 20 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    [12-May-2024 19:40:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like' for query SELECT * FROM wp_rank_math_redirections WHERE status = 'active' AND ( sources like '%a:2:{s:7:\"pattern\";s:51:\"?s=[tpsuc.com]cpu slot??offline slot games??945\";s:10:\"comparison\";s:5:\"exact\";}%' or sources like '%?s=[tpsuc%' or sources like '%com]cpu slot??offline slot games??945%' ) ORDER BY updated DESC made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Redirections\Redirections->do_redirection, RankMath\Redirections\Redirector->__construct, RankMath\Redirections\Redirector->flow, RankMath\Redirections\Redirector->everything, RankMath\Redirections\DB::match_redirections, RankMath\Admin\Database\Query_Builder->get, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

    Do those relate to RankMath directly or not?

    Thanks.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @dsl225,
    ?
    Thank you for contacting Rank Math support.
    ?
    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.

    Thread Starter John

    (@dsl225)

    Thanks, will do that but was also wondering whether those portions like this one that contain spammy texts and chinese characters (that are nowhere to be found at the site) indicate another problem or if this is only due to collations?

    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’),

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @dsl225,
    ?
    That message indicates that the plugin is looking for a redirection that includes that in the source URL. That is either coming from a redirection you added or it could also be from a particular page/post that is triggering the redirections module.
    ?
    You should look on your website to see if you have any page or redirection with those values.
    ?
    Don’t hesitate to get in touch if you have any other questions.

    Thread Starter John

    (@dsl225)

    Many thanks for your feedback.
    This is also what I thought but there is nothing with those values at the site and I really scanned thoroughly, including the DB.
    Just last question if you don’t mind: could this indicate an intrusion attempt of some sort?

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @dsl225,
    ?
    Please check the Redirections section of our plugin to confirm if there is a redirection there. Some redirection rules can be merged and have multiple source URLs. You can edit them to check all the source URLs.
    ?
    Looking forward to helping you.

    Thread Starter John

    (@dsl225)

    Just checked and there is not a single one in there…
    That’s why I find those errors very strange and that they maybe hide another problem.

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @dsl225,
    ?
    Did you make a search on the database tables for some of the words in those entries? It’s possible that those are not visible on the WordPress Dashboard but they are still on the database.
    ?
    If you can’t find entries with those strings in the database it’s possible that they were deleted between the 12th of May, when the error happened, and today.
    ?
    Don’t hesitate to get in touch if you have any other questions.

    Thread Starter John

    (@dsl225)

    Thanks, but yes I did search the DB. Problem is those errors still continue daily!
    I’m just asking your thoughts about this, not a solution, so that I can move to the right direction for solving the issue.

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @dsl225,
    ?
    Those messages are from May 12th so it’s possible that the data that was causing this is no longer present on the website and it was deleted.
    ?
    If you don’t see the messages after that date on the error log it’s because the situation was corrected and no longer exists on the website.
    ?
    Don’t hesitate to get in touch if you have any other questions.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Server errors’ is closed to new replies.