[Closed] There is a problem with the String Translation table in your site

Hello There,
Thanks for contacting WPML Support.

I understand the issue you're having. The error " There is a problem with the String Translation table" usually happens if there is something wrong with the “_icl_strings” table in the database.

Please try the steps below and I hope it will help.

1. Please take a full backup of your site and database.
2. Once done, add the below code in the theme's functions.php file:

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

3. Visit the home page once.

4. Remove the above code in step #2.

5. Access the database and remove the “wpml_string_table_ok_for_mo_import” key from the “_options” database table.

Here is a doc for more details: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

The steps above most of the time help in solving the issue. Please give it a try and hope the issue will be resolved after that.

Regarding the other issue that you mentioned - The query issue you're facing typically arises from the inclusion of emojis or similar characters in your content. Your database might be using a character encoding that doesn't support characters like emojis. One of the text strings in the 'ProfilePress' plugin contains an Emoji(You're using ProfilePress Lite - no license needed. Enjoy!😊) that is mainly causing the issue here.

Could you please go to "WPML > Theme and Plugins" and check if the option "Automatically load the theme's .mo file using 'load_textdomain'" is enabled? If it is, please remove 'ProfilePress' from the text domain box below that option and check again.

But, if you're still having the issue, please try the solution mentioned in the following ticket.

- https://wpml.org/forums/topic/database-error-cant-perform-query/

Let me know if that helps or if you need further assistance in this matter. I will be happy to help.

Best regards,
Prosenjit