Clear language information and repopulate languages - cant find

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

Problem:
The client was unable to find the 'Clear language information and repopulate languages' option on the WPML troubleshooting page and was experiencing issues with product translations not functioning correctly.
Solution:
We suggested that the 'Clear language information and repopulate languages' option should appear at the top of the troubleshooting page if WPML detects that the default data in the languages table has been altered or is missing. If the option is not visible, we recommended manually recreating the languages table by connecting to the database and running the following MySQL query:https://wpml.org/forums/topic/clear-language-information-and-repopulate-languages-cant-find/#post-16721505
This query drops the existing languages table if it exists, creates a new one, and populates it with default language data. If further assistance is needed, we advised the client to contact us.

Please note that this solution might be outdated or not applicable to your specific case. 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 the issue persists, please open a new support ticket for personalized assistance.

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 2 replies, has 0 voices.

Last updated by ranaC 1 week ago.

Assisted by: Andreas W..

Author	Posts
February 18, 2025 at 11:51 pm #16721320
ranaC	Background of the issue: I am working on a site under development and trying to fix an issue with WPML where it is missing some records in the languages tables. I need to clear language information and repopulate languages to resolve this. Symptoms: I can't find the 'Clear language information and repopulate languages' option on the troubleshooting page. Additionally, my product translations are not working well. Questions: Where can I find the 'Clear language information and repopulate languages' option on the troubleshooting page? How can I fix the issue with my product translations not working well?
February 19, 2025 at 1:57 am #16721505
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hello, If I recall correctly this option should be displayed in the top section of this page. It will only appear if WPML recognizes that the default data of the languages table has been altered or is missing. You could try to connect to your database and run the following MySQL query to recreate the table. DROP TABLE IF EXISTS `wp_icl_languages`; CREATE TABLE `wp_icl_languages` ( `id` int NOT NULL AUTO_INCREMENT, `code` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL, `english_name` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL, `major` tinyint NOT NULL DEFAULT '0', `active` tinyint NOT NULL, `default_locale` varchar(35) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `tag` varchar(35) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `encode_url` tinyint(1) NOT NULL DEFAULT '0', `country` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), UNIQUE KEY `english_name` (`english_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; INSERT INTO `wp_icl_languages` (`id`, `code`, `english_name`, `major`, `active`, `default_locale`, `tag`, `encode_url`, `country`) VALUES (1, 'en', 'English', 1, 1, 'en_US', 'en', 0, NULL), (2, 'es', 'Spanish', 1, 0, 'es_ES', 'es', 0, NULL), (3, 'de', 'German', 1, 1, 'de_DE', 'de', 0, NULL), (4, 'fr', 'French', 1, 0, 'fr_FR', 'fr', 0, NULL), (5, 'ar', 'Arabic', 0, 0, 'ar', 'ar', 0, NULL), (6, 'bs', 'Bosnian', 0, 0, 'bs_BA', 'bs', 0, NULL), (7, 'bg', 'Bulgarian', 0, 0, 'bg_BG', 'bg', 0, NULL), (8, 'ca', 'Catalan', 0, 0, 'ca', 'ca', 0, NULL), (9, 'cs', 'Czech', 0, 0, 'cs_CZ', 'cs', 0, NULL), (10, 'sk', 'Slovak', 0, 0, 'sk_SK', 'sk', 0, NULL), (11, 'cy', 'Welsh', 0, 0, 'cy_GB', 'cy', 0, NULL), (12, 'da', 'Danish', 1, 0, 'da_DK', 'da', 0, NULL), (13, 'el', 'Greek', 0, 0, 'el', 'el', 0, NULL), (14, 'eo', 'Esperanto', 0, 0, 'eo_UY', 'eo', 0, NULL), (15, 'et', 'Estonian', 0, 0, 'et', 'et', 0, NULL), (16, 'eu', 'Basque', 0, 0, 'eu_ES', 'eu', 0, NULL), (17, 'fa', 'Persian', 0, 0, 'fa_IR', 'fa', 0, NULL), (18, 'fi', 'Finnish', 0, 0, 'fi', 'fi', 0, NULL), (19, 'ga', 'Irish', 0, 0, 'ga_IE', 'ga', 0, NULL), (20, 'he', 'Hebrew', 0, 0, 'he_IL', 'he', 0, NULL), (21, 'hi', 'Hindi', 0, 0, 'hi_IN', 'hi', 0, NULL), (22, 'hr', 'Croatian', 0, 0, 'hr', 'hr', 0, NULL), (23, 'hu', 'Hungarian', 0, 0, 'hu_HU', 'hu', 0, NULL), (24, 'hy', 'Armenian', 0, 0, 'hy_AM', 'hy', 0, NULL), (25, 'id', 'Indonesian', 0, 0, 'id_ID', 'id', 0, NULL), (26, 'is', 'Icelandic', 0, 0, 'is_IS', 'is', 0, NULL), (27, 'it', 'Italian', 1, 0, 'it_IT', 'it', 0, NULL), (28, 'ja', 'Japanese', 1, 0, 'ja', 'ja', 0, NULL), (29, 'ko', 'Korean', 0, 0, 'ko_KR', 'ko', 0, NULL), (30, 'ku', 'Kurdish', 0, 0, 'ckb', 'ku', 0, NULL), (31, 'lv', 'Latvian', 0, 0, 'lv_LV', 'lv', 0, NULL), (32, 'lt', 'Lithuanian', 0, 0, 'lt_LT', 'lt', 0, NULL), (33, 'mk', 'Macedonian', 0, 0, 'mk_MK', 'mk', 0, NULL), (34, 'mt', 'Maltese', 0, 0, 'mt_MT', 'mt', 0, NULL), (35, 'mn', 'Mongolian', 0, 0, 'mn_MN', 'mn', 0, NULL), (36, 'ne', 'Nepali', 0, 0, 'ne', 'ne', 0, NULL), (37, 'nl', 'Dutch', 1, 0, 'nl_NL', 'nl', 0, NULL), (38, 'no', 'Norwegian Bokmål', 0, 0, 'nb_NO', 'no', 0, NULL), (39, 'pa', 'Punjabi', 0, 0, 'pa_IN', 'pa', 0, NULL), (40, 'pl', 'Polish', 0, 0, 'pl_PL', 'pl', 0, NULL), (41, 'pt-pt', 'Portuguese, Portugal', 0, 0, 'pt_PT', 'pt-pt', 0, NULL), (42, 'pt-br', 'Portuguese, Brazil', 0, 0, 'pt_BR', 'pt-br', 0, NULL), (43, 'qu', 'Quechua', 0, 0, 'quz_PE', 'qu', 0, NULL), (44, 'ro', 'Romanian', 0, 0, 'ro_RO', 'ro', 0, NULL), (45, 'ru', 'Russian', 1, 0, 'ru_RU', 'ru', 0, NULL), (46, 'sl', 'Slovenian', 0, 0, 'sl_SI', 'sl', 0, NULL), (47, 'so', 'Somali', 0, 0, 'so_SO', 'so', 0, NULL), (48, 'sq', 'Albanian', 0, 0, 'sq_AL', 'sq', 0, NULL), (49, 'sr', 'Serbian', 0, 0, 'sr_RS', 'sr', 0, NULL), (50, 'sv', 'Swedish', 0, 0, 'sv_SE', 'sv', 0, NULL), (51, 'ta', 'Tamil', 0, 0, 'ta_IN', 'ta', 0, NULL), (52, 'th', 'Thai', 0, 0, 'th', 'th', 0, NULL), (53, 'tr', 'Turkish', 0, 0, 'tr_TR', 'tr', 0, NULL), (54, 'uk', 'Ukrainian', 0, 0, 'uk', 'uk', 0, NULL), (55, 'ur', 'Urdu', 0, 0, 'ur', 'ur', 0, NULL), (56, 'uz', 'Uzbek', 0, 0, 'uz_UZ', 'uz', 0, NULL), (57, 'vi', 'Vietnamese', 0, 0, 'vi_VN', 'vi', 0, NULL), (58, 'yi', 'Yiddish', 0, 0, '', 'yi', 0, NULL), (59, 'zh-hans', 'Chinese (Simplified)', 1, 0, 'zh_CN', 'zh-hans', 0, NULL), (60, 'zu', 'Zulu', 0, 0, '', 'zu', 0, NULL), (61, 'zh-hant', 'Chinese (Traditional)', 1, 0, 'zh_TW', 'zh-hant', 0, NULL), (62, 'ms', 'Malay', 0, 0, 'ms_MY', 'ms', 0, NULL), (63, 'gl', 'Galician', 0, 0, 'gl_ES', 'gl', 0, NULL), (64, 'bn', 'Bengali', 0, 0, 'bn_BD', 'bn', 0, NULL), (65, 'az', 'Azerbaijani', 0, 0, 'az', 'az', 0, NULL); I hope this will help, to solve the issue. In case not, or if ou need help in recreating the table, please let me know. Best regards Andreas
February 19, 2025 at 2:32 pm #16725223
ranaC	I did as you requested..now the table does exist..even I run a test and added another language. but the message always showing above... and I cant find the "Clear language information and repopulate languages"...even I checked in another website that working fine and has no message troubleshooting this "Clear language information and repopulate languages" doesn't exist . but my issue now with the translation for the products ... I try to translate it doesn't show all the content that needs translation. in the other hand, I write the translation but it doesn't save!!!! thank you
February 19, 2025 at 3:39 pm #16725646
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hi, I would like to offer to take a closer look and request temporary access (wp-admin and FTP) to the site to investigate the issue further. The required fields are below the comment section when you log in to leave the next reply. The information you provide is private, meaning only you and I can see and access it. IMPORTANT Please be sure to back up the site and database before granting us access. If you can't see the "wp-admin / FTP" fields, your post and site login details will be set to "PUBLIC". DO NOT publish the data unless you see the required wp-admin / FTP fields. The private reply form looks like this: hidden link The next time you reply, click on "I still need assistance". Video: hidden link Please note that we are obliged to request this information individually on each ticket. We are not allowed to access any credentials that were not specifically submitted on this ticket in the private response form. Best regards Andreas
February 19, 2025 at 5:10 pm #16726152
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	I used the troubleshooting option to remove the message. It seems it had got stuck for some reason. The issue seems to be solved now.
February 19, 2025 at 6:10 pm #16726412
ranaC	thank you very much for your support.