If you're experiencing an issue where your website's language selector has disappeared and all content is mixed up, with a message indicating missing records in the WPML database, it's possible that the icl_sitpress_settings key in the wp_options table has been altered or deleted.

We recommend you try the following steps: 1) Configure WPML as it was configured previously on your staging site. 2) Go to WPML>>Settings>>Post Type Translation. 3) Set the <code>Translatable - show only translated items</code> option for the relevant custom post types like <code>News</code>. 4) Save the changes. 5) Navigate to WPML>>Settings>>Taxonomy Translation. 6) Set the <code>Translatable - show only translated items</code> option for the relevant custom taxonomies. 7) Save the changes. 8) Go to Settings>>Permalinks and resave the settings. 9) Clear all types of caches. Please ensure you perform a full site backup before making these changes. If this solution doesn\'t look relevant or if you continue to face issues, please <a href=\'https://wpml.org/forums/forum/english-support/\'>open a new support ticket</a> with us.

WPML configuration completely broken (without our intervention)

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: Bug

This topic contains 23 replies, has 2 voices.

Last updated by Bigul 1 year, 3 months ago.

Assisted by: Bigul.

Author	Posts
November 16, 2023 at 3:16 pm #14828309
brunoP-18	Hi there, Indeed, there was something missing in the setup of that TST environment. Should now be OK. On the other hand, may I ask kindly you to speed up your investigation. Our client is getting very angry. You have to know that this is the Belgian federation of basketball and their national teams, so quite a serious organization with a lot of exposure :/ Many thanks in advance for taking it into account. Best regards, Bruno
November 16, 2023 at 4:40 pm #14829311
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hi Bruno, Thank you for the updates. I can access the correct network admin for the staging site now. We will debug it further and get back to you soon. Please wait. -- Thanks! Bigul
November 17, 2023 at 1:06 pm #14862975
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hi Bruno, Somehow the icl_sitpress_settings key of the wp_options table is altered. It is very shot. There are chances that the key was deleted. Normally it contains more values. a:44:{s:15:"languages_order";a:2:{i:0;s:2:"nl";i:1;s:2:"fr";}s:16:"active_languages";a:2:{i:0;s:2:"fr";i:1;s:2:"nl";}s:21:"interview_translators";i:1;s:34:"existing_content_language_verified";i:0;s:25:"language_negotiation_type";i:1;s:18:"icl_lso_link_empty";i:0;s:18:"sync_page_ordering";i:1;s:16:"sync_page_parent";i:1;s:18:"sync_page_template";i:1;s:16:"sync_ping_status";i:1;s:19:"sync_comment_status";i:1;s:16:"sync_sticky_flag";i:1;s:13:"sync_password";i:1;s:17:"sync_private_flag";i:1;s:16:"sync_post_format";i:1;s:11:"sync_delete";i:0;s:15:"sync_delete_tax";i:0;s:20:"sync_post_taxonomies";i:1;s:14:"sync_post_date";i:1;s:21:"sync_taxonomy_parents";i:0;s:25:"translation_pickup_method";i:0;s:15:"notify_complete";i:1;s:26:"translated_document_status";i:1;s:31:"translated_document_status_sync";i:0;s:17:"remote_management";i:0;s:15:"auto_adjust_ids";i:1;s:11:"alert_delay";i:0;s:12:"promote_wpml";i:0;s:18:"automatic_redirect";i:0;s:17:"remember_language";i:24;s:28:"icl_lang_sel_copy_parameters";s:0:"";s:28:"translated_document_page_url";s:13:"auto-generate";s:27:"sync_comments_on_duplicates";i:0;s:3:"seo";a:3:{s:10:"head_langs";i:1;s:27:"canonicalization_duplicates";i:1;s:19:"head_langs_priority";i:1;}s:22:"posts_slug_translation";a:1:{s:2:"on";i:1;}s:4:"urls";a:5:{s:30:"directory_for_default_language";i:0;s:12:"show_on_root";s:0:"";s:19:"root_html_file_path";s:0:"";s:9:"root_page";i:0;s:23:"hide_language_switchers";i:1;}s:12:"xdomain_data";i:1;s:24:"custom_posts_sync_option";a:2:{s:4:"post";i:1;s:4:"page";i:1;}s:22:"taxonomies_sync_option";a:2:{s:8:"category";i:1;s:8:"post_tag";i:1;}s:28:"tm_block_retranslating_terms";i:1;s:22:"admin_default_language";s:9:"_default_";s:2:"st";a:1:{s:25:"db_ok_for_gettext_context";b:1;}s:25:"icl_capabilities_verified";b:1;s:18:"ajx_health_checked";b:1;} So one request. It appears that it was originally set in French as the default language and Dutch as the secondary language. Please configure WPML like in the past on your staging site and let us know if it helped or not. -- Thanks! Bigul
November 17, 2023 at 7:41 pm #14866035
brunoP-18	Hi there, No, that does not solve the issue. I actually tested reconfiguring the whole stuff even before contacting you. Even after re-configuring, I still have the message saying there is an issue, and contents of all languages remain completely mixed up. To be honest, I'm not sure it's only that variable that has an issue, it seems the link between contents and their translation is also completely lost (and that's why I actually contacted you). I need stronger support and serious solution proposal, guys! Thanks in advance, Bruno
November 18, 2023 at 3:00 pm #14868183
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hi Bruno, Thank you for the feedback. I am getting the expected results in the staging site for the News Posts after setting the Translatable show only translated items option for the News post type from WPML>>Settings>>Post Type Translation. Please refer to the attached images for more details and let us know your feedback. -- Thanks! Bigul
November 19, 2023 at 10:58 am #14870197
brunoP-18	Hi, Since it seems to work in the TST environment, I would like to apply the changes in PROD in order to make it work there too. Could you tell me what would be the steps ? Can I configure WPML first or do you need to execute/change something on your own first ? Please let me know. Many thanks!
November 19, 2023 at 5:41 pm #14871565
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hi Bruno, Thank you for the updates. Happy to know you are getting the expected results in the staging site now. Please try the following steps on the live site after a full site backup{mandatory} and make sure the bug exists or not. 1) Configure WPML like the past 2) Visit WPML>>Settings>>Post Type Translation 3) Set Translatable show only translated items option for the relevant custom post types like News 4) Save the changes 5) Scroll down to WPML>>Settings>>Taxonomy Translation 6) Set Translatable show only translated items option for the relevant custom taxonomies 7) Save the changes 8) Visit Settings>>Permalinks, resave the settings 9) Clear all types of caches -- Thanks! Bigul
November 20, 2023 at 9:44 am #14874547
brunoP-18	Hi Bigul, Thank you for all these steps. I did all of them and it seems that it worked. Now I still have issues mentionned in the trouble shooting page: - in PROD : hidden link - in TST : hidden link I don't really know what to do with that. Could you help me? Also could you tell me how to configure the plugin to always have the language displayed in the URL ("fr" by default)? Thank you! New threads created by Bigul and linked to this one are listed below: https://wpml.org/forums/topic/clear-language-information-and-restore-languages-again-notices/ https://wpml.org/forums/topic/directory-for-the-default-language/
November 20, 2023 at 4:18 pm #14879425
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hi Bruno, Thank you for the updates. Happy to know you are getting the expected results now. Please note, that I have opened a new tickets for the other issues. As per our support policies, we can only handle one issue per ticket. It will help us to serve you better and we can avoid discussing multiple problems in one ticket. I will get back to you soon on the latest tickets. Please wait. Thank you for your understanding. -- Thanks! Bigul