Background of the issue:
I see strange entries in my error log related to WPML. I've reported this before and tried the suggestion to click a button to reset something in the database. It didn't clear up the error.
Symptoms:
I expected to not see these errors in my server log. Instead, I got: [04-Jun-2024 01:48:25 UTC] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS wpsv_posts.ID FROM wpsv_posts LEFT JOIN wpsv_icl_translations wpml_translations ON wpsv_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wpsv_posts.post_type) WHERE 1=1 AND (((wpsv_posts.post_title LIKE '%權威的Oracle 1z0-1066-22 最新題庫是行業領先材料&完美的1z0-1066-22 最新考證 ✔ 透過✔ hidden link ️✔️搜索➡ 1z0-1066-22 ️⬅️免費下載考試資料1z0-1066-22熱門考題%') OR (wpsv_posts.post_excerpt LIKE '%權威的Oracle 1z0-1066-22 最新題庫是行業領先材料&完美的1z0-1066-22 最新考證 ✔ 透過✔ hidden link ️✔️搜索➡ 1z0-1066-22 ️⬅️免費下載考試資料1z0-1066-22熱門考題%') OR (wpsv_posts.post_content LIKE '%權威的Oracle 1z0-1066-22 最新題庫是行業領先材料&完美的1z0-1066-22 最新考證 ✔ 透過✔ hidden link ️✔️搜索➡ 1z0-1066-22 ️⬅️免費下載考試資料1z0-1066-22熱門考題%'))) AND (wpsv_posts.post_password = '') AND ((wpsv_posts.post_type = 'post' AND (wpsv_posts.post_status = 'publish' OR wpsv_posts.post_status = 'wc-ywraq-new' OR wpsv_posts.post_status = 'wc-ywraq-pending' OR wpsv_posts.post_status = 'wc-ywraq-expired' OR wpsv_posts.post_status = 'wc-ywraq-accepted' OR wpsv_posts.post_status = 'wc-ywraq-rejected')) OR (wpsv_posts.post_type = 'page' AND (wpsv_posts.post_status = 'publish' OR wpsv_posts.post_status = 'wc-ywraq-new' OR wpsv_posts.post_status = 'wc-ywraq-pending' OR wpsv_posts.post_status = 'wc-ywraq-expired' OR wpsv_posts.post_status = 'wc-ywraq-accepted' OR wpsv_posts.post_status = 'wc-ywraq-rejected')) OR (wpsv_posts.post_type = 'attachment' AND (wpsv_posts.post_status = 'publish' OR wpsv_posts.post_status = 'wc-ywraq-new' OR wpsv_posts.post_status = 'wc-ywraq-pending' OR wpsv_posts.post_status = 'wc-ywraq-expired' OR wpsv_posts.post_status = 'wc-ywraq-accepted' OR wpsv_posts.post_status = 'wc-ywraq-rejected')) OR (wpsv_posts.post_type = 'product' AND (wpsv_posts.post_status = 'publish' OR wpsv_posts.post_status = 'wc-ywraq-new' OR wpsv_posts.post_status = 'wc-ywraq-pending' OR wpsv_posts.post_status = 'wc-ywraq-expired' OR wpsv_posts.post_status = 'wc-ywraq-accepted' OR wpsv_posts.post_status = 'wc-ywraq-rejected')) OR (wpsv_posts.post_type = 'envira' AND (wpsv_posts.post_status = 'publish' OR wpsv_posts.post_status = 'wc-ywraq-new' OR wpsv_posts.post_status = 'wc-ywraq-pending' OR wpsv_posts.post_status = 'wc-ywraq-expired' OR wpsv_posts.post_status = 'wc-ywraq-accepted' OR wpsv_posts.post_status = 'wc-ywraq-rejected'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wpsv_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','ywraq-pdf-template','wpcf7_contact_form','slide','envira' ) ) OR wpsv_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','ywraq-pdf-template','wpcf7_contact_form','slide','envira' ) ) ORDER BY wpsv_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
Questions:
Where do I find my past support tickets?
Thank you for contacting WPML support, I’m happy to help you with this issue.
There is an issue with the database collation on your site (Illegal mix of collations). I suggest you go to WPML > Support > Troubleshooting > Click on the button "Fix WPML table collation" and see if it helps.
If not, you can use a third-party plugin Database Collation Fix (https://wordpress.org/plugins/database-collation-fix/) and set all tables' collation to "utf8mb4_unicode_520_ci".
❌ IMPORTANT: Please backup your database and website before proceeding ❌
A previous support rep suggested that I click the button "Fix WPML table collation" and it did not fix the issue. I have installed the plugin you recommend and in the drop down choices, I do not see the one you suggest. Instead I have these choices. See uploaded image. Which one should I select?
I suggest you try the first collation option "utf8mb4_unicode_ci" and recheck the issue.
❌ IMPORTANT: Please backup your database and website before proceeding ❌
Looking forward to your reply.
Thanks
The topic ‘[Closed] I see strange entries in my error log related to WPML’ is closed to new replies.