Background of the issue:
I am trying to access the WPML settings, but the language list is empty. The issue seems related to the tables wp_icl_languages and wp_icl_languages_translations.
Symptoms:
WPML is missing some records in the languages tables, and the language list is empty in the settings.
Questions:
Why is the language list empty in WPML settings?
How can I fix the missing records in the languages tables?
Have you recently installed WPML? Could you please provide a screenshot of the issue you are experiencing?
You can reset WPML and then reactivate it if no translations have been done.
Here’s how:
1. Go to WPML → Support and click on the Troubleshooting link.
2. In the Reset section of the Troubleshooting page, select the checkbox that says "I am about to reset all translation and language data." Then, click the "Reset and deactivate WPML" button.
You can attempt to run the "Set Language Information" and "Reset Languages" options found in WPML → Support → Troubleshooting.
Alternatively, you can set up a new local WordPress installation, install WPML, activate it, and then export and import the necessary tables to your current site.
We imported the local SQL into the online testing environment, and the tables wp_icl_languages and wp_icl_languages_translations now contain data. This allowed us to complete the WPML initialization setup. However, the error messages still persist, and the error details are extensive.
Do these errors need to be resolved? If not resolved, will they have any impact? If they need to be fixed, how should we proceed? Can you provide us with a feasible solution that we can implement? Additionally, we will need to configure this in other environments later. Thank you.
The WPML message you see might be a false positive now since the tables with the data have already been imported.
You can follow these steps to resolve the issue:
1. Open your database management tool, such as PhpMyAdmin.
2. Navigate to the "wp_options" table.
3. Search for the `icl_admin_messages` key using the following query:
SELECT *
FROM `wp_options`
WHERE `option_name` LIKE '%icl_admin_messages%'
LIMIT 50;
4. Delete the key you found.
5. Refresh your dashboard and check if the message still appears.
I cannot definitively say why this problem is occurring, so I cannot provide a complete solution, as it should not happen. Since you could set up your local environment and import the tables to the online environment, I suspect some restrictions on your online server might be causing this issue. For example, the database user may not have sufficient permissions to create or insert data into the tables.
Please remember to backup your database before you proceed.
We conducted a joint self-check but were unable to locate and resolve the issue. Currently, we have sufficient permissions and memory space to install and activate WPML normally. However, all the "icl" related tables are empty, and compared with the local tables, some tables have not been successfully created.
Therefore, we would like to request remote assistance to help us resolve this issue. We are willing to cooperate by installing any necessary remote assistance tools or granting required permissions. Thank you.
After multiple investigations, we have confirmed that the issue with the initialization setup is due to permission problems.
Currently, the permissions granted to the user are as follows (which prevents the plugin from being installed properly):
SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, CREATE VIEW
Could you please confirm what additional permissions are required for installing, activating, configuring, and using the plugin? Thank you.
Thank you for the updates. I'm glad to hear you were able to identify the problem.
The ones you listed look to be complete. WPML has no specific requirements, so you can refer to the WordPress documentation for the necessary permissions for plugins to function correctly.
The permissions we currently provide are not sufficient for creating the necessary tables. However, when full permissions are granted, the setup completes successfully. This indicates that the permissions we currently offer are incomplete.
I have searched through the documentation but could not find detailed information regarding the required permissions. Could you kindly provide a link to the relevant permissions guide? Thank you very much for your assistance.
