Problem: The client was unable to save theme string translations in WPML due to a WordPress database error. The error was triggered by an emoji in the string, causing the query to contain invalid data. Solution: We identified that the issue might be related to unsupported character encoding or misconfigured database collation. To resolve this, we recommended: 1. Checking the database's character encoding to ensure it supports emojis and special characters. WordPress uses
utf8mb4
encoding. 2. Using a database management tool like phpMyAdmin to verify and adjust the collation of the affected table to either
utf8mb4_unicode_ci
or
utf8mb4_general_ci
. 3. If the issue persists, consider reaching out to the hosting provider for further assistance or installing a database management plugin on a sandbox site to compare collations.
Please note that this solution might be outdated or not applicable to your specific case. If the problem persists, 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 needed, do not hesitate to open a new support ticket with us for further assistance.
