Skip Navigation

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

Problem:
The client reported an issue with the String Translation table in their site, specifically a missing

icl_string_page

table in the database. This was not immediately affecting the site's operation but could lead to critical issues in the future. Additionally, there were no strings listed for translation in the WPML String Translation interface, and a database error was reported.

Solution:
We recommended the client to:
1. Enable WordPress Debug Mode to check for any errors or warnings from WPML.
2. Visit WPML>>String Translation to verify if strings are listed for translation.
After further investigation, we identified that the string translation tables were missing indexing. We resolved the issue by running a SQL patch on the client's site. We asked the client to check their site and provide feedback.

If this solution does not seem relevant to your issue, please do not hesitate to open a new support ticket by visiting our 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 2 voices.

Last updated by Bigul 1 year ago.

Assisted by: Bigul.

Author Posts
November 6, 2023 at 3:01 pm

sophieM-11

There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, but can become a critical issue in the future. WPML support team knows how to fix it. Please add a message in the relevant support thread and we'll fix it for you.

I think I'm still missing the icl_string_page table from the database.

November 6, 2023 at 3:49 pm
November 7, 2023 at 6:58 am #14743399

Bigul
Supporter

Languages: English (English )

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

Hello,

We made a copy of your site and will debug it locally and get back to you as early as possible. Please wait.

--
Thanks!

Bigul

November 9, 2023 at 9:24 am #14763831

sophieM-11

Hi
Is there any update on this?
Thank you

November 9, 2023 at 12:31 pm #14766697

Bigul
Supporter

Languages: English (English )

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

Hello,

The following warning is fixed by running a SQL patch. Somehow the string translation tables were missing the indexing. Please check it now and let us know your feedback.

There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, but can become a critical issue in the future. WPML support team knows how to fix it. Please add a message in the relevant support thread and we'll fix it for you.

--
Thanks!

Bigul

November 9, 2023 at 1:33 pm #14767473

sophieM-11

What is the SQL patch?

November 9, 2023 at 1:59 pm #14767803

Bigul
Supporter

Languages: English (English )

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

Hello,

Thank you for the feedback. That is handled by our developers. It will be an SQL query based on the problem.

--
Thanks!

Bigul

November 9, 2023 at 2:45 pm #14768567

sophieM-11

I'm happy to run an SQL query if your developers can provide it.
OR is it in a future release of the plugin.

November 9, 2023 at 4:52 pm #14770083

Bigul
Supporter

Languages: English (English )

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

Hello,

This is a rare issue. Normally happens when we migrate the site. So the SQL query we run is a one-time fix. Please feel free to ping us if you need any further assistance with WPML.

--
Thanks!

Bigul