• Resolved John

    (@dsl225)


    Hello,
    I got some of those similar errors at my server log file:

    [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 they relate directly to W3? Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @dsl225

    Thank you for reaching out and I am happy to help!

    The problem is that all tables do not use compatible collations. As WordPress is not very strict with collations, your own WordPress website might also use different collations on different tables.
    To eliminate this error, we have to convert all tables to use compatible collations. It’s usually best to use only one collation for all of them. With WordPress 4.2.0 the collation utf8mb4 became the new standard. All database tables created after this update will be created with one of these collation variants.

    I would advise checking this with your hosting provider or trying this plugin that also fixes this issue by changing the collation of all columns in your database to use the same algorithm, removing the “mix” of collations.

    I hope this helps!

    Thanks!

    Thread Starter John

    (@dsl225)

    Many thanks Marko for your help.
    I see what you mean and I’ll do that for sure.

    Nevertheless, I see that several portions of those errors reference spammy links and Chinese characters that are nowhere to be found at my site (thoughly scanned), 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 again.

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hey @dsl225

    Thank you for your feedback.
    I am not sure what this is exaclty, howver it’s related to SEO so you should check this with your SEO plugin support Rank Math

    Thanks!

    Thread Starter John

    (@dsl225)

    Thanks’, will do, no problem.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Server error on log file’ is closed to new replies.