No language to select

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

Problem:
The client was experiencing issues with the WP-phpMyAdmin plugin due to some missing table structures.
Solution:
We resolved the issue by adding the missing table structures. If you're experiencing this issue, we recommend checking your database for similar missing structures and adding them as needed. Once the issue is resolved, you can safely delete the WP-phpMyAdmin plugin.

Please note that this solution might be outdated or not applicable to your 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 problem persists, please open a new support ticket at 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: Bug

This topic contains 12 replies, has 2 voices.

Last updated by Kor 1 year, 11 months ago.

Assisted by: Kor.

Author	Posts
June 12, 2024 at 1:08 pm #15731713
laura-ashleyG	Background of the issue: Good morning, I've just installed WPML on my development site, but when I try to do the WPML setup, there are no languages to setup (it says "No Data"). When I go to the plugin page I get the message "WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed. Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem." I have tried clicking on that button, and do get the message "DONE", but the problem remains. What can I do to get WPML running on my site? Many thanks, Symptoms: Here is my debug information: {"core":{"Wordpress":{"Multisite":"No","SiteURL":"hidden link","HomeURL":"hidden link","Version":"6.5.4","PermalinkStructure":"/%postname%/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, wp_template, wp_template_part, wp_global_styles, wp_navigation, wp_font_family, wp_font_face, seedprod, fl-builder-template, sa_slider, cookielawinfo","PostStatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed","RestEnabled":"No"},"Server":{"jQueryVersion":"3.7.1","PHPVersion":"7.4.1","MySQLVersion":"8.0.16","ServerSoftware":"nginx/1.16.0"},"PHP":{"MemoryLimit":"256M","WP Memory Limit":"40M","UploadMax":"300M","PostMax":"1000M","TimeLimit":"1200","MaxInputVars":"4000","MBString":true,"libxml":true}},"plugins":{"active_plugins":{"sitepress-multilingual-cms/sitepress.php":{"Plugin Slug":"sitepress-multilingual-cms","Name":"WPML Multilingual CMS","PluginURI":"https://wpml.org/","Version":"4.6.11","Author":"OnTheGoSystems","AuthorURI":"http://www.onthegosystems.com/","TextDomain":"sitepress-multilingual-cms","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"WPML Multilingual CMS","AuthorName":"OnTheGoSystems"},"all-in-one-wp-migration-unlimited-extension/all-in-one-wp-migration-unlimited-extension.php":{"Plugin Slug":"","Name":"All-in-One WP Migration Unlimited Extension","PluginURI":"hidden link","Version":"2.58","Author":"ServMask","AuthorURI":"hidden link","TextDomain":"all-in-one-wp-migration-unlimited-extension","DomainPath":"/languages","Network":true,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"All-in-One WP Migration Unlimited Extension","AuthorName":"ServMask"},"all-in-one-wp-migration/all-in-one-wp-migration.php":{"Plugin Slug":"","Name":"All-in-One WP Migration","PluginURI":"hidden link","Version":"7.83","Author":"ServMask","AuthorURI":"hidden link","TextDomain":"all-in-one-wp-migration","DomainPath":"/languages","Network":true,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"All-in-One WP Migration","AuthorName":"ServMask"},"bb-plugin/fl-builder.php":{"Plugin Slug":"","Name":"Beaver Builder Plugin (Standard Version)","PluginURI":"hidden link","Version":"2.8.2.2","Author":"The Beaver Builder Team","AuthorURI":"hidden link","TextDomain":"fl-builder","DomainPath":"","Network":false,"RequiresWP":"4.6","RequiresPHP":"7.0","UpdateURI":"","RequiresPlugins":"","Title":"Beaver Builder Plugin (Standard Version)","AuthorName":"The Beaver Builder Team"},"coming-soon/coming-soon.php":{"Plugin Slug":"","Name":"Coming Soon Page, Maintenance Mode, Landing Pages u0026 WordPress Website Builder by SeedProd","PluginURI":"hidden link","Version":"6.17.4","Author":"SeedProd","AuthorURI":"hidden link","TextDomain":"coming-soon","DomainPath":"/languages","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"Coming Soon Page, Maintenance Mode, Landing Pages u0026 WordPress Website Builder by SeedProd","AuthorName":"SeedProd"},"litespeed-cache/litespeed-cache.php":{"Plugin Slug":"","Name":"LiteSpeed Cache","PluginURI":"hidden link","Version":"6.2.0.1","Author":"LiteSpeed Technologies","AuthorURI":"hidden link","TextDomain":"litespeed-cache","DomainPath":"/lang","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"LiteSpeed Cache","AuthorName":"LiteSpeed Technologies"},"simple-social-icons/simple-social-icons.php":{"Plugin Slug":"","Name":"Simple Social Icons","PluginURI":"https://wordpress.org/plugins/simple-social-icons/","Version":"3.2.5","Author":"OsomPress","AuthorURI":"hidden link","TextDomain":"simple-social-icons","DomainPath":"/languages","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"Simple Social Icons","AuthorName":"OsomPress"},"slide-anything/slide-anything.php":{"Plugin Slug":"","Name":"Slide Anything - Responsive Content / HTML Slider and Carousel","PluginURI":"https://wordpress.org/plugins/slide-anything/","Version":"2.4.9","Author":"","AuthorURI":"","TextDomain":"slide-anything","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"Slide Anything - Responsive Content / HTML Slider and Carousel","AuthorName":""},"updraftplus/updraftplus.php":{"Plugin Slug":"","Name":"UpdraftPlus - Backup/Restore","PluginURI":"hidden link","Version":"1.24.3","Author":"UpdraftPlus.Com, DavidAnderson","AuthorURI":"hidden link","TextDomain":"updraftplus","DomainPath":"/languages","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"UpdraftPlus - Backup/Restore","AuthorName":"UpdraftPlus.Com, DavidAnderson"},"webtoffee-gdpr-cookie-consent-2/cookie-law-info.php":{"Plugin Slug":"","Name":"GDPR Cookie Consent","PluginURI":"hidden link","Version":"2.4.0","Author":"WebToffee","AuthorURI":"hidden link","TextDomain":"webtoffee-gdpr-cookie-consent","DomainPath":"/languages","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"GDPR Cookie Consent","AuthorName":"WebToffee"},"wordfence/wordfence.php":{"Plugin Slug":"","Name":"Wordfence Security","PluginURI":"hidden link","Version":"7.11.6","Author":"Wordfence","AuthorURI":"hidden link","TextDomain":"wordfence","DomainPath":"/languages","Network":true,"RequiresWP":"3.9","RequiresPHP":"5.5","UpdateURI":"","RequiresPlugins":"","Title":"Wordfence Security","AuthorName":"Wordfence"},"wordpress-seo/wp-seo.php":{"Plugin Slug":"","Name":"Yoast SEO","PluginURI":"hidden link","Version":"22.8","Author":"Team Yoast","AuthorURI":"hidden link","TextDomain":"wordpress-seo","DomainPath":"/languages/","Network":false,"RequiresWP":"6.4","RequiresPHP":"7.2.5","UpdateURI":"","RequiresPlugins":"","Title":"Yoast SEO","AuthorName":"Team Yoast"},"wpml-string-translation/plugin.php":{"Plugin Slug":"wpml-string-translation","Name":"WPML String Translation","PluginURI":"https://wpml.org/","Version":"3.2.12","Author":"OnTheGoSystems","AuthorURI":"http://www.onthegosystems.com/","TextDomain":"wpml-string-translation","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"WPML String Translation","AuthorName":"OnTheGoSystems"}},"mu_plugins":{"sso.php":{"Plugin Slug":"","Name":"WHC.CA","PluginURI":"","Version":"1.0.0","Description":"WHC.CA API","Author":"WHC.CA","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"WHC.CA","AuthorName":"WHC.CA"},"whc.php":{"Plugin Slug":"","Name":"WHC.CA","PluginURI":"","Version":"1.0.0","Description":"WHC.CA Helper Tools","Author":"WHC.CA","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"WHC.CA","AuthorName":"WHC.CA"},"onboard.php":{"Plugin Slug":"","Name":"WHC.CA","PluginURI":"","Version":"1.0.0","Description":"WHC.CA Onboard","Author":"WHC.CA","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","RequiresPlugins":"","Title":"WHC.CA","AuthorName":"WHC.CA"}},"dropins":[]},"theme":{"Name":"Lead Yourself Up Program","ThemeURI":false,"Author":"StudioPress","AuthorURI":"hidden link","Template":"genesis","Version":"3.4.2","TextDomain":"genesis-sample","DomainPath":"","ParentName":"Genesis"},"extra-debug":{"installer":{"version":"3.1.7","repositories":{"wpml":{"api-url":"hidden link","bucket-url":"hidden link","subscription":{"key":"QvOzwbqhhw","key_type":0,"data":{"subscription_type":17118,"expires":"2025-06-07","status":"1","notes":"resubscribed from #1048921","order_id":"15713561","hasAutoRenewal":true},"registered_by":1,"site_url":"hidden link"},"last-successful-subscription-fetch":"none"},"toolset":{"api-url":"hidden link","bucket-url":"not assigned","subscription":"","last-successful-subscription-fetch":"none"}},"instances":{"/Users/lagodbout/Local Sites/lead-yourself-test/app/public/wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/installer.php":{"bootfile":"/Users/lagodbout/Local Sites/lead-yourself-test/app/public/wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/installer.php","version":"3.1.7","args":{"plugins_install_tab":1,"site_key_nags":[{"repository_id":"wpml","product_name":"WPML","condition_cb":[{"locale_utils":{},"footer_preview":false,"icl_translations_cache":null,"icl_language_name_cache":{},"icl_term_taxonomy_cache":null,"wpdb":{"show_errors":false,"suppress_errors":false,"last_error":"","num_queries":516,"num_rows":0,"rows_affected":0,"insert_id":0,"last_query":"nttttSELECT codenttttFROM wp_icl_languagesnttttWHERE active = 1nttt","last_result":[],"queries":null,"prefix":"wp_","base_prefix":"wp_","ready":true,"blogid":0,"siteid":0,"tables":["posts","comments","links","options","postmeta","terms","term_taxonomy","term_relationships","termmeta","commentmeta"],"old_tables":["categories","post2cat","link2cat"],"global_tables":["users","usermeta"],"ms_global_tables":["blogs","blogmeta","signups","site","sitemeta","registration_log"],"old_ms_global_tables":["sitecategories"],"comments":"wp_comments","commentmeta":"wp_commentmeta","links":"wp_links","options":"wp_options","postmeta":"wp_postmeta","posts":"wp_posts","terms":"wp_terms","term_relationships":"wp_term_relationships","term_taxonomy":"wp_term_taxonomy","termmeta":"wp_termmeta","usermeta":"wp_usermeta","users":"wp_users","blogs":null,"blogmeta":null,"registration_log":null,"signups":null,"site":null,"sitecategories":null,"sitemeta":null,"field_types":{"post_author":"%d","post_parent":"%d","menu_order":"%d","term_id":"%d","term_group":"%d","term_taxonomy_id":"%d","parent":"%d","count":"%d","object_id":"%d","term_order":"%d","ID":"%d","comment_ID":"%d","comment_post_ID":"%d","comment_parent":"%d","user_id":"%d","link_id":"%d","link_owner":"%d","link_rating":"%d","option_id":"%d","blog_id":"%d","meta_id":"%d","post_id":"%d","user_status":"%d","umeta_id":"%d","comment_karma":"%d","comment_count":"%d","active":"%d","cat_id":"%d","deleted":"%d","lang_id":"%d","mature":"%d","public":"%d","site_id":"%d","spam":"%d"},"charset":"utf8mb4","collate":"utf8mb4_unicode_520_ci","func_call":"$db-u003Equery(u0022nttttSELECT codenttttFROM wp_icl_languagesnttttWHERE active = 1ntttu0022)","is_mysql":true,"time_start":null,"error":null,"categories":"wp_categories","post2cat":"wp_post2cat","link2cat":"wp_link2cat"}},"setup"]}]},"delegated":true}}}}} Questions:
June 12, 2024 at 1:20 pm #15731862
Kor	Thanks for reaching us. I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified. Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements. Your upcoming reply will be treated with confidentiality and will only be visible to you and me. ✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup. While checking the debug info, I see that the WordPress Memory Limit is below the requirements. The minimum requirements are 128M, but we do recommend 256M and the debug information of your site shows it set to 40M. Please check this link for more details https://wpml.org/home/minimum-requirements/. You can increase it by adding the following code in your wp-config.php file, right before the /* That’s all, stop editing! Happy publishing. */ line: define( 'WP_MAX_MEMORY_LIMIT', '256M' ); define( 'WP_MEMORY_LIMIT', '128M' ); After adding the code you can confirm that the memory was changed correctly from WPML > Support > WordPress > Memory limit.
June 12, 2024 at 2:36 pm #15732232
Kor	Thanks for your reply. Can I have your permission to install the phpmyadmin plugin on your Website so that I can check on your server database?
June 12, 2024 at 2:37 pm #15732233
laura-ashleyG	Hi - Yes of course! Thank you for your help.
June 12, 2024 at 2:51 pm #15732308
Kor	Thanks for your reply. Sorry, it looks like I'm unable to execute any SQL query or import tables into your server database using the phpmyadmin plugin. Could you please share the access to your server database?
June 12, 2024 at 2:52 pm #15732310
laura-ashleyG	Yes. Can you please explain how I can do so? Thanks,
June 12, 2024 at 2:54 pm #15732313
laura-ashleyG	Do you mean you need FTP access?
June 12, 2024 at 2:56 pm #15732314
Kor	Thanks for your reply. Could you please reach out to your hosting provider and ask for database access(phpmyadmin)? Tell them that you need to share this information with a plugin author to check on the database. Also, please ask to backup the entire server.
June 12, 2024 at 3:23 pm #15732419
Kor	This is fixed and could you please check? it was due to some missing table structure and I've added it and it's fixed.
June 12, 2024 at 3:37 pm #15732635
laura-ashleyG	Yes thank you, it works now! Can I delete the "WP-phpMyAdmin" plugin now? Thanks again. It is so appreciated.
June 12, 2024 at 3:38 pm #15732637
Kor	Yes, you can remove it. Marking this ticket as resolved. Have a great day!
June 12, 2024 at 6:37 pm #15733278
laura-ashleyG	Hi Kor, Everything seems to be working fine, but I still get the "WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed" message on my website. Is that normal? Should it not be fixed by now? I was able to do the basic setup - but I want to make sure all is set up right before I start translating. Many thanks
June 12, 2024 at 6:39 pm #15733295
Kor	It should be fine now. Please check.
June 12, 2024 at 6:41 pm #15733296
laura-ashleyG	Yes thank you! It has disappeared now. Thanks for the swift reply.