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.
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
- | 12:00 – 16:00 | 10:00 – 14:00 | 10:00 – 14:00 | 9:00 – 13:00 | 9:00 – 13:00 | - |
- | 17:00 – 21:00 | 15:00 – 19:00 | 15:00 – 19:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Europe/Bucharest (GMT+02:00)
Tagged: Bug
This topic contains 22 replies, has 2 voices.
Last updated by Mihai Apetrei 5 months, 2 weeks ago.
Assisted by: Mihai Apetrei.
Author | Posts |
---|---|
May 8, 2024 at 9:58 pm #15607959 | |
Mihai Apetrei Supporter
Languages: English (English ) Timezone: Europe/Bucharest (GMT+02:00) |
Welcome back and thank you for the update! This is definitely a pretty unique and strange situation that I never met until now. I am informing my colleagues about your update and I will get back as soon as I have any information. Thank you for your amazing patience and cooperation. I'm leaving the ticket assigned to myself for now. |
May 12, 2024 at 6:22 pm #15618116 | |
Mihai Apetrei Supporter
Languages: English (English ) Timezone: Europe/Bucharest (GMT+02:00) |
Hi there. I am back. If you would prefer not to run SQL queries, which is part of the fix, I am not sure how else our team can help here. Something else that you can try is to re-translate the bundled products - e.g. change them by making an edit, and re-send them to translation from the "WPML > Translation Management dashboard", and then re-translate. In regards to the second reply, this issue might or might not be related to this other issue that we are currently handling in this ticket and our team asked if you can create a new ticket for this specific situation so that it will be escalated separately and investigated upon separately, so that we don't mix things and make wrong assumptions on the cause of the issue. |
May 12, 2024 at 6:35 pm #15618138 | |
gerritG-2 |
Hi Mihai, Thanks for your replay. We don't run SQL queries on vendor systems. You can try on your clone?!? However, we re-created the products - with the same problem...and, as such, the SQL would be different anyhow. You have full access to the site and can "re-translate"...or make another Duplicate clone. I don't know what you mean with "second reply"...it is all part of the same issue. Translations always show up blank in the screen...which imho is likely the root cause of the other problems. Things used to work perfectly since 2016 and now not anymore... Could you fix the code - and - not ask to 'can try' or file another ticket. Your team does have full access and can create a duplicator clone anytime. Thanks for your help. D G |
May 14, 2024 at 11:58 am #15625186 | |
Mihai Apetrei Supporter
Languages: English (English ) Timezone: Europe/Bucharest (GMT+02:00) |
Hi there. Our team found out that, for some reason, the issue was related to the "translation_item_id_of" meta key in the table: "woocommerce_bundled_itemmeta" We depend on that table, and for some reason was pointing to incorrect IDs there. Our team fixed this on the local testing environment they created by running the following code. To get the bundled items IDs, they used the following query: SELECT GROUP_CONCAT(`bundled_item_id`) AS test FROM `wp_woocommerce_bundled_items` WHERE `bundle_id` = '12660' Which resulted in the values: "9377,9378,9379,9380,9381" and then, to remove our keys that were pointing incorrectly, they used: DELETE FROM `wp_woocommerce_bundled_itemmeta` WHERE `bundled_item_id` IN (9377,9378,9379,9380,9381) AND `meta_key` LIKE '%translation_item_id_of%'; Then, they re-translated (saved the translation of the bundle product): /wp-admin/post.php?post=12660&action=edit&lang=en However, this still does not fix the issue with the javascript and the fix is necessary yet again. That should be fixed in a future update as the issue that you reported was escalated even further so that we don't only look for a workaround for the current situation, but actually fix it in a future update, too. The fix that I shared above, again, requires some SQL queries and for the moment there is no way going around this, until this gets properly fixed by the dev team and deployed in one of the future updates. The values are highly corrupted: we cannot have bundle with ID 9377 pointing to ID 7234 or similar, because that is invalid; especially since the original is with the higher ID. That's the best that we can do at this point in regards to this issue. I am currently setting the status of this ticket to "Escalated to WPML developers team" and once this issue will get resolved in a future update, I will get back to you in this ticket. |
May 16, 2024 at 10:44 am #15634555 | |
gerritG-2 |
Hi Mihai, Thanks for forwarding the bugs to your dev team. I am sure you can understand that we don't want to do SQL on 1100 products on a 'vendor' system. We are looking forward to the bug fixes from your dev team and hope our issues will be quickly resolved. Thanks so much. D G |
May 19, 2024 at 10:01 pm #15643131 | |
Mihai Apetrei Supporter
Languages: English (English ) Timezone: Europe/Bucharest (GMT+02:00) |
Sure! As soon as I have news, I will get back to you. |
May 28, 2024 at 1:14 pm #15678598 | |
gerritG-2 |
Hi Mihai, Thanks so kindly for your help. Any updates? Our production website is still broken needs to be running as soon as possible. Greetings, D G |
June 3, 2024 at 8:25 am #15696818 | |
Mihai Apetrei Supporter
Languages: English (English ) Timezone: Europe/Bucharest (GMT+02:00) |
Hi there. Unfortunately, there are no updates at the moment. When exactly our developers will launch this fix is not up to us, the supporters, to decide, as there might be more urgent issues that have a bigger priority. I hope that you will find this information helpful. As I promised, when I will have an update, I will get right back to you. |