Skip Navigation

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

Problem:
The client was facing an issue where internal links on their page were not being translated automatically on their live site, despite the SQL code working on their stage site.
Solution:
We investigated the issue and initially updated the Site URL and WordPress URL in the database to include HTTPS, which did not resolve the problem. Further analysis indicated that a specific script in the header file was causing the issue. We recommend the following steps:
1. Temporarily disable the problematic script.
2. Make a small change to the page or products where the issue was occurring and save the changes.
3. Complete the translation update.
4. Re-enable the script.
This process should trigger a refresh of backend processes and result in the correct translation of links. If the links are still not being translated correctly, please open a new support ticket with us.

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 17 replies, has 2 voices.

Last updated by Prosenjit Barman 10 months, 2 weeks ago.

Assisted by: Prosenjit Barman.

Author Posts
December 29, 2023 at 3:35 pm #15137092

marcoB-110

https://wpml.org/forums/topic/internal-links-in-page-are-not-translated-automatically/

The SQL code made it work on our stage site, but not on our live site. How come it does not work on our live site?

January 1, 2024 at 7:17 am #15139155

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
Thanks for contacting WPML Support. Sorry for the delay in responding due to the weekend.

Since it is working properly in the staging, it should ideally work similarly on the live site. Could you please verify if the database table prefix has been correctly included in the query? The default prefix "wp_" might differ in your database, so it's important to ensure it matches your specific configuration.

If you're still having the issue, a closer inspection will be required. I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. Since it is a live site, please ensure to take a backup of the site and database before sharing the access.

You will find the needed fields below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

IMPORTANT
-If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this:
hidden link

Looking forward to your response and wishing you a happy new year!

Best Regards,
Prosenjit

January 2, 2024 at 10:27 am #15142748

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
Thank you for sharing the access information.

I've conducted a review and noticed that the links on the translated page aren't updating correctly, even after applying the same adjustments used on the staging site to the live site. In addition to executing the SQL query, I've also searched for any database entries that might be obstructing the proper update of the links, but haven't found anything in my initial investigation.

Since the site is currently live, I haven't tested extensively to prevent any possible disruptions or temporary issues that might arise during the debugging process.

Now, to understand the root cause, would you kindly set up a new staging site from the current state of the live site? This would enable me to delve deeper into the issue without impacting the live site's operation.

I have enabled private fields for you so that you can securely share the access once the staging site is ready. I will take another look and if required, will escalate to the 2nd tier for further investigation.

Looking forward to your response and appreciate your kind cooperation in this matter.

Best regards,
Prosenjit

January 5, 2024 at 7:54 am #15153285

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hello There,
Thank you for sharing the access information.

Since the issue only happens in production, not in any staging site, I have forwarded the issue to our 2nd tier team for further investigation. As soon as I have any update on this, I will surely let you know.

I appreciate your patience and kind cooperation in this matter.

Best regards,
Prosenjit

January 8, 2024 at 6:36 pm #15162379

marcoB-110

Hello Prosenjit,

Could it be that the 2nd tier team is currently checking the problem on the website? We noticed some caching plugins were disabled. That's okay, as long if they are enabled again after the test.

Also, if there are any test products made, can they have a publication date of the year 2021? Otherwise you would see them at the top of the shop page which looks strange for my client's customers.

Thanks.

January 9, 2024 at 5:38 am #15163009

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,
I hope you're doing well.

Yes, our second-tier support team is currently working on the issue. Given that the solution functions correctly on our testing site but encounters problems on the main site, we suspect that the issue may stem from prepopulated or incorrectly configured caches. That's why, we disabled the caches to test properly. Once our testing is complete, we'll reactivate it.

Regarding the use of a previous publishing date, I can understand the reason and thank you for bringing this to our attention. We will ensure to select a date from the year 2021 for publication.

I appreciate your patience and kind cooperation in this matter.

Best regards,
Prosenjit

January 9, 2024 at 8:10 am #15163166

marcoB-110

Okay thanks.

Next to our regular cache plugin, we also use Redis Object Cache. This type of cache caches database queries (SQL). I was thinking, this might also be a cause of the problem?

January 10, 2024 at 3:33 am #15167120

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi,
Thank you for the input.

Yes, I also noticed that the object caching is enabled and I've tried clearing the object caches and even disabling that. The links are still not getting updated.

While our team is working on it, could you please give it another try by clearing the caches at the server level as well, especially if object caching is enabled there? This approach might help refresh any stored data that could be causing the links not to update correctly.

Let me know the update and I truly appreciate your kind cooperation in this matter.

Best regards,
Prosenjit

January 11, 2024 at 10:53 am #15173447

marcoB-110

Hello Prosenjit,

I asked the webhosting company if there is such cache I need to refresh on the server itself. The only cache that I can refresh from the website itself is the Wprocket and Object Cache (Redis cache).

We also notice another problem that might have something to do with our current problem discussed in this topic. We experience that sometimes the Dutch version of our home page (hidden link) shows the English texts instead of the Dutch texts (you can see it right now).

January 12, 2024 at 4:51 am #15177205

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hello There,

Thanks for the confirmation about cache clearance. I will forward this information to our 2nd tier team.

Regarding the issue with the text on the Dutch homepage – given that Dutch is the main language of the site, the Dutch content you've added should be displayed there. If it is not happening, I would suggest creating a new ticket, as it appears to be a different issue. As per our support guidelines, we handle one issue per ticket to ensure clear and organized communication. Upon opening a new ticket, one of our support team members will take it and help you to resolve the problem.

I appreciate your understanding in this matter.

Rest assured, as soon as I have more information from the 2nd tier team regarding the internal link issue, I will promptly inform you.

Meanwhile, If you come across any information related to the internal link issue that could help us in speeding up our process, please don't hesitate to share it. Your patience and cooperation are greatly appreciated. Thank you!

Best regards,
Prosenjit

January 12, 2024 at 3:12 pm #15179812

marcoB-110

Hello Prosenjit,

I made a new support topic for that other problem: https://wpml.org/forums/topic/attributes-of-different-languages-are-shown-in-attributes-list-in-wp-admin/

I also noticed it's possible to flush all databases on our server at my webhost, so I did that. I also tried to make a new product after that, with links in it and translated it. But unfortunately, the links are still not being translated.

January 12, 2024 at 3:21 pm #15179919

marcoB-110

By the way, did you or your support team added a plugin called "WP OPcache"? If so, why?

January 15, 2024 at 4:47 am #15182936

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hello There,
I hope you're doing well. Sorry for the delay in responding due to the weekend.

Thank you for adhering to our support policy and opening a new ticket. Rest assured, one of our support team members will soon attend to your ticket and provide the necessary assistance.

As for the installation of the OPcache plugin, I have successfully installed it to clear all forms of object caches on the site, following the deactivation of the Redis Object caches. The sole purpose of this plugin is to clear caches and if you want, you can disable that. Our 2nd tier team can enable it later if required.

I hope you can understand. If there's anything else you wish to discuss or share, please don't hesitate to inform me. Rest assured that I will promptly notify you as soon as there are any updates on this matter.

Best regards,
Prosenjit

January 15, 2024 at 1:48 pm #15185580

marcoB-110

Hello Prosenjit,

Do you have any update about the situation (the problem with links on the product page that can't be translated) or is the 2nd tier team still busy with it?

January 16, 2024 at 7:11 am #15187874

Prosenjit Barman
Supporter

Languages: English (English )

Timezone: Asia/Dhaka (GMT+06:00)

Hi There,

I understand the importance of this issue to you and want to assure you that it is receiving the attention it deserves.

Our team is actively working on resolving your concerns. We are committed to providing a solution that not only meets but exceeds your expectations. I appreciate your patience and understanding as we navigate through the complexities of this task.

Please rest assured that I am personally monitoring the progress and will ensure that you are kept informed every step of the way.

Should you have any further questions or require additional information in the meantime, please do not hesitate to reach out to me directly.

Best regards,
Prosenjit