languages disappeared

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client's homepage original language was German, which appeared greyed out, preventing them from selecting it. After adding English, the English content was incorrectly displayed on the German page. Additionally, the client encountered database errors and incorrect displays.
Solution:
We recommended that the client should add English and set it as the default language. After doing so, they would be able to add German as well. Then, they should set German back as the default language, which should resolve the issue.
If you're experiencing similar issues, we recommend you try the following steps:
1. Add English and set it as your default language.
2. Once English is set, add German.
3. Set German as the default language again.
Please note that the solution provided might be irrelevant due to being outdated or not applicable to your case. If the problem persists, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please open a new support ticket in the WPML support forum.

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.

Tagged: Exception

This topic contains 3 replies, has 2 voices.

Last updated by Dražen 12 months ago.

Assisted by: Dražen.

Author	Posts
February 1, 2024 at 6:55 pm #15256650
davidS-113	Suddenly our english translation disappeared. When I go to WPML > languages, there are no languages visible, but it shows our translated content in the database. What is really strange is, that I even cannot change the user language in my profile. Can you please help? Thank you so much!
February 2, 2024 at 8:47 am #15258153
Dražen Supporter Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00)	Hello, Please go to WPML->languages->add language, are you able to see the languages? Select and add them then save. If you cannot see the languages, go to your database and locate the _icl_languages table and let me know if you see the languages listed there or if it's empty. - https://wpml.org/documentation/support/wpml-tables/ Let me know. Thanks, Drazen
February 2, 2024 at 12:33 pm #15259286
davidS-113	The original language on our homepage is German. I could see all languages, but the original language was greyed out. So I only added the English language. Now English content is displayed on the German page. There were also other problems and incorrect displays. I am going to restore an old backup to get the site working again. By the way, the debug log showed the following: "WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ..." Does this help to find the error? I would like to find out the cause so that the problem does not occur again.
February 2, 2024 at 12:36 pm #15259288
Dražen Supporter Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00)	Hello, thanks for getting back. Okay, if German is greyed out, then add English and set EN as your default language, then you should be able to add German also, then set German as the default language and it should be working fine now. Please try. Regards, Drazen