Skip Navigation

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.

Elementor users - please update WPML to the latest version to maintain compatibility. More details here - https://wpml.org/changelog/2024/12/wpml-4-6-15-critical-update-for-elementor-sites/
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: 

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:
I've struggled in the last 1 month with my customer who keep complaining about the performance and the slowness of the website. We decided to remove the 2 extra languages and kept only the default English. Once this was done, the website performance improved. Now, I am facing an issue with duplicated data due to the previous 3 languages setup and need to clean up only the duplicated Products, keeping only the English language products.

Symptoms:
Most of the data is duplicated due to the 3 languages, and I am not able to remove the duplication of the Products.

Questions:
How can I clean up only the duplicated Products and keep only the English language products?

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,
if possible to let me know when you will start checking?

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,