Skip Navigation

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

Problem:

If you're unable to find and translate the Product Tabs title string [xts-woodmart-options]additional_tab_title using WPML, and it appears as 'Registered and locked' in the Admin Texts Translation page, this might be due to corrupt entries in your database.

Solution:

We recommend logging into your site’s database using tools like PHPMyAdmin after taking a full site backup. Run the following query to correct the issue:

UPDATE wp_icl_strings SET string_package_id = NULL WHERE string_package_id = 0 AND context LIKE 'admin_texts_xts-woodmart-options'

After applying this fix, verify that everything is working as expected. If similar issues occur with other string domains, you can use the following query as a workaround, but only after ensuring you have backed up your site:

UPDATE wp_icl_strings SET string_package_id = NULL WHERE string_package_id = 0

If this solution does not resolve your issue or seems irrelevant due to 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 problems persist, 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.

Tagged: 

This topic contains 3 replies, has 1 voice.

Last updated by Bigul 2 months ago.

Assisted by: Bigul.

Author Posts
March 12, 2025 at 4:10 pm #16808260

annaT-15

<b>Background of the issue: </b>
I am trying to translate the Product Tabs title string [xts-woodmart-options]additional_tab_title using WPML. The issue can be seen on this page: hidden link.

<b>Symptoms: </b>
I can no longer find the string via string translation and have to search for it on the Admin Texts Translation page. Then it shows up but it says 'Registered and locked'.

<b>Questions: </b>
Why is the string showing as 'Registered and locked'?

I was able to translate this string before

March 13, 2025 at 6:56 am #16809880
annaT-15

I also want to add that this is a custom text that you can add to the product tabs in Woodmart theme. See screenshot. And I was able to translate these before.

I also tried to search strings with "exact match" option ticked but no luck.

Screenshot 2025-03-13 075545.png
Screenshot 2025-03-13 075324.png
March 13, 2025 at 3:36 pm #16812701

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Welcome to the WPML support forum. I will do my best to help you to resolve the issue.

Does it happen with other strings? Please untick the *Exact match* (as per the following screenshot) option and search the string by *Ask a question about* or *Ask a*. Then ensure it shows the string for translation or not.

https://wpml.org/wp-content/uploads/2025/03/16809880-Screenshot_2025_03_13_075545.png

Becuase if a string is showing as Register & Locked in WPML>>String Translation>>Register admin and settings strings for translation, it will be listed for translation.

Also, please visit WPML>>Translation Management Dashboard, and scroll down to *Other texts (Strings)* section and check this string is showing for translation or not. Refer to the attached image for more details.

Please note that I have opened a new ticket for the *custom text* issue. As per our support policies, we can address only one problem per ticket. This approach allows us to assist you more efficiently and keeps discussions focused. I will respond to the new ticket shortly. I appreciate your understanding.

--
Thanks!

Bigul

2025-03-13_21h03_43.png
March 14, 2025 at 8:08 am #16814926

annaT-15

Hello Bigul,
the issue concerns the title of the Product Tabs element by Woodmart theme. So it allows you to enter a custom title. And I did so and translated it successfully before. I recently renamed one of the tabs and then noticed I can no longer find and translate it in string translation.

I searched for it with "exact match" unchecked and could not find it.

And I tried the "Translation Management - Other strings" too, it does not appear there.

What I also tried to do is scanning Woodmart theme again for strings, but it does not help.

What I'm looking for, the " [xts-woodmart-options]additional_tab_title " seems nowhere to be found

March 14, 2025 at 10:55 am #16816085

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Thank you for the updates. Please fill the private details fields after a full site backup. I would like to access the admin area of your site for further checking. Refer to the following links for more details about our private information sharing policies.

https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

hidden link

--
Thanks!

Bigul

March 17, 2025 at 5:05 pm #16826633

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Thank you for the login information. This requires more testing. So please allow me to make a copy of your site using the Duplicator plugin (https://wordpress.org/plugins/duplicator/) for debugging the issue on my local server.

--
Thanks!

Bigul

March 24, 2025 at 11:21 am #16851356

annaT-15

Is there any update on this?

March 24, 2025 at 4:52 pm #16853435

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Sorry for the confusion, this requires further debugging. So we were waiting for your permission to make a copy of the site. Please check my last message. Thank you for your kind understanding.

https://wpml.org/forums/topic/woodmart-theme-product-tab-title-translation-is-registered-and-locked/#post-16826633

--
Thanks!

Bigul

March 24, 2025 at 6:01 pm #16853628

annaT-15

Sure go ahead, thanks!

March 25, 2025 at 10:33 am #16856505

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Thank you for the permission. I made a copy of the site and working on it locally now. We will get back to you as early as possible. Please wait.

--
Thanks!

Bigul

March 27, 2025 at 2:12 pm #16868906

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

The bug exists after the initial troubleshooting steps. So consulting with our team for an expert opinion now. We will get back to you as soon as possible. Please wait.

--
Thanks!

Bigul

March 31, 2025 at 4:21 pm #16880308

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Sorry for the late response because of the holidays. The ticket is in the escalation stage to our second-tier team. But we are not able to access your site now - hidden link.

It shows the following warning. Can you please check it.

Sorry, you have been blocked

You are unable to access onrocket.site

--
Thanks!

Bigul

April 3, 2025 at 9:16 am #16890879

annaT-15

Hello Bigul,
please use my staging site. I can't provide access to the production site. Also the production site is not available in all countries that's why it shows that messages, it can only be visited from Europe/USA.
I already provided access to staging

April 3, 2025 at 12:49 pm #16892289

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Thank you for the feedback. We will get back to you as early as possible. Please wait.

--
Thanks!

Bigul

April 25, 2025 at 11:28 am #16968280

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hello,

Sorry for the very late response. The issue turned out to be more complicated than expected. It works fine in our fresh and test installations.

After several rounds of testing, we discovered that the problem is caused by corrupt entries in the database.

For many strings—including those from the admin_texts_xts-woodmart-options strings domain (related to the WoodMart theme options), the string_package_id of wp_icl_strings table was incorrectly set to 0 instead of NULL.

Running the following query fixed the issue on your staging site. Please refer to the attached images for more details, and let us know your feedback:

UPDATE wp_icl_strings
SET string_package_id = NULL
WHERE string_package_id = 0
AND context LIKE 'admin_texts_xts-woodmart-options'

We recommend logging into your live site’s database (after taking a full site backup, which is mandatory) using tools like PHPMyAdmin and running this query. Then check to ensure everything is working as expected.

In the future, if you encounter similar issues with other string domains, you can use the following query as a workaround—again, only after taking a full site backup:

UPDATE wp_icl_strings
SET string_package_id = NULL
WHERE string_package_id = 0

--
Thanks!

Bigul

2025-04-25_16h34_03.png
2025-04-25_16h29_21.png