Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 -
- 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 -

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

This topic contains 3 replies, has 2 voices.

Last updated by Long Nguyen 8 months ago.

Assisted by: Long Nguyen.

Author Posts
June 8, 2024 at 1:17 am #15717949

charleneR-2

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?

June 10, 2024 at 3:55 am #15720077

Long Nguyen
Supporter

Languages: English (English )

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 ❌

Refer documentation https://wpml.org/documentation/support/wpml-troubleshooting-options/

Looking forward to your reply.
Thanks

June 19, 2024 at 3:33 am #15751968

charleneR-2

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?

Screenshot 132.png
June 19, 2024 at 4:19 am #15752254

Long Nguyen
Supporter

Languages: English (English )

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.