Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 -
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 -

Supporter timezone: America/Sao_Paulo (GMT-03:00)

This topic contains 8 replies, has 2 voices.

Last updated by Mateus Getulio 1 year, 4 months ago.

Assisted by: Mateus Getulio.

Author Posts
August 3, 2023 at 11:30 am #14148983

wimF

I get an error message saying there's a problem, and that I need to contact support (or rather it says so on https://wpml.org/faq/how-to-deal-with-error-messages-about-a-broken-table-that-needs-fixing/)

wpml_error_message.png
August 3, 2023 at 7:42 pm #14151625

Mateus Getulio
Supporter

Languages: English (English ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hello there,

Welcome to our support forum. I’ll be happy to assist you with this!

We've found some edge cases where this error is fixed by following these instructions to recreate the icl_tables:

- Make a full backup of your site (files and database)
- Please add this code to the bottom of the functions.php file in your theme's root folder

function wpml_fix_missing_icl_tables() {
    
    if( function_exists( 'icl_sitepress_activate' ) )
    
        icl_sitepress_activate();
    
}
    
add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );

- Visit your site's homepage at least one time
- Remove the code

Once you complete these steps, then you have to remove the keys "wpml_string_table_ok_for_mo_import" and "wpml_notices" from the options table (by default wp_options, where "wp_" is your database prefix), and all errors should be gone.

Please give it a try and let us know if it works for you. We're looking forward to your reply. Thanks!

Kind regards,
Mateus.

August 10, 2023 at 8:28 am #14180165

wimF

Is there a way to do this without accessing the functions.php? I do not have access to it on this environment.

August 10, 2023 at 8:29 am #14180167

wimF

I do have access to PHPMyAdmin, if that helps.

August 10, 2023 at 11:29 am #14181923

wimF

I have used a snippet plugin, but I still get the error. Can't you just tell me what tables I need to create?

August 10, 2023 at 1:23 pm #14182667

Mateus Getulio
Supporter

Languages: English (English ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hi there,

Thanks for your reply.

Another option is to use a plugin like 'File Manager' - in order to edit the functions.php file.

Here it goes the tables we have in the database: https://wpml.org/documentation/support/wpml-tables/.

Please be very cautious if you try to recreate them manually, and ensure to have a complete backup.

Looking forward to your reply. Thank you.

August 10, 2023 at 2:23 pm #14183305

wimF

Like I said, I have added the code through a snippets-plugin. I can clearly see it has run, but it doesn't actually remove the error (it just re-populates the notices options with the values I just deleted). Is there a way to check why the activation keeps failing? It seems to only partially run the activation process and the "migrations" that are included in the plugin.

August 10, 2023 at 3:34 pm #14183993

Mateus Getulio
Supporter

Languages: English (English ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hello,

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 backup the site before providing us access. In the event that 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.

Privacy and Security Policy

We have strict policies regarding privacy and access to your information. Please see:
https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

**IMPORTANT**

- Please make a backup of site files and database before providing us access.
- If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link

Please, let me know if you need any additional details. Have a nice day.

August 11, 2023 at 1:44 pm #14188921

Mateus Getulio
Supporter

Languages: English (English ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hi there,

Thanks for providing the credentials.

It seems that you haven't started to translate your content, right? In this case, the issue might be resolved by resetting WPML. You can do that in WPML -> Support -> Click on troubleshooting page link -> Scroll down to the end of the page -> Choose I am about to reset all translation and language data -> Click Reset. Our doc related: https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/

Then you can try to run the WPML wizard setup again, and check if the problem is solved.

Please note that this solution works with WPML's new installations only since the reset option will delete all WPML tables and the translations you have on your website, if you have any.

Just ensure to make a backup before any changes on your website and let me know if this resolves your issue.

Thank you,
Mateus.

The topic ‘[Closed] There is a problem with the String Translation table in your site’ is closed to new replies.