Similar with the old ticket, that kn's. is_active is no, that cause this error
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Eileenmcnaughton | T320836 'is' is not a valid option for field preferred_language | |||
| Resolved | Eileenmcnaughton | T323964 'kn' is not a valid option for field preferred_language |
Event Timeline
Comment Actions
MariaDB [civicrm]> select id, value, label, name, is_active, is_default from civicrm_option_value where option_group_id=86 and is_active = 0 order by value;
| id | value | label | name | is_active | is_default |
| 596 | ae | Avestan | ae_XX | 0 | 0 |
| 592 | an | Aragonese | an_ES | 0 | 0 |
| 594 | as | Assamese | as_IN | 0 | 0 |
| 595 | av | Avaric | av_RU | 0 | 0 |
| 597 | ay | Aymara | ay_BO | 0 | 0 |
| 599 | bm | Bambara | bm_ML | 0 | 0 |
| 743 | bo | Tibetan Standard, Tibetan, Central | bo_CN | 0 | 0 |
| 618 | cr | Cree | cr_CA | 0 | 0 |
| 704 | cu | Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic | cu_BG | 0 | 0 |
| 622 | dv | Divehi; Dhivehi; Maldivian; | dv_MV | 0 | 0 |
| 624 | dz | Dzongkha | dz_BT | 0 | 0 |
| 628 | ee | Ewe | ee_GH | 0 | 0 |
| 633 | ff | Fula; Fulah; Pulaar; Pular | ff_SN | 0 | 0 |
| 638 | gn | Guaranà | gn_PY | 0 | 0 |
| 641 | ha | Hausa | ha_NG | 0 | 0 |
| 645 | ho | Hiri Motu | ho_PG | 0 | 0 |
| 643 | hz | Herero | hz_NA | 0 | 0 |
| 649 | ie | Interlingue | ie_XX | 0 | 0 |
| 651 | ig | Igbo | ig_NG | 0 | 0 |
| 700 | ii | Nuosu | ii_CN | 0 | 0 |
| 652 | ik | Inupiaq | ik_US | 0 | 0 |
| 653 | io | Ido | io_XX | 0 | 0 |
| 656 | iu | Inuktitut | iu_CA | 0 | 0 |
| 658 | jv | Javanese | jv_ID | 0 | 0 |
| 669 | kg | Kongo | kg_CD | 0 | 0 |
| 665 | ki | Kikuyu, Gikuyu | ki_KE | 0 | 0 |
| 672 | kj | Kwanyama, Kuanyama | kj_NA | 0 | 0 |
| 663 | kk | Kazakh | kk_KZ | 0 | 0 |
| 659 | kl | Kalaallisut, Greenlandic | kl_GL | 0 | 0 |
| 664 | km | Khmer | km_KH | 0 | 0 |
| 660 | kn | Kannada | kn_IN | 0 | 0 |
| 661 | kr | Kanuri | kr_NE | 0 | 0 |
| 662 | ks | Kashmiri | ks_IN | 0 | 0 |
| 668 | kv | Komi | kv_RU | 0 | 0 |
| 616 | kw | Cornish | kw_GB | 0 | 0 |
| 667 | ky | Kirghiz, Kyrgyz | ky_KG | 0 | 0 |
| 675 | lg | Luganda | lg_UG | 0 | 0 |
| 676 | li | Limburgish, Limburgan, Limburger | li_NL | 0 | 0 |
| 677 | ln | Lingala | ln_CD | 0 | 0 |
| 678 | lo | Lao | lo_LA | 0 | 0 |
| 680 | lu | Luba-Katanga | lu_CD | 0 | 0 |
| 684 | mg | Malagasy | mg_MG | 0 | 0 |
| 690 | mh | Marshallese | mh_MH | 0 | 0 |
| 688 | mi | Māori | mi_NZ | 0 | 0 |
| 691 | mn | Mongolian | mn_MN | 0 | 0 |
| 685 | ms | Malay | ms_MY | 0 | 0 |
| 609 | my | Burmese | my_MM | 0 | 0 |
| 692 | na | Nauru | na_NR | 0 | 0 |
| 695 | nd | North Ndebele | nd_ZW | 0 | 0 |
| 697 | ng | Ndonga | ng_NA | 0 | 0 |
| 701 | nr | South Ndebele | nr_ZA | 0 | 0 |
| 693 | nv | Navajo, Navaho | nv_US | 0 | 0 |
| 613 | ny | Chichewa; Chewa; Nyanja | ny_MW | 0 | 0 |
| 703 | oj | Ojibwa | oj_CA | 0 | 0 |
| 705 | om | Oromo | om_ET | 0 | 0 |
| 707 | os | Ossetian, Ossetic | os_GE | 0 | 0 |
| 709 | pi | PÄli | pi_KH | 0 | 0 |
| 712 | ps | Pashto, Pushto | ps_AF | 0 | 0 |
| 714 | qu | Quechua | qu_PE | 0 | 0 |
| 715 | rm | Romansh | rm_CH | 0 | 0 |
| 716 | rn | Kirundi | rn_BI | 0 | 0 |
| 719 | sa | Sanskrit | sa_IN | 0 | 0 |
| 722 | se | Northern Sami | se_NO | 0 | 0 |
| 724 | sg | Sango | sg_CF | 0 | 0 |
| 723 | sm | Samoan | sm_WS | 0 | 0 |
| 727 | sn | Shona | sn_ZW | 0 | 0 |
| 731 | so | Somali | so_SO | 0 | 0 |
| 736 | ss | Swati | ss_ZA | 0 | 0 |
| 732 | st | Southern Sotho | st_ZA | 0 | 0 |
| 744 | tk | Turkmen | tk_TM | 0 | 0 |
| 746 | tn | Tswana | tn_ZA | 0 | 0 |
| 747 | to | Tonga (Tonga Islands) | to_TO | 0 | 0 |
| 749 | ts | Tsonga | ts_ZA | 0 | 0 |
| 750 | tt | Tatar | tt_RU | 0 | 0 |
| 752 | ty | Tahitian | ty_PF | 0 | 0 |
| 753 | ug | Uighur, Uyghur | ug_CN | 0 | 0 |
| 759 | vo | Volapük | vo_XX | 0 | 0 |
| 760 | wa | Walloon | wa_BE | 0 | 0 |
| 762 | wo | Wolof | wo_SN | 0 | 0 |
| 764 | xh | Xhosa | xh_ZA | 0 | 0 |
| 766 | yo | Yoruba | yo_NG | 0 | 0 |
| 767 | za | Zhuang, Chuang | za_CN | 0 | 0 |
82 rows in set (0.004 sec)
Update the is_active to yes for all of those valid language options
Comment Actions
After clean up the invalid option, here are all valid languages
MariaDB [civicrm]> select id, value, label, name, is_active, is_default from civicrm_option_value where option_group_id=86 and is_active = 1 order by value;
| id | value | label | name | is_active | is_default |
| 586 | aa | Afar | aa_ET | 1 | 0 |
| 585 | ab | Abkhaz | ab_GE | 1 | 0 |
| 596 | ae | Avestan | ae_XX | 1 | 0 |
| 587 | af | Afrikaans (af) | af_ZA | 1 | 0 |
| 588 | ak | Akan | ak_GH | 1 | 0 |
| 590 | am | Amharic (am) | am_ET | 1 | 0 |
| 592 | an | Aragonese | an_ES | 1 | 0 |
| 591 | ar | Arabic (Egypt) | ar_EG | 1 | 0 |
| 594 | as | Assamese | as_IN | 1 | 0 |
| 595 | av | Avaric | av_RU | 1 | 0 |
| 597 | ay | Aymara | ay_BO | 1 | 0 |
| 598 | az | Azerbaijani (az) | az_AZ | 1 | 0 |
| 600 | ba | Bashkir | ba_RU | 1 | 0 |
| 602 | be | Belarusian (be) | be_BY | 1 | 0 |
| 608 | bg | Bulgarian | bg_BG | 1 | 0 |
| 604 | bh | Bihari | bh_IN | 1 | 0 |
| 605 | bi | Bislama | bi_VU | 1 | 0 |
| 599 | bm | Bambara | bm_ML | 1 | 0 |
| 603 | bn | Bengali (bn) | bn_BD | 1 | 0 |
| 743 | bo | Tibetan Standard, Tibetan, Central | bo_CN | 1 | 0 |
| 607 | br | Breton | br_FR | 1 | 0 |
| 606 | bs | Bosnian | bs_BA | 1 | 0 |
| 610 | ca | Catalan; Valencian | ca_ES | 1 | 0 |
| 612 | ce | Chechen | ce_RU | 1 | 0 |
| 611 | ch | Chamorro | ch_GU | 1 | 0 |
| 617 | co | Corsican | co_FR | 1 | 0 |
| 618 | cr | Cree | cr_CA | 1 | 0 |
| 620 | cs | Czech | cs_CZ | 1 | 0 |
| 704 | cu | Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic | cu_BG | 1 | 0 |
| 615 | cv | Chuvash | cv_RU | 1 | 0 |
| 761 | cy | Welsh | cy_GB | 1 | 0 |
| 621 | da | Danish | da_DK | 1 | 0 |
| 5852 | da | Danish (Greenland) | da_GL | 1 | 0 |
| 1540 | de | German (Luxembourg) | de_LU | 1 | 0 |
| 1575 | de | German (Belgium) | de_BE | 1 | 0 |
| 1354 | de | German (Austria) | de_AT | 1 | 0 |
| 2427 | de | German (Liechtenstein) | de_LI | 1 | 0 |
| 636 | de | German (Germany) | de_DE | 1 | 0 |
| 945 | de | German (Switzerland) | de_CH | 1 | 0 |
| 622 | dv | Divehi; Dhivehi; Maldivian; | dv_MV | 1 | 0 |
| 624 | dz | Dzongkha | dz_BT | 1 | 0 |
| 628 | ee | Ewe | ee_GH | 1 | 0 |
| 637 | el | Greek, Modern | el_GR | 1 | 0 |
| 808 | en | English (Australia) | en_AU | 1 | 0 |
| 809 | en | English (Canada) | en_CA | 1 | 0 |
| 810 | en | English (United Kingdom) | en_GB | 1 | 0 |
| 625 | en | English (United States) | en_US | 1 | 1 |
| 9116 | en | English (New Zealand) | en_NZ | 1 | 0 |
| 9117 | en | English (India) | en_IN | 1 | 0 |
| 9119 | en | English (Singapore) | en_SG | 1 | 0 |
| 1261 | en | English (South Africa) | en_ZA | 1 | 0 |
| 626 | eo | Esperanto | eo_XX | 1 | 0 |
| 1299 | es | Spanish (Latin America) | es_MX | 1 | 0 |
| 946 | es | Spanish; Castilian (Puerto Rico) | es_PR | 1 | 0 |
| 733 | es | Spanish; Spain | es_ES | 1 | 0 |
| 627 | et | Estonian | et_EE | 1 | 0 |
| 601 | eu | Basque (eu) | eu_ES | 1 | 0 |
| 710 | fa | Persian (Iran) | fa_IR | 1 | 0 |
| 633 | ff | Fula; Fulah; Pulaar; Pular | ff_SN | 1 | 0 |
| 631 | fi | Finnish | fi_FI | 1 | 0 |
| 630 | fj | Fijian | fj_FJ | 1 | 0 |
| 629 | fo | Faroese | fo_FO | 1 | 0 |
| 811 | fr | French (Canada) | fr_CA | 1 | 0 |
| 632 | fr | French (France) | fr_FR | 1 | 0 |
| 763 | fy | Western Frisian | fy_NL | 1 | 0 |
| 650 | ga | Irish | ga_IE | 1 | 0 |
| 726 | gd | Scottish Gaelic; Gaelic | gd_GB | 1 | 0 |
| 634 | gl | Galician | gl_ES | 1 | 0 |
| 638 | gn | Guaranà | gn_PY | 1 | 0 |
| 639 | gu | Gujarati | gu_IN | 1 | 0 |
| 682 | gv | Manx | gv_IM | 1 | 0 |
| 641 | ha | Hausa | ha_NG | 1 | 0 |
| 642 | he | Hebrew (modern) | he_IL | 1 | 0 |
| 644 | hi | Hindi | hi_IN | 1 | 0 |
| 645 | ho | Hiri Motu | ho_PG | 1 | 0 |
| 619 | hr | Croatian | hr_HR | 1 | 0 |
| 640 | ht | Haitian; Haitian Creole | ht_HT | 1 | 0 |
| 646 | hu | Hungarian | hu_HU | 1 | 0 |
| 593 | hy | Armenian (hy) | hy_AM | 1 | 0 |
| 643 | hz | Herero | hz_NA | 1 | 0 |
| 647 | ia | Interlingua | ia_XX | 1 | 0 |
| 648 | id | Indonesian | id_ID | 1 | 0 |
| 649 | ie | Interlingue | ie_XX | 1 | 0 |
| 651 | ig | Igbo | ig_NG | 1 | 0 |
| 700 | ii | Nuosu | ii_CN | 1 | 0 |
| 652 | ik | Inupiaq | ik_US | 1 | 0 |
| 653 | io | Ido | io_XX | 1 | 0 |
| 654 | is | Icelandic | is_IS | 1 | 0 |
| 3149 | it | Italian (Vatican City) | it_VA | 1 | 0 |
| 655 | it | Italian (Italy) | it_IT | 1 | 0 |
| 1458 | it | Italian (San Marino) | it_SM | 1 | 0 |
| 1476 | it | Italian (Switzerland) | it_CH | 1 | 0 |
| 656 | iu | Inuktitut | iu_CA | 1 | 0 |
| 657 | ja | Japanese | ja_JP | 1 | 0 |
| 658 | jv | Javanese | jv_ID | 1 | 0 |
| 635 | ka | Georgian | ka_GE | 1 | 0 |
| 669 | kg | Kongo | kg_CD | 1 | 0 |
| 665 | ki | Kikuyu, Gikuyu | ki_KE | 1 | 0 |
| 672 | kj | Kwanyama, Kuanyama | kj_NA | 1 | 0 |
| 663 | kk | Kazakh | kk_KZ | 1 | 0 |
| 659 | kl | Kalaallisut, Greenlandic | kl_GL | 1 | 0 |
| 664 | km | Khmer | km_KH | 1 | 0 |
| 660 | kn | Kannada | kn_IN | 1 | 0 |
| 670 | ko | Korean | ko_KR | 1 | 0 |
| 661 | kr | Kanuri | kr_NE | 1 | 0 |
| 662 | ks | Kashmiri | ks_IN | 1 | 0 |
| 671 | ku | Kurdish | ku_IQ | 1 | 0 |
| 668 | kv | Komi | kv_RU | 1 | 0 |
| 616 | kw | Cornish | kw_GB | 1 | 0 |
| 667 | ky | Kirghiz, Kyrgyz | ky_KG | 1 | 0 |
| 673 | la | Latin | la_VA | 1 | 0 |
| 674 | lb | Luxembourgish, Letzeburgesch | lb_LU | 1 | 0 |
| 675 | lg | Luganda | lg_UG | 1 | 0 |
| 676 | li | Limburgish, Limburgan, Limburger | li_NL | 1 | 0 |
| 677 | ln | Lingala | ln_CD | 1 | 0 |
| 678 | lo | Lao | lo_LA | 1 | 0 |
| 679 | lt | Lithuanian | lt_LT | 1 | 0 |
| 680 | lu | Luba-Katanga | lu_CD | 1 | 0 |
| 681 | lv | Latvian | lv_LV | 1 | 0 |
| 684 | mg | Malagasy | mg_MG | 1 | 0 |
| 690 | mh | Marshallese | mh_MH | 1 | 0 |
| 688 | mi | Māori | mi_NZ | 1 | 0 |
| 683 | mk | Macedonian | mk_MK | 1 | 0 |
| 686 | ml | Malayalam | ml_IN | 1 | 0 |
| 691 | mn | Mongolian | mn_MN | 1 | 0 |
| 689 | mr | Marathi | mr_IN | 1 | 0 |
| 685 | ms | Malay | ms_MY | 1 | 0 |
| 687 | mt | Maltese | mt_MT | 1 | 0 |
| 609 | my | Burmese | my_MM | 1 | 0 |
| 692 | na | Nauru | na_NR | 1 | 0 |
| 694 | nb | Norwegian Bokmål | nb_NO | 1 | 0 |
| 695 | nd | North Ndebele | nd_ZW | 1 | 0 |
| 696 | ne | Nepali | ne_NP | 1 | 0 |
| 697 | ng | Ndonga | ng_NA | 1 | 0 |
| 1314 | nl | Dutch (Belgium) | nl_BE | 1 | 0 |
| 623 | nl | Dutch (Netherlands) | nl_NL | 1 | 0 |
| 2487 | nl | Dutch (Suriname) | nl_SR | 1 | 0 |
| 2506 | nl | Dutch (South Africa) | nl_ZA | 1 | 0 |
| 698 | nn | Norwegian Nynorsk | nn_NO | 1 | 0 |
| 699 | no | Norwegian | no_NO | 1 | 0 |
| 701 | nr | South Ndebele | nr_ZA | 1 | 0 |
| 693 | nv | Navajo, Navaho | nv_US | 1 | 0 |
| 613 | ny | Chichewa; Chewa; Nyanja | ny_MW | 1 | 0 |
| 6526 | oc | Occitan (Spain) | oc_ES | 1 | 0 |
| 702 | oc | Occitan (after 1500) | oc_FR | 1 | 0 |
| 703 | oj | Ojibwa | oj_CA | 1 | 0 |
| 705 | om | Oromo | om_ET | 1 | 0 |
| 706 | or | Oriya | or_IN | 1 | 0 |
| 707 | os | Ossetian, Ossetic | os_GE | 1 | 0 |
| 708 | pa | Panjabi, Punjabi | pa_IN | 1 | 0 |
| 709 | pi | PÄli | pi_KH | 1 | 0 |
| 2344 | pl | Polish (Slovakia) | pl_SK | 1 | 0 |
| 2869 | pl | Polish (Ukraine) | pl_UA | 1 | 0 |
| 2400 | pl | Polish (Czech Republic) | pl_CZ | 1 | 0 |
| 3992 | pl | Polish (Lithuania) | pl_LT | 1 | 0 |
| 4003 | pl | Polish (Romania) | pl_RO | 1 | 0 |
| 2986 | pl | Polish (Hungary) | pl_HU | 1 | 0 |
| 711 | pl | Polish (Poland) | pl_PL | 1 | 0 |
| 712 | ps | Pashto, Pushto | ps_AF | 1 | 0 |
| 812 | pt | Portuguese (Brazil) | pt_BR | 1 | 0 |
| 9122 | pt | Portuguese (Angola) | pt_AO | 1 | 0 |
| 9123 | pt | Portuguese (Guinea-Bissau) | pt_GW | 1 | 0 |
| 9124 | pt | Portuguese (Cabo Verde) | pt_CV | 1 | 0 |
| 9125 | pt | Portuguese (Equatorial Guinea) | pt_GQ | 1 | 0 |
| 9126 | pt | Portuguese (Mozambique) | pt_MZ | 1 | 0 |
| 9127 | pt | Portuguese (Timor-Leste) | pt_TL | 1 | 0 |
| 713 | pt | Portuguese (Portugal) | pt_PT | 1 | 0 |
| 714 | qu | Quechua | qu_PE | 1 | 0 |
| 715 | rm | Romansh | rm_CH | 1 | 0 |
| 716 | rn | Kirundi | rn_BI | 1 | 0 |
| 717 | ro | Romanian, Moldavian, Moldovan | ro_RO | 1 | 0 |
| 2606 | ru | Russian (Kazakhstan) | ru_KZ | 1 | 0 |
| 6051 | ru | Russian (Belarus) | ru_BY | 1 | 0 |
| 718 | ru | Russian | ru_RU | 1 | 0 |
| 6124 | ru | Russian (Kyrgyzstan) | ru_KG | 1 | 0 |
| 666 | rw | Kinyarwanda | rw_RW | 1 | 0 |
| 719 | sa | Sanskrit | sa_IN | 1 | 0 |
| 720 | sc | Sardinian | sc_IT | 1 | 0 |
| 721 | sd | Sindhi | sd_IN | 1 | 0 |
| 722 | se | Northern Sami | se_NO | 1 | 0 |
| 724 | sg | Sango | sg_CF | 1 | 0 |
| 728 | si | Sinhala, Sinhalese | si_LK | 1 | 0 |
| 729 | sk | Slovak | sk_SK | 1 | 0 |
| 730 | sl | Slovene | sl_SI | 1 | 0 |
| 723 | sm | Samoan | sm_WS | 1 | 0 |
| 727 | sn | Shona | sn_ZW | 1 | 0 |
| 731 | so | Somali | so_SO | 1 | 0 |
| 589 | sq | Albanian (sq) | sq_AL | 1 | 0 |
| 725 | sr | Serbian | sr_RS | 1 | 0 |
| 736 | ss | Swati | ss_ZA | 1 | 0 |
| 732 | st | Southern Sotho | st_ZA | 1 | 0 |
| 734 | su | Sundanese | su_ID | 1 | 0 |
| 6066 | sv | Swedish (Finland) | sv_FI | 1 | 0 |
| 2242 | sv | Swedish (Åland Islands) | sv_AX | 1 | 0 |
| 737 | sv | Swedish | sv_SE | 1 | 0 |
| 735 | sw | Swahili | sw_TZ | 1 | 0 |
| 738 | ta | Tamil | ta_IN | 1 | 0 |
| 739 | te | Telugu | te_IN | 1 | 0 |
| 740 | tg | Tajik | tg_TJ | 1 | 0 |
| 741 | th | Thai | th_TH | 1 | 0 |
| 742 | ti | Tigrinya | ti_ET | 1 | 0 |
| 744 | tk | Turkmen | tk_TM | 1 | 0 |
| 745 | tl | Tagalog | tl_PH | 1 | 0 |
| 746 | tn | Tswana | tn_ZA | 1 | 0 |
| 747 | to | Tonga (Tonga Islands) | to_TO | 1 | 0 |
| 4308 | tr | Turkish (Cyprus) | tr_CY | 1 | 0 |
| 748 | tr | Turkish | tr_TR | 1 | 0 |
| 749 | ts | Tsonga | ts_ZA | 1 | 0 |
| 750 | tt | Tatar | tt_RU | 1 | 0 |
| 751 | tw | Twi | tw_GH | 1 | 0 |
| 752 | ty | Tahitian | ty_PF | 1 | 0 |
| 753 | ug | Uighur, Uyghur | ug_CN | 1 | 0 |
| 754 | uk | Ukrainian | uk_UA | 1 | 0 |
| 755 | ur | Urdu | ur_PK | 1 | 0 |
| 756 | uz | Uzbek | uz_UZ | 1 | 0 |
| 757 | ve | Venda | ve_ZA | 1 | 0 |
| 758 | vi | Vietnamese | vi_VN | 1 | 0 |
| 759 | vo | Volapük | vo_XX | 1 | 0 |
| 760 | wa | Walloon | wa_BE | 1 | 0 |
| 762 | wo | Wolof | wo_SN | 1 | 0 |
| 764 | xh | Xhosa | xh_ZA | 1 | 0 |
| 765 | yi | Yiddish | yi_US | 1 | 0 |
| 766 | yo | Yoruba | yo_NG | 1 | 0 |
| 807 | zh | Chinese (Taiwan) | zh_TW | 1 | 0 |
| 1597 | zh | Chinese (Hong Kong) | zh_HK | 1 | 0 |
| 614 | zh | Chinese (China) | zh_CN | 1 | 0 |
| 768 | zu | Zulu | zu_ZA | 1 | 0 |
227 rows in set (0.002 sec)