Hello,
Thank you for contacting WPML support. I’d be happy to assist you with this issue.
It would be very helpful if you could provide:
- a copy of the environment exported using Duplicator or All-in-One WP Migration and Backup
- if you are unable to prepare a copy, I would appreciate access to the environment where the issue can be reproduced (preferably a non-production site, if possible) so that I can create a copy in order to safely reproduce and diagnose the problem myself.
I look forward to your reply - I have set the next message to be private.
Thank you and best regards.
The admin credentials I sent you work for both sites: the production site (hidden link) and the Duplicator package. Feel free to reproduce the issue directly on the production site.
Thank you for the quick preparation of all the necessary data.
I tried to restore the Duplicator package you attached, but it did not import - If you can, remove this file from the site where it was shared, it will no longer be needed.
On the website you shared, I activated Duplicator, downloaded the prepared backup and deactivated Duplicator. This time the package was 20 MB larger and everything imported correctly.
All the information has been forwarded for analysis to determine the cause. As soon as we find out anything, I will inform you immediately.
Hello,
the update from WPML 4.9.1 to 4.9.2 seems to partially address the issue - it stops changing the post_type for the translation, but it still updates the translation number, which causes the connection to be lost.
So it doesn’t fully resolve your problem. I’m trying to first prepare a solution that will help you.
I understand, but I opened this ticket on February 27th. It has been 19 days already. This issue is affecting our store because visitors cannot add products with this problem to their carts. This is very negative for us. I would truly appreciate it if you could take this into account and, if possible, resolve it today.
All things have been tested, but please have a backup before you start - just in case
I was able to resolve this issue on my copy of the environment:
- I updated all plugins.
- I ran the following SQL query:
UPDATE `wp_icl_translations` SET `trid` = '84462' WHERE `wp_icl_translations`.`translation_id` = 46094;
It appears that, for some reason, two conflicting "translation links” were created - possibly something went wrong while editing the translation connections.
Please confirm if this resolves your issue. Additionally, could you let me know if the problem was observed only on this one product? It seems like something may not have worked correctly when trying to link the translations.
Thanks. This issue is affecting several other products. I suggest updating the SQL to include a condition that applies the patch to all affected items.
