[Resolved] wpml is missing some records in the language tables
This thread is resolved. Here is a description of the problem and solution.
Problem:
Unable to see languages to select in the setup Step 1.
Our database tables were added to your database incorrectly. The icl_languages table had an unexpected column and the collation was set to "latin2_general_ci" when the expected value is "utf8mb4_unicode_520_ci"
This caused some of our tables to be incompletely populated. Solution:
I corrected the collation and table structures and imported the missing values for icl_languages, icl_flgs, and icl_languages_translations using the phpMyadmin plugin.
Relevant Documentation:
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.
Tell us what you are trying to do?
Install WPML. After I installed the plugin (manually) I got the message that some language configuration was missing for a custom post type (it was PHP code). I searched and saw the tip to remove the message and reload the page and that message doesn't appear anymore.
But there are still 2 issues...
1 - I cannot configure WPML, the first screen ask what language is the site in and the secondary language. both select boxes appear empty even if I write the language.
2 - This message appears and I already followed the steps provided by you but no avail:
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.
This warning will disappear once this issue is fixed.
Is there any documentation that you are following?
No, already searched but no avail
1. As a first and quick fix - could you please do the following:
1.1 WPML > Support > Reset.
1.2. Delete the plugin
1.3 Download the plugin again from your wpml.org account
1.4 Temporarily dactivate you non-WPML plugins and change your theme to something like TwentyTwenty.
1.5 Attempt to execute the setup again.
1.6 Do you get the same issue?
1.7 Reactivaet your non-WPML Plugins and change back to your normal theme.
2. If you still have the issue.
2.1. Please install and activate the phpMyAdmin plugin.
2.2. Take a backup of your site for security and good practice
2.3 Please provide access to your system (wp-admin and ftp) so that I can further investigate this particular problem. The fields to provide this data are included in a private section that I will open for your next response. You can find it above the comments area. The information in this private section is only visible between WPML Support and you.
I tried the credentials you provided (which have since been removed) but they did not work.
Could you please re-check them and communicate them again using the FORM that is under this message? This is for your own security.
Please also ensure you have made a backup of your site. I don't intend to make any changes to your site. It there is anything to be done, I will be asking you/your team to do them under my advisement.
I was able to determine that our database tables were added to your database incorrectly. The icl_languages table had an unexpected column and the collation was set to "latin2_general_ci" when the expected value is "utf8mb4_unicode_520_ci"
This caused some of our tables to be incompletely populated.
I corrected the collation and table structures and imported the missing values for icl_languages, icl_flgs, and icl_languages_translations using the phpMyadmin plugin.
Now you should be able to execute the WPML CMS setup.
I have removed our administrative plugins. Thanks.
