This thread is resolved. Here is a description of the problem and solution.
Problem: The client was experiencing a WordPress database error due to an illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like'. Solution: We recommended the client to navigate to WPML->Support->Troubleshooting and execute the 'Fix WPML table collation' function. This resolved the issue.
If this solution does not resolve your issue, or seems irrelevant due to it being outdated or not applicable to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket.
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.
Background of the issue:
I have had a database error that was initially solved (see image of database attached) but for some reason, even though all tables are changed, there is an error regarding WPML in the database. This is the error: [23-Aug-2024 04:20:40 UTC] WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%') OR (wp_posts.post_excerpt LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%') OR (wp_posts.post_content LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'gt3_gallery' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'projects' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired')) OR (wp_posts.post_type = 'team' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','job_listing') ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','job_listing') ) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%' THEN 1 WHEN wp_posts.post_title LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%' THEN 4 WHEN wp_posts.post_content LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%' THEN 5 ELSE 6 END), wp_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, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_WpdbNew->default_query [23-Aug-2024 04:20:40 UTC] WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%') OR (wp_posts.post_excerpt LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%') OR (wp_posts.post_content LIKE '%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ hidden link ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%'))) AND (wp_posts.post_password = '') AND wp_posts.post_password = '' AND wp_posts.post_type IN ('post', 'page', 'attachment', 'team', 'projects', 'job_listing', 'gt3_gallery') AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','job_listing') ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','job_listing') ) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/listingeasy/search.php'), get_posts, WP_Query->query, WP_Query->get_posts, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_WpdbNew->default_query
Symptoms:
WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like'
Questions:
Can you help me?
Do you have any ideas?
.png "16097593-1 (2).png")
