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 |
---|---|---|---|---|---|---|
- | 7:00 – 15:00 | 7:00 – 15:00 | 7:00 – 15:00 | 7:00 – 15:00 | 7:00 – 15:00 | - |
- | - | - | - | - | - | - |
Supporter timezone: Pacific/Easter (GMT-05:00)
Tagged: Known issue
This topic contains 0 replies, has 0 voices.
Last updated by Ilyes 2 days, 12 hours ago.
Assisted by: Ilyes.
Author | Posts |
---|---|
December 4, 2024 at 8:00 pm | |
rabiaA |
Background of the issue: Symptoms: Questions: |
December 4, 2024 at 8:54 pm | |
December 5, 2024 at 1:41 am #16479071 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
After further verification, the duplicate products are not assigned the right language, I have asked our 2nd tier for a Database query that could filter and delete these products using the categories. I will let you know once I got a response, Best, |
December 5, 2024 at 11:45 am #16481253 | |
rabiaA |
Is there any update from the 2nd tier? |
December 5, 2024 at 5:23 pm #16483135 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
Hello, Yes, as I noted before in the Database, that there is no record of any translations (in the icl_translations table only English content is listed), so if non-English content has been left behind (e.g. in wp_posts) there is no easy way of identifying it to delete it. The best solution is to go back to a backup before deleting the languages the first time, and do it properly as suggested in this documentation : https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/ The first step is not working for you since the first time the languages were deleted weren't done properly, If you don't have such a backup it may be possible to write a short script that deleted any posts that were duplicates (rather than translations) as there may be a leftover trace in wp_postmeta that identifies such posts. But that's the only thing that could be automated. If there is translated content (rather than duplicated) there is no longer a record of that, and no way to know what language some content actually is. Please get back to us if you got such backup, as this is the fastest solution, if not, we will work in a slower solution that require some manual work, Best, |
December 5, 2024 at 6:34 pm #16483457 | |
rabiaA |
Let me restore the backup, then will share new access for you - Can you confirm if it's ok? |
December 5, 2024 at 7:11 pm #16483506 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
Yes please, I will open your next reply as private in case you are sharing new access. |
December 5, 2024 at 7:32 pm | |
December 5, 2024 at 7:37 pm #16483634 | |
rabiaA |
Please confirm you started checking please? The most important issue is the huge data in the Mysql |
December 5, 2024 at 9:20 pm #16483992 | |
rabiaA |
Guys you're not responding, |
December 6, 2024 at 12:06 am #16484170 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
YEs, I'm checking now |
December 6, 2024 at 12:12 am #16484216 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
Okay this backup works well, I'm deleting both Hebrew and Arabic content, could you please confirm that you no longer need WPML content and that I can delete everything related to WPML ? |
December 6, 2024 at 4:54 am #16484476 | |
rabiaA |
Please do whatever is needed but even you’re deleting both languages, I need solution for the huge table with the 3.5 million rows and 1GB size. |
December 6, 2024 at 11:30 am #16485727 | |
rabiaA |
Can you please share the status please? |
December 6, 2024 at 3:44 pm #16486738 | |
Ilyes Supporter
Languages: English (English ) French (Français ) Timezone: Pacific/Easter (GMT-05:00) |
Hello, We are currently cleaning your site from WPML data, You will see that many rows were already removed, we are carefully deleting whatr is necessary to avoid errors, As of now, we deleted all attachments (media files) in other languages, those are the biggest files. I will get back to you with more updates, |