This thread is resolved. Here is a description of the problem and solution.
Problem:
There is a problem with the String Translation table in your site
Solution:
It was a false positive notice and I removed the "wpml_string_table_ok_for_mo_import" key from the *_options database table and the notice is gone.
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: Exception
This topic contains 7 replies, has 2 voices.
Last updated by michaelD-7 1 year, 10 months ago.
Assisted by: Noman.
Author | Posts |
---|---|
April 29, 2023 at 12:23 pm #13561119 | |
michaelD-7 |
I updated the plugins / PHP Version of the site and now getting the error "There is a problem with the String Translation table in your site...." could you please help? |
April 30, 2023 at 10:39 am #13562365 | |
Noman Supporter
Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00) |
Hi, Thank you for contacting WPML Support. Could you please follow the below steps and let me know how it goes: 1. I have noticed that your website’s WP Memory Limit is 40MB. The WP memory limit needs to be increased, it's different from PHP memory. PHP memory is fine but WordPress uses 40Mb as default in your site. The minimum requirements for WPML are 128Mb: https://wpml.org/home/minimum-requirements/ Please add this to the top of wp-config.php to increase WP memory: /* WP Memory Limit */ define('WP_MEMORY_LIMIT', '256M'); 2. Please enable error reporting on your site as I need to see the details of the latest error log to better understand the cause of the issue. To enable it, open your ‘wp-config.php’ file and look for ‘define(‘WP_DEBUG’, false);’. Change it to: // Enable WP_DEBUG mode define( 'WP_DEBUG', true ); // Enable Debug logging to the /wp-content/debug.log file define( 'WP_DEBUG_LOG', true ); // Disable display of errors and warnings define( 'WP_DEBUG_DISPLAY', false ); @ini_set( 'display_errors', 0 ); define( 'SCRIPT_DEBUG', true ); After adding the above code, please try to visit the WPML >> String Translation page, and if this creates a debug.log file in your site's wp-content directory. Please send me its contents. Thank you |
May 1, 2023 at 10:14 am #13564521 | |
michaelD-7 |
I added the configuration as requested, but no debug.log was created. I also enabled PHP error log to see if there is any error but there is nothing. I paste the support information again if this makes any sense: {"core":{"Wordpress":{"Multisite":"No","SiteURL":"http:\/\/www.stefanietrambow.de","HomeURL":"http:\/\/www.stefanietrambow.de","Version":"6.1.1","PermalinkStructure":"\/%postname%\/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, wp_template, wp_template_part, wp_global_styles, wp_navigation, acf-post-type, acf-taxonomy, acf-field-group, acf-field, wpcf7_contact_form, projekt","PostStatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, acf-disabled","RestEnabled":"Yes"},"Server":{"jQueryVersion":"3.6.1","PHPVersion":"8.1.16","MySQLVersion":"10.5.18","ServerSoftware":"Apache"},"PHP":{"MemoryLimit":"512M","WP Memory Limit":"256M","UploadMax":"128M","PostMax":"128M","TimeLimit":"30","MaxInputVars":"1000","MBString":true,"libxml":true}},"plugins":{"active_plugins":{"sitepress-multilingual-cms\/sitepress.php":{"Plugin Slug":"sitepress-multilingual-cms","Name":"WPML Multilingual CMS","PluginURI":"https:\/\/wpml.org\/","Version":"4.6.3","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com\/","TextDomain":"sitepress-multilingual-cms","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"WPML Multilingual CMS","AuthorName":"OnTheGoSystems"},"advanced-custom-fields\/acf.php":{"Plugin Slug":"","Name":"Advanced Custom Fields","PluginURI":"https:\/\/www.advancedcustomfields.com","Version":"6.1.4","Author":"WP Engine","AuthorURI":"https:\/\/wpengine.com\/?utm_source=wordpress.org\u0026utm_medium=referral\u0026utm_campaign=plugin_directory\u0026utm_content=advanced_custom_fields","TextDomain":"acf","DomainPath":"\/lang","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"Advanced Custom Fields","AuthorName":"WP Engine"},"contact-form-7\/wp-contact-form-7.php":{"Plugin Slug":"","Name":"Contact Form 7","PluginURI":"https:\/\/contactform7.com\/","Version":"5.7.2","Author":"Takayuki Miyoshi","AuthorURI":"https:\/\/ideasilo.wordpress.com\/","TextDomain":"contact-form-7","DomainPath":"\/languages\/","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"Contact Form 7","AuthorName":"Takayuki Miyoshi"},"really-simple-captcha\/really-simple-captcha.php":{"Plugin Slug":"","Name":"Really Simple CAPTCHA","PluginURI":"https:\/\/contactform7.com\/captcha\/","Version":"2.1","Author":"Takayuki Miyoshi","AuthorURI":"https:\/\/ideasilo.wordpress.com\/","TextDomain":"really-simple-captcha","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"Really Simple CAPTCHA","AuthorName":"Takayuki Miyoshi"},"taxonomy-terms-order\/taxonomy-terms-order.php":{"Plugin Slug":"","Name":"Category Order and Taxonomy Terms Order","PluginURI":"http:\/\/www.nsp-code.com","Version":"1.7.4","Author":"Nsp-Code","AuthorURI":"https:\/\/www.nsp-code.com","TextDomain":"taxonomy-terms-order","DomainPath":"\/languages\/","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"Category Order and Taxonomy Terms Order","AuthorName":"Nsp-Code"},"wordpress-seo\/wp-seo.php":{"Plugin Slug":"","Name":"Yoast SEO","PluginURI":"https:\/\/yoa.st\/1uj","Version":"19.13","Author":"Team Yoast","AuthorURI":"https:\/\/yoa.st\/1uk","TextDomain":"wordpress-seo","DomainPath":"\/languages\/","Network":false,"RequiresWP":"5.9","RequiresPHP":"5.6.20","UpdateURI":"","Title":"Yoast SEO","AuthorName":"Team Yoast"},"wpml-string-translation\/plugin.php":{"Plugin Slug":"wpml-string-translation","Name":"WPML String Translation","PluginURI":"https:\/\/wpml.org\/","Version":"3.2.5","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com\/","TextDomain":"wpml-string-translation","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"WPML String Translation","AuthorName":"OnTheGoSystems"}},"mu_plugins":[],"dropins":{"advanced-cache.php":{"Plugin Slug":"","Name":"advanced-cache.php","PluginURI":"","Version":"","Description":"","Author":"","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"","AuthorName":""}}},"theme":{"Name":"stefanie-trambow.de","ThemeURI":false,"Author":"Neue Werte GmbH","AuthorURI":"http:\/\/www.neuewerte.de","Template":"","Version":"1.0","TextDomain":"","DomainPath":"","ParentName":""},"extra-debug":{"WPML":{"hide_upgrade_notice":"3.1.6","icl_capabilities_verified":true,"interview_translators":1,"existing_content_language_verified":1,"language_negotiation_type":"1","theme_localization_type":1,"icl_lso_header":0,"icl_lso_link_empty":1,"icl_lso_flags":0,"icl_lso_native_lang":0,"icl_lso_display_lang":1,"sync_page_ordering":1,"sync_page_parent":1,"sync_page_template":1,"sync_ping_status":1,"sync_comment_status":1,"sync_sticky_flag":1,"sync_private_flag":1,"sync_post_format":1,"sync_delete":0,"sync_delete_tax":0,"sync_post_taxonomies":1,"sync_post_date":0,"sync_taxonomy_parents":0,"translation_pickup_method":0,"notify_complete":1,"translated_document_status":1,"remote_management":0,"auto_adjust_ids":1,"alert_delay":0,"promote_wpml":0,"troubleshooting_options":{"http_communication":1},"automatic_redirect":0,"remember_language":24,"icl_lang_sel_type":"dropdown","icl_lang_sel_stype":"classic","icl_lang_sel_orientation":"vertical","icl_lang_sel_copy_parameters":"","icl_widget_title_show":0,"translated_document_page_url":"auto-generate","sync_comments_on_duplicates ":0,"seo":{"head_langs":1,"canonicalization_duplicates":1,"head_langs_priority":1},"posts_slug_translation":{"on":0,"string_name_migrated":true},"languages_order":["en","de"],"urls":{"directory_for_default_language":0,"show_on_root":"","root_html_file_path":"","root_page":0,"hide_language_switchers":1},"admin_default_language":"_default_","ajx_health_checked":true,"dont_show_help_admin_notice":true,"setup_complete":1,"setup_wizard_step":3,"default_categories":{"de":"1","en":14},"default_language":"de","icl_lang_sel_config":{"font-current-normal":"#444444","font-current-hover":"#000000","background-current-normal":"#ffffff","background-current-hover":"#eeeeee","font-other-normal":"#444444","font-other-hover":"#000000","background-other-normal":"#ffffff","background-other-hover":"#eeeeee","border":"#cdcdcd"},"icl_lang_sel_footer_config":{"font-current-normal":"#444444","font-current-hover":"#000000","background-current-normal":"#ffffff","background-current-hover":"#eeeeee","font-other-normal":"#444444","font-other-hover":"#000000","background-other-normal":"#ffffff","background-other-hover":"#eeeeee","border":"#cdcdcd","background":"#ffffff"},"icl_language_switcher_sidebar":"0","icl_lang_sel_footer":0,"icl_post_availability":0,"icl_post_availability_position":"below","icl_post_availability_text":"Dieser Post ist auch verfügbar auf: %s","language_selector_initialized":1,"icl_additional_css":"\t\t\t\t\t\t\t\t\t\t\t","display_ls_in_menu":0,"menu_for_ls":0,"custom_posts_sync_option":{"acf":"0","wpcf7_contact_form":"0","projekt":1,"post":1,"page":1,"attachment":1,"wp_block":1,"wp_navigation":1,"wp_template":1,"wp_template_part":1},"taxonomies_sync_option":{"projekt_kategorie":1,"category":1,"post_tag":1,"translation_priority":1},"st":{"sw":{"strings_language":"de"},"strings_per_page":10,"icl_st_auto_reg":"disable","strings_language":"de","translated-users":[],"theme_localization_domains":["trambow",""],"WPML_ST_Upgrade_Display_Strings_Scan_Notices_has_run":true,"WPML_ST_Upgrade_DB_String_Packages_2.4.2_has_run":true,"WPML_ST_Upgrade_MO_Scanning_4_has_run":true,"WPML_ST_Upgrade_DB_String_Name_Index_2_has_run":true,"WPML_ST_Upgrade_DB_Longtext_String_Value_has_run":true,"WPML_ST_Upgrade_DB_Strings_Add_Translation_Priority_Field_has_run":true,"WPML_ST_Upgrade_DB_String_Packages_Word_Count_has_run":true,"WPML\\ST\\MO\\Generate\\Process\\Status_background_has_run":true,"WPML\\ST\\Upgrade\\Command\\RegenerateMoFilesWithStringNames_has_run":true,"WPML\\ST\\Upgrade\\Command\\MigrateMultilingualWidgets_has_run":true,"db_ok_for_gettext_context":true,"WPML\\ST\\MO\\Generate\\Process\\Status_has_run":true,"WPML_ST_Upgrade_Migrate_Originals_has_run":true},"theme_localization_load_textdomain":0,"gettext_theme_domain_name":"","translation-management":{"notification":{"new-job":1,"completed":1,"resigned":1,"dashboard":true,"purge-old":7},"custom_fields_translation":{"title":2,"description":2,"keywords":2,"_edit_last":0,"_edit_lock":0,"_wp_page_template":0,"_wp_attachment_metadata":0,"original_post_id":0,"_wpml_original_post_id":0,"_wp_old_slug":0,"_icl_translator_note":0,"_alp_processed":0,"_pingme":0,"_encloseme":0,"_icl_lang_duplicate_of":0,"_thumbnail_id":0,"_wp_attached_file":0,"_wp_attachment_image_alt":2,"_yoast_wpseo_title":2,"_yoast_wpseo_bctitle":2,"_yoast_wpseo_metadesc":2,"_yoast_wpseo_metakeywords":2,"_yoast_wpseo_focuskw":2,"_yoast_wpseo_meta-robots-noindex":1,"_yoast_wpseo_meta-robots-nofollow":1,"_yoast_wpseo_meta-robots-adv":1,"_yoast_wpseo_canonical":0,"_yoast_wpseo_redirect":0,"_yoast_wpseo_opengraph-description":2,"_yoast_wpseo_google-plus-description":2,"_yoast_wpseo_twitter-title":2,"_yoast_wpseo_twitter-description":2},"doc_translation_method":0,"custom_fields_readonly_config":["title","description","keywords","_edit_last","_edit_lock","_wp_page_template","_wp_attachment_metadata","original_post_id","_wpml_original_post_id","_wp_old_slug","_icl_translator_note","_alp_processed","_pingme","_encloseme","_icl_lang_duplicate_of","_thumbnail_id","_wp_attached_file","_wp_attachment_image_alt","_yoast_wpseo_title","_yoast_wpseo_bctitle","_yoast_wpseo_metadesc","_yoast_wpseo_metakeywords","_yoast_wpseo_focuskw","_yoast_wpseo_meta-robots-noindex","_yoast_wpseo_meta-robots-nofollow","_yoast_wpseo_meta-robots-adv","_yoast_wpseo_canonical","_yoast_wpseo_redirect","_yoast_wpseo_opengraph-description","_yoast_wpseo_google-plus-description","_yoast_wpseo_twitter-title","_yoast_wpseo_twitter-description"],"custom_fields_translation_custom":[],"custom_fields_translation_custom_readonly":[],"__custom_types_readonly_config_prev":[],"custom_types_readonly_config":[],"__custom_fields_readonly_config_prev":["title","description","keywords","_edit_last","_edit_lock","_wp_page_template","_wp_attachment_metadata","original_post_id","_wpml_original_post_id","_wp_old_slug","_icl_translator_note","_alp_processed","_pingme","_encloseme","_icl_lang_duplicate_of","_thumbnail_id","_wp_attached_file","_wp_attachment_image_alt","_yoast_wpseo_title","_yoast_wpseo_bctitle","_yoast_wpseo_metadesc","_yoast_wpseo_metakeywords","_yoast_wpseo_focuskw","_yoast_wpseo_meta-robots-noindex","_yoast_wpseo_meta-robots-nofollow","_yoast_wpseo_meta-robots-adv","_yoast_wpseo_canonical","_yoast_wpseo_redirect","_yoast_wpseo_opengraph-description","_yoast_wpseo_google-plus-description","_yoast_wpseo_twitter-title","_yoast_wpseo_twitter-description"],"__custom_term_fields_readonly_config_prev":[],"custom_term_fields_readonly_config":[],"taxonomies_readonly_config":{"translation_priority":1},"custom-types_readonly_config":{"attachment":1,"wp_block":1,"wp_navigation":1,"wp_template":1,"wp_template_part":1}},"just_reactivated":0,"show_untranslated_blog_posts":"0","show_translations_flag":1,"active_languages":["en","de"],"sync_password":1,"sync_comments_on_duplicates":0,"xdomain_data":1,"tm_block_retranslating_terms":1,"site_does_not_use_icl":true,"xliff_newlines":2,"tm_xliff_version":"12","admin_text_3_2_migration_complete_429798f285f4cd16809e8a8edf5512c1":true,"custom-types_sync_option":{"attachment":1,"wp_block":1,"wp_navigation":1,"wp_template":1,"wp_template_part":1}},"installer":{"version":"3.0.5","repositories":{"wpml":{"api-url":"https:\/\/api.wpml.org\/","bucket-url":"https:\/\/wpmlorg.s3.amazonaws.com\/wpml-bucket-57.json","subscription":{"key":"lh83WKWDvC","key_type":0,"data":{"subscription_type":6721,"expires":null,"status":"1","notes":"","order_id":"368856","hasAutoRenewal":true},"registered_by":2,"site_url":"http:\/\/www.stefanietrambow.de"},"last-successful-subscription-fetch":"2023-05-01 09:34:50"},"toolset":{"api-url":"https:\/\/api.toolset.com\/","bucket-url":"not assigned","subscription":"","last-successful-subscription-fetch":"none"}},"instances":{"\/home\/trambow\/websites\/stefanietrambow.de\/htdocs\/wp-content\/plugins\/sitepress-multilingual-cms\/vendor\/otgs\/installer\/installer.php":{"bootfile":"\/home\/trambow\/websites\/stefanietrambow.de\/htdocs\/wp-content\/plugins\/sitepress-multilingual-cms\/vendor\/otgs\/installer\/installer.php","version":"3.0.5","args":{"plugins_install_tab":1,"site_key_nags":[{"repository_id":"wpml","product_name":"WPML","condition_cb":[{"wpdb":{"show_errors":false,"suppress_errors":false,"last_error":"","num_queries":83,"num_rows":0,"rows_affected":0,"insert_id":0,"last_query":"SELECT option_value FROM wp_trambow41231_options WHERE option_name = \u0027auto_core_update_failed\u0027 LIMIT 1","last_result":[],"queries":null,"prefix":"wp_trambow41231_","base_prefix":"wp_trambow41231_","ready":true,"blogid":0,"siteid":0,"tables":["posts","comments","links","options","postmeta","terms","term_taxonomy","term_relationships","termmeta","commentmeta"],"old_tables":["categories","post2cat","link2cat"],"global_tables":["users","usermeta"],"ms_global_tables":["blogs","blogmeta","signups","site","sitemeta","registration_log"],"old_ms_global_tables":["sitecategories"],"comments":"wp_trambow41231_comments","commentmeta":"wp_trambow41231_commentmeta","links":"wp_trambow41231_links","options":"wp_trambow41231_options","postmeta":"wp_trambow41231_postmeta","posts":"wp_trambow41231_posts","terms":"wp_trambow41231_terms","term_relationships":"wp_trambow41231_term_relationships","term_taxonomy":"wp_trambow41231_term_taxonomy","termmeta":"wp_trambow41231_termmeta","usermeta":"wp_trambow41231_usermeta","users":"wp_trambow41231_users","blogs":null,"blogmeta":null,"registration_log":null,"signups":null,"site":null,"sitecategories":null,"sitemeta":null,"field_types":{"post_author":"%d","post_parent":"%d","menu_order":"%d","term_id":"%d","term_group":"%d","term_taxonomy_id":"%d","parent":"%d","count":"%d","object_id":"%d","term_order":"%d","ID":"%d","comment_ID":"%d","comment_post_ID":"%d","comment_parent":"%d","user_id":"%d","link_id":"%d","link_owner":"%d","link_rating":"%d","option_id":"%d","blog_id":"%d","meta_id":"%d","post_id":"%d","user_status":"%d","umeta_id":"%d","comment_karma":"%d","comment_count":"%d","active":"%d","cat_id":"%d","deleted":"%d","lang_id":"%d","mature":"%d","public":"%d","site_id":"%d","spam":"%d"},"charset":"utf8mb4","collate":"utf8mb4_unicode_520_ci","func_call":"$db-\u003Equery(\u0022SELECT option_value FROM wp_trambow41231_options WHERE option_name = \u0027auto_core_update_failed\u0027 LIMIT 1\u0022)","is_mysql":true,"time_start":null,"error":null,"categories":"wp_trambow41231_categories","post2cat":"wp_trambow41231_post2cat","link2cat":"wp_trambow41231_link2cat"},"locale_utils":{},"footer_preview":false,"icl_translations_cache":null,"icl_language_name_cache":{},"icl_term_taxonomy_cache":null},"setup"]}]},"delegated":true}}}}} |
May 2, 2023 at 10:01 am #13569675 | |
Noman Supporter
Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00) |
Okay, To take a closer look at this issue, please provide temporary access (WP-Admin and FTP Login info) to your site (preferably staging site), so that I can look into your setup and debug the issue. Your next answer will be private which means only you and I have access to it. === Please backup your database and website === ✙ I would additionally need your permission to deactivate and reactivate Plugins and the Theme and to change configurations on the site. This is also a reason the backup is really important. Thank you |
May 2, 2023 at 10:04 am #13569681 | |
michaelD-7 |
Could you please provide me with your public ssh key as there is no FTP access to this server. |
May 2, 2023 at 10:59 am #13569905 | |
Noman Supporter
Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00) |
Please take a complete backup of your site and only provide the wp-admin login info of your site at the moment. Thank you |
May 2, 2023 at 3:18 pm #13572009 | |
Noman Supporter
Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00) |
It was a false positive notice and I removed the "wpml_string_table_ok_for_mo_import" key from the *_options database table. The error should be solved now, could you please check and confirm? Thank you |