Title: Server error on log file Last modified: May 14, 2024 --- # Server error on log file * Resolved [John](https://wordpress.org/support/users/dsl225/) * (@dsl225) * [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/) * Hello, I got some of those similar errors at my server log file: * ```wp-block-code [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](https://wordpress.org/support/users/vmarko/) * (@vmarko) * [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/#post-17754721) * Hello [@dsl225](https://wordpress.org/support/users/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](https://wordpress.org/plugins/database-collation-fix/#description) 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](https://wordpress.org/support/users/dsl225/) * (@dsl225) * [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/#post-17755560) * 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](https://wordpress.org/support/users/vmarko/) * (@vmarko) * [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/#post-17757119) * Hey [@dsl225](https://wordpress.org/support/users/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](https://wordpress.org/support/users/dsl225/) * (@dsl225) * [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/#post-17757169) * 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. * ![](https://ps.w.org/w3-total-cache/assets/icon-256x256.png?rev=1041806) * [W3 Total Cache](https://wordpress.org/plugins/w3-total-cache/) * [Frequently Asked Questions](https://wordpress.org/plugins/w3-total-cache/#faq) * [Support Threads](https://wordpress.org/support/plugin/w3-total-cache/) * [Active Topics](https://wordpress.org/support/plugin/w3-total-cache/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/w3-total-cache/unresolved/) * [Reviews](https://wordpress.org/support/plugin/w3-total-cache/reviews/) * 4 replies * 2 participants * Last reply from: [John](https://wordpress.org/support/users/dsl225/) * Last activity: [2 years, 1 month ago](https://wordpress.org/support/topic/server-error-on-log-file/#post-17757169) * Status: resolved