Skip Navigation

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

Problem:
The client reported an issue where WPML was generating an error due to a missing WordPress database table.
Solution:
We recommended the client ensure they had a full site backup. We then requested WP-Admin credentials to access the site and address the issue directly. After receiving the credentials, we created the missing database table, resolving the error. Additionally, for removing language data, we guided the client to disable the unwanted languages first, then use the option to remove the data for those languages, as detailed in our documentation here: https://wpml.org/faq/how-to-completely-remove-a-language-from-your-site/

If this solution does not resolve your issue, or if it seems outdated, 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.

This topic contains 23 replies, has 1 voice.

Last updated by Carlos Rojas 1 month, 1 week ago.

Assisted by: Carlos Rojas.

Author Posts
May 28, 2025 at 2:07 pm #17083939

Fabio Fava

Hey Carlos,

I've had contacted my hosting, and the attached image is the last error triggered related to WPML. It seems that it's stopped triggering errors, but I'll keep watching for some more time to make sure it's all good. Your patience is greatly appreciated.

Thank you so much, cheers!

Screen Shot.png
May 28, 2025 at 2:43 pm #17084100

Fabio Fava

Hey Carlos,

As you can see on the attached pictures, I've had 4 more errors triggered on the last hour or so. It seems that when I login to my WP-Admin, errors occur.

I've removed Paid Memberships Pro (PMPro) and WooCommerce (WC) from this website, and I'm affraid there are lots of requests to non-existing pages, products, and remaining WooCommerce, and PMPro membership data left behind.

The site is currently running only Brazilan Portuguese (as a Custom Language, since I've changed its prefix from "pt-br" to just "br"). All other languages are hidden and I'd like to clean all data for the hidden languages, plugins, products, etcetera; is that possible?

Is there any safe way to "clean" WPML from removed plugins (also Theme My Login was removed, among others), so to help WPML to be faster? I've carefully cleaned what I could from the DataBase using Plugins Garbage Collector (not removed any "icl" tables), but I feel that lots of remains are present in many places on the website (strings, etcetera).

I'll keep looking forward from you on my issues, please check the attached screenshots from my hosting Logs.

Thank you very much and best regards

Screen Shot 3.png
Screen Shot 2.png
Screen Shot 1.png
Screen Shot.png
May 28, 2025 at 8:44 pm #17085443

Carlos Rojas
WPML Supporter since 03/2017

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

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

Hi there,

I have added the missing table, so the latest error won't appear again 🙂

To remove the information of any language, first you must disable it, and then you will see the option to remove the information in that particular language, as described in this link: https://wpml.org/faq/how-to-completely-remove-a-language-from-your-site/

May 28, 2025 at 11:28 pm #17085659

Fabio Fava

Hey Carlos, thank you for the informations.

On the information removal, I've done the proposed steps to remove all languages, clicked to remove the information on those languages. And I've also delete many unneeded strings on the String Translation. Ont he troubleshooting page, I've set to show all strings with issues and deleted them all.

Should I do any other step to clean and, if needed, recreate missing strings?

I'll keep checking a bit more about the errors on my site relating to WPML. In case they disappear I'll then close the ticket, otherwise I'll keep posting here.

Thank you once more and best regards.

May 29, 2025 at 6:30 am #17086094

Carlos Rojas
WPML Supporter since 03/2017

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

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

Hi!

You did all the steps already to remove the information on the disabled languages 🙂

Please let me know if there is any other error from the database.

May 29, 2025 at 12:16 pm #17087874

Fabio Fava

Hey Carlos,

It seems that it's gone. I assume those old strings needed to be removed, for the sake of the website.

Since this site was cloned from another one, my WP Database Prefix is still using the old prefix from the old site. I'd need to change that prefix to a new prefix. Assuming I do the golden standard (rename them all on PhPMyAdmin and change it in wp-config.php), will WPML find any issue or break the site in some way?

I know this would need another ticket, but since it's not a WPML-specific issue (may happen with other installed plugins), maybe you can help me just getting proper info on what to do for success. I don't think it's a case to hire a developer, I know how to do it.

The question is if I should use some Search & Replace plugin to change al references on the DB tables? Or the plugins just use the prefix defined in wp-config.php and go further from there on getting properly working. Any light on this matter?

Thank you so much once more, for all your patience and precious support!

May 29, 2025 at 12:21 pm #17087881

Carlos Rojas
WPML Supporter since 03/2017

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

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

Hey,
I'm happy to hear that the issue disappeared 🙂

If the developers used good practices in their code, the plugins should use the prefix in the wp-config.php file. WPML plugins use good practices in their code, so this shouldn't be a problem.

However, instead of manually changing the DB prefix, I recommend exporting the site and then importing it using a migration plugin, like Duplicator or All-In-One Migration which takes care of the DB prefix when restoring the site.

May 29, 2025 at 12:41 pm #17087987

Fabio Fava

Thank you Carlos for your advise!

My site uses a Theme (Pro w/ Cornerstone from Theme.co using a simple and short Child-Theme I've tailored for my website) and only good-practices plugins & add-ons, so I assume it won't be a problem on this side.

I've used All-in-One WP Migration for local dev to production migration. Would be possible to recover it to the very same site I've used to export it from? I have some key add-ons for AIOWPM, wich allow me to move unlimited sized sites.

I"ll keep looking forward on your advise before proceeding.

Thank you again for so many wise words, brother.

May 29, 2025 at 2:27 pm #17088578

Fabio Fava

I've done the WP DB Prefix change using a plugin, following an article on the web. Worked just fine.

Now my challenge will be to find a proper way to change the DB name and DB username from the old to a new (even if random).

Thank you so much for all your help, wish you all the best!

May 29, 2025 at 6:03 pm #17089463

Carlos Rojas
WPML Supporter since 03/2017

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

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

Excellent news!

Please don't hesitate to contact us if you need our help in the future with WPML.
Have an excellent day!