Skip Navigation

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

Problem:
I have this Error message shown and can't find a way to solve it

Table 'hozjann_spinesoc.sp_icl_strings' doesn't exist
Array
(
[language] => de
[context] => admin_texts_et_divi
[gettext_context] =>
[domain_name_context_md5] => 9400e45aac65dfcb8531a168ff17ea9b
[name] => [et_divi]divi_logo
[value] =>
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)
Solution:
We've found some edge cases where this error is fixed following these instructions to recreate 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.
Relevant Documentation:
https://wpml.org/es/errata/missing-_icl_strings-_icl_string_translations-data-tables/

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 2 replies, has 2 voices.

Last updated by bennyH 1 year, 11 months ago.

Assisted by: Mateus Getulio.

Author Posts
April 27, 2022 at 10:39 am #11104129

bennyH

I have this Error message shown and can't find a way to solve it

Table 'hozjann_spinesoc.sp_icl_strings' doesn't exist
Array
(
[language] => de
[context] => admin_texts_et_divi
[gettext_context] =>
[domain_name_context_md5] => 9400e45aac65dfcb8531a168ff17ea9b
[name] => [et_divi]divi_logo
[value] =>
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)

Bildschirmfoto 2022-04-27 um 12.37.58.png
April 27, 2022 at 8:57 pm #11108785

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 following these instructions to recreate 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.

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.