Skip Navigation

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

Problem:
You are unable to update the translation of 'footer-sml-section-2-credit' in English after updating the text in French. This issue might be due to a database corruption, where certain values in the icl_strings table are incorrectly set.
Solution:
To resolve this, you need to access your database and modify the icl_strings table. Specifically, look for entries under admin_texts_astra-settings where the columns string_package_id and location are set to 0. Change these values to NULL. After making these changes, you should be able to translate the text via WPML --> String Translation.

If this solution does not apply to your case, or if it seems outdated, 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. Should you need further assistance, 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 7 replies, has 0 voices.

Last updated by jonathanF-3 1 month ago.

Assisted by: Paola Mendiburu.

Author Posts
June 3, 2025 at 1:55 pm

jonathanF-3

Background of the issue:
I am trying to unlock the translation of some admin text that was translated in the past. I updated the text in French but can't update the translation in English. The text is the Astra footer text. I can update the first part 'footer-sml-section' in string translation, but not the 'footer-sml-section-2-credit'.

Symptoms:
I am unable to update the translation of the 'footer-sml-section-2-credit' in English after updating the text in French.

Questions:
How can I unlock the translation of admin text that was previously translated?
Why can't I update the translation for 'footer-sml-section-2-credit'?

June 3, 2025 at 2:41 pm
June 3, 2025 at 2:47 pm #17102980

Paola Mendiburu
WPML Supporter since 11/2020

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Madrid (GMT+02:00)

Do you have a staging site where I can investigate without affecting your site?

June 3, 2025 at 3:48 pm
June 4, 2025 at 8:09 am #17105007

Paola Mendiburu
WPML Supporter since 11/2020

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Madrid (GMT+02:00)

The server protection details are not working.

Could you please update them with the correct ones?

Also if it is working for you, could you please deactivate plugins and change to the parent them and let me know if it works?

Thank you.

June 4, 2025 at 12:38 pm
June 6, 2025 at 10:24 am #17113536

Paola Mendiburu
WPML Supporter since 11/2020

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Madrid (GMT+02:00)

I have done many tests but the problem persists.

I will send it to second tier.

June 6, 2025 at 6:45 pm #17114880

Paola Mendiburu
WPML Supporter since 11/2020

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Madrid (GMT+02:00)

Do you give me permission to download a copy with duplicator so I can escalate to the second tier?

Thanks.

June 10, 2025 at 12:22 pm #17121817

jonathanF-3

Yes no problem!

June 11, 2025 at 2:30 pm #17126490

Paola Mendiburu
WPML Supporter since 11/2020

Languages: English (English ) Spanish (Español ) Italian (Italiano )

Timezone: Europe/Madrid (GMT+02:00)

Hi there!

I was able to solve the issue.

The issue was due to a database corruption, possibly during a migration. Some strings in the icl_strings table had the columns string_package_id and location set to 0 instead of NULL. Changing these values to NULL made the strings translatable in the String Translation section.

So please do the following:
- access your database
- on the table icl_strings search for admin_texts_astra-settings, and you will see that some of them have string_package_id and location set to 0,
- change it to NULL
- now you will be able to translate it from WPML --> String translation

Please let me know if you have any problem.

June 11, 2025 at 5:41 pm #17127466

jonathanF-3

Yes it worked! Thank you!