products have 2 default languages

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.

Our next available supporter will start replying to tickets in about 4.79 hours from now. Thank you for your understanding.

This topic contains 7 replies, has 2 voices.

Last updated by Bruno Kos 4 years, 6 months ago.

Assisted by: Bruno Kos.

Author	Posts
April 28, 2020 at 12:04 pm #6012017
nicolasb-4	products have 2 default languages
April 28, 2020 at 1:17 pm #6012683
Bruno Kos Supporter Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00)	Hi, Can you provide us a direct database access if possible? I will then see if can find something that would help resolving this. I marked your next reply as private so that you can safely add credentials. Regards, Bruno Kos
April 29, 2020 at 8:30 am #6018485
Bruno Kos Supporter Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00)	Hi, I marked your next reply as private so that you can safely add credentials. Btw, I can't open hidden link url, how do I access this? Regards, Bruno Kos
April 29, 2020 at 8:35 am #6018533
nicolasb-4	hidden link
April 29, 2020 at 9:19 am #6018859
Bruno Kos Supporter Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00)	Hi, I was able to log into database and I picked up a random product as an example - the one with 91102 trid. That one had two source language codes set as null - I assume that French is indeed original, however the Portuguese Brazilian also had null. It seems like it was duplicate, but even after converting it into translation, it stayed null again. However, the only way I was able to fix it is by changing the source language code for the Portuguese Brazilian manually into "fr", that one being an original. I'm not sure how you got there or how to reproduce, but I guess that you could end up with deleting Brazilian Portuguese products and then translating them anew. Otherwise the only solution would be changing the source language code manually for all of them, but since there are 250 of them, I think that the first option would be much quicker. Regards, Bruno Kos
April 29, 2020 at 9:38 am #6019079
nicolasb-4	Thank you a lot, so i just need to delete all product in portuguese ? But i saw that when i delete product in portuguese, i can't modify the product even in french english... Can you just show me how do you change the source language code ? in which table and which column?
April 29, 2020 at 9:46 am #6019315
nicolasb-4	I think you just fix everything ? i can modify product in french without problem you are just amazing
April 29, 2020 at 10:09 am #6019703
Bruno Kos Supporter Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00)	Hi, It is within icl_translations, have a look at this documentation as it will explain how all of this is structured and how to find the translation groups: https://wpml.org/documentation/support/wpml-tables/ But as for editing French, I did not do anything really 🙂 Regards, Bruno Kos