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?
Languages: English (English )Vietnamese (Vietnamese )
Timezone: Asia/Ho_Chi_Minh (GMT+07:00)
Hi Charlene,
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?
Languages: English (English )Vietnamese (Vietnamese )
Timezone: Asia/Ho_Chi_Minh (GMT+07:00)
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.