Skip to content Skip to sidebar

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

Problem:
If you're experiencing issues with the 'icl_string_positions' table's 'position_in_page' column storing absolute paths instead of paths relative to ABSPATH, this can lead to problems when migrating to a new server or in a multi-server environment. This is because the ABSPATH might not be identical on all servers, causing unnecessary writes and duplicate data.
Solution:
We have managed to reproduce this issue by enabling the settings 'Look for strings while pages are rendered' and 'Track where strings appear on the site', followed by migrating the website to a new domain. We have escalated this issue to our second-tier support for further investigation and to our developers for a permanent fix in future versions. Please be aware that resolving this may take some time.

If this solution seems 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 issues persist, please open a new support ticket at WPML support forum for further assistance.

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 5 replies, has 0 voices.

Last updated by Dražen 1 month, 2 weeks ago.

Assisted by: Dražen.

Author Posts
November 20, 2024 at 6:43 pm #16426268

desireeM

Background of the issue:
I am trying to ensure that the icl_string_positions 'position_in_page' column stores paths relative to ABSPATH. This is important because when migrating to a new server or in a multi-server environment, where the ABSPATH isn't identical on all servers, it can lead to unnecessary writes and duplicate data. For example, the previous server had /var/www/vhosts/client-123/wp-content/themes/twentytwentyfour/functions.php and the new server has /var/www/vhosts/client-987/wp-content/themes/twentytwentyfour/functions.php. By storing it relative to ABSPATH, like wp-content/themes/twentytwentyfour/functions.php, this issue is fixed.

Symptoms:
Described above

The WPML AI support tool rewrote my text and completely changed the meaning. When clicking back, I lost the text I originally wrote 🙁

Questions:
Fix this

November 21, 2024 at 7:44 am #16427695

Dražen
Supporter

Languages: English (English )

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

Hello,

thanks for contacting us. As I understand you are suggesting a change and improvement in our plugin / DB.

To understand it better and to be able to escalate we would need to reproduce in on the test site. I have prepared it, can you please go to the next link and show us an example of this problem / share steps on how this can be reproduced?

- hidden link

Thanks,
Drazen

November 21, 2024 at 11:07 am #16428591

desireeM

What is unclear about the provided description? Look at the DB at the provided install, if icl_string_positions table 'position_in_page' column has anything in it, you will see the issue. If not, do whatever action that will cause WPML to populate it to see the issue

November 21, 2024 at 11:55 am #16428791

Dražen
Supporter

Languages: English (English )

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

Hello,

thanks.

I have managed to reproduce it after enabling "Look for strings while pages are rendered" and "Track where strings appear on the site" and then migrate the website to a new domain.

I have escalated this to our 2nd tier to check and advise further, I will update you when I have some news.

Regards,
Drazen

December 4, 2024 at 12:34 pm #16476592

Dražen
Supporter

Languages: English (English )

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

Hello,

the issue is escalated to our developers and we will work on it for future versions for a permanent fix.

Please note this will take a while.

I will update you when I have some news.

Regards,
Drazen

June 27, 2025 at 12:40 pm #17177467

Dražen
Supporter

Languages: English (English )

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

Hello,

this should be now fixed in latest WPML versions.

Regards,
Drazen