Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client was unable to see the pencil icon for editing translations in the WPML string translation feature. This issue was suspected to be due to a conflict or a database collation issue.
Solution:
We initially attempted to log into the client's admin panel to investigate directly, but faced login issues. We then recommended that the client contact their hosting provider to change the database table collation for all

icl_string*

tables to

utf8mb4_unicode_520_ci

. Additionally, we provided an SQL query to convert all tables and character columns in the MySQL database from

latin1_swedish_ci

to

utf8mb4_unicode_520_ci

, which can be executed via phpMyAdmin. The SQL query can be found here: https://pastebin.com/B7hUukgx.

If this solution does not resolve your issue, or if it seems outdated or irrelevant 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 further assistance is needed, please open a new support ticket at WPML support forum.

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.

Tagged: 

This topic contains 15 replies, has 0 voices.

Last updated by chun-haoH 1 week, 5 days ago.

Assisted by: Kor.

Author Posts
June 4, 2025 at 3:43 pm #17107373

Kor
WPML Supporter since 08/2022

Languages: English (English )

Timezone: Asia/Singapore (GMT+08:00)

Thanks for your reply.

I tried to run the SQL query below, and I'm getting errors as shown in the attached screenshot. It looks like a permission issue.

Please reach out to your hosting provider and ask them to convert all tables and all character columns in a MySQL database from latin1_swedish_ci to utf8mb4_unicode_520_ci via phpMyAdmin

https://pastebin.com/B7hUukgx

June 7, 2025 at 5:45 am #17115250

chun-haoH

The issue has been resolved. I’ve asked WP’s engineers to modify the database encoding. Thank you very much for your assistance.