Delete an existing language on my website

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 6 replies, has 3 voices.

Last updated by Andreas W. 1 year, 9 months ago.

Assisted by: Andreas W..

Author	Posts
April 11, 2023 at 6:09 pm #13449267
jean-francoisS-2	Tell us what you are trying to do? I am trying to delete a language from my website. However I am getting the following error : Error: Language not found. Is there any documentation that you are following? https://wpml.org/faq/how-to-completely-remove-a-language-from-your-site/#:~:text=Go%20to%20WPML%20%E2%86%92%20Languages,secondary%20language%20from%20the%20database. Is there a similar example that we can see? Look at the screenshot What is the link to your site? hidden link
April 11, 2023 at 8:56 pm #13450379
Ahmed Mohammed Supporter Timezone: Africa/Cairo (GMT+02:00)	Hi there, Thank you for contacting WPML support! I understand you want to delete a language from your website with its content. The screenshot you shared is from this page WPML → Languages → Edit languages. You don't need to go to that page to delete a language. You should go to WPML → Languages and click the button shown in the attached screenshot. Then, uncheck the desired language. After that, a table with the deactivated languages appears. Click on the delete icon to remove all the content you have translated into your secondary language from the database. Hope that helps 🙂
April 11, 2023 at 9:49 pm #13450461
jean-francoisS-2	I want to remove Français (Europe) and it does not appear in the list
April 11, 2023 at 10:30 pm #13450641
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hello, This looks like someone manually edited the table wp_icl_languages and changed the default French language to a custom version. You can recreate the default wp_icl_languages table by running this MySQL query on PHPMyAdmin or Adminer: Only take note, that if the database prefix of your site is not "wp_" then you will need to adjust the table name "wp_icl_languages" accordingly: 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); Best regards Andreas
April 12, 2023 at 7:19 pm #13459157
jean-francoisS-2	Hi, thanks for the query. I was able to add the missing language but now when I try to remove all the related translation it loads for a while and nothing happens when its done.
April 12, 2023 at 10:51 pm #13460187
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hello, This is because those contents were created with a custom language that replaced the original French language in your setup inside the WPML language table and this language does not longer exist on this table now. I can assist you in cleaning this up manually, which means directly inside the DB. I would like to request temporary access (wp-admin and FTP) to the website to investigate the issue further. You can find the required fields below the comment section when you log in to leave the next reply. The information you provide is private, which means only you and I can see and access it. IMPORTANT Please be sure to make a backup copy of the website and database before allowing us access. If you can't see the wp-admin / FTP fields, your post and website credentials are set as PUBLIC. DO NOT publish the data unless you see the required wp-admin / FTP fields. The private response form looks like this: hidden link Next time you reply, click "I still need assistance." Video: hidden link Please note that we are obliged to request this information individually on each ticket. We may not access any access information not specifically submitted on this ticket in the private response form. Best regards Andreas
April 13, 2023 at 6:10 pm #13467463
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	Hello, Thank you for your message. The old translations are removed now from the database. Best regards Andreas