Skip Navigation

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

Problem:
If you're experiencing an error stating 'WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed' and have already tried resetting, deleting, reinstalling WPML, and increasing the memory limit without success, the issue may be due to insufficient database user privileges.
Solution:
We recommend contacting your hosting provider to ensure that the database user configured in your wp-config.php file has all the necessary privileges. Once you have confirmed that the database user has the correct privileges, you can attempt to reset WPML from the Troubleshooting page or manually delete all wp_icl tables, then re-enable and configure WPML.

If you need to explain the situation to your hosting provider, mention that a plugin (WPML) is trying to remove or reset its tables as part of its reset function and is unable to do so due to database user privileges. This issue can also occur when attempting to delete tables manually from PHPMyAdmin, indicating that it is not related to WPML itself.

After ensuring the database user has the correct privileges, you can proceed with manually deleting the tables or resetting WPML.

Please note that this solution might be irrelevant if it's outdated or not applicable to your case. If the problem persists, we highly recommend checking related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you still need assistance, please open a new support ticket.

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: 

This topic contains 4 replies, has 3 voices.

Last updated by Dražen 1 year, 1 month ago.

Assisted by: Dražen.

Author Posts
April 19, 2024 at 9:35 am #15542645

aleksandarA-9

I installed WPML today on our clients website, and ran into this error before trying to configure the plugin on startup. I don't think its a false positive since no languages show up on setup screen. image 1

"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've tried everything suggested. Rest, Delete, Reinstall, Check with default theme... I've also increased memory limit from 40 to 256MB. But nothing is working.

1.png
April 19, 2024 at 9:59 am #15542824

Carlos Rojas
WPML Supporter since 03/2017

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hello,
Thank you for contacting us

I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.

Our Debugging Procedures

I will be checking various settings in the backend to see if the issue can be resolved. Although I won't be making changes that affect the live site, it is still good practice to back up the site before providing us access. If we do need to debug the site further, I will duplicate the site and work in a separate, local development environment to avoid affecting the live site.

Regards,
Carlos

April 19, 2024 at 12:20 pm #15543545

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

I have checked and it seems there are some restrictions for your DB user, that is added to the WP config, that is why WPML can not create or reset tables, so the issue is stuck there.

I advise checking with hosting to make sure your DB user has all the needed privileges, then you can run WPML Reset from troubleshooting or manually delete all wp_icl tables, and enable and configure WPML.

Regards,
Drazen

April 19, 2024 at 1:17 pm #15543831

aleksandarA-9

What exactly should I tell the hosting?

Just to grant all privileges to the user and do a flush?

April 19, 2024 at 1:19 pm #15543849

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

you should tell them that you have a plugin that is trying to remove its table / reset them as part of the reset function and is not able to due to DB user privileges. The same thing happens if you try to delete tables manually from your PHPmyadmin, so not related to WPML itself.

After that you can continue to delete them manually or reset WPML.

Regards,
Drazen

April 22, 2024 at 8:25 am #15548650

aleksandarA-9

Thanks, Hosting made the privileges change and it all worked like a charm!