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

Last updated by Itamar 4 months ago.

Assigned support staff: Itamar.

Author Posts
June 5, 2019 at 9:19 am #3958469

jeroenG-5

Hello,

There is a problem detected with some tables in the database, and we should contact het WPML support.

This message is showing on the dashboard:

Array
(
[language] => nl
[context] => admin_texts_wpseo_titles
[gettext_context] =>
[domain_name_context_md5] => xxxxxxxxxxxx
[name] => [wpseo_titles]breadcrumbs-home
[value] => Home
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)

I replaced the domain_name_contact_md5 hash in this message.
If you need it, please let me know.

June 5, 2019 at 6:18 pm #3963365

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi.

Your WordPress installation is a multisite installation, and I can't see the plugins that are installed on your site and whether they are updated. In the past, we had this known issue that might be the issue you are having. Please see it here.
https://wpml.org/errata/duplicate-entry-for-key-uc_domain_name_context_md5/
I'm not entirely sure that it is the same issue because maybe you have not shared with me the full message. If so, can you please share with me the whole message?

If WPML and its add-ons are not updated on your site, then please update them and see if the message still shows.

Otherwise, please tell me if there is any fatal error or another error because of this message, or is it just the message itself that bothers you?

Thanks,
Itamar.

June 7, 2019 at 2:21 pm #3977031

jeroenG-5

Hello Itamar,

Thank you for your reply.
The website is a 5.2.1–nl_NL installation
All plugins are updated to the latest version, we use:
- Limit Login Attempts Reloaded (2.8.1)
- WPML Multilingual CMS (4.2.6)
- WPML String Translation (2.10.4)
- WPML Translation Management (2.8.5)
- Yoast SEO (11.3)

To which whole message are you referring? I only see this message in my dashboard about this problem:

We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.


Array
(
[language] => nl
[context] => admin_texts_wpseo_titles
[gettext_context] =>
[domain_name_context_md5] => d58f3fed38fae2244472c2b21e5027d5
[name] => [wpseo_titles]breadcrumbs-home
[value] => Home
[status] => 0
[translation_priority] => optional
[allow_empty_value] => 1
)

and

{"core":{"Wordpress":{"Multisite":"Yes","SiteURL":"https:\/\/vipxl.nl","HomeURL":"https:\/\/vipxl.nl","Version":"5.2.1","PermalinkStructure":"\/%category%\/%postname%\/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, project","PostStatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed"},"Server":{"jQueryVersion":"1.12.4-wp","PHPVersion":"7.2.19","MySQLVersion":"5.5.60","ServerSoftware":"Apache"},"PHP":{"MemoryLimit":"256M","WP Memory Limit":"64M","UploadMax":"8M","PostMax":"8M","TimeLimit":"30","MaxInputVars":"1000","MBString":true,"libxml":true}},"plugins":{"active_plugins":[],"mu_plugins":[],"dropins":{"maintenance.php":{"Plugin Slug":"","Name":"maintenance.php","PluginURI":"","Version":"","Description":"","Author":"","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"Title":"","AuthorName":""}}},"theme":{"Name":"Divi","ThemeURI":false,"Author":"Elegant Themes","AuthorURI":"http:\/\/www.elegantthemes.com","Template":"","Version":"3.23.3","TextDomain":"","DomainPath":"","ParentName":""},"extra-debug":{"WMPL":{"hide_upgrade_notice":"4.0.5","icl_capabilities_verified":true,"interview_translators":1,"existing_content_language_verified":1,"language_negotiation_type":"1","theme_localization_type":3,"icl_lso_link_empty":0,"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_password":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":0,"alert_delay":0,"promote_wpml":0,"automatic_redirect":0,"remember_language":24,"icl_lang_sel_copy_parameters":"","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":1,"string_name_migrated":true},"urls":{"directory_for_default_language":0,"show_on_root":"","root_html_file_path":"","root_page":0,"hide_language_switchers":1},"xdomain_data":"1","custom_posts_sync_option":{"post":1,"page":1,"attachment":1,"project":1,"et_pb_layout":1},"taxonomies_sync_option":{"category":1,"post_tag":1,"translation_priority":1,"project_category":1,"project_tag":1,"layout_category":1,"layout_type":0,"scope":0,"module_width":0,"layout_pack":0},"tm_block_retranslating_terms":1,"active_languages":["en","nl"],"admin_default_language":"nl","taxonomy_names_checked":true,"ajx_health_checked":true,"setup_complete":1,"default_categories":{"nl":"1","en":6},"default_language":"nl","setup_wizard_step":5,"translation-management":{"custom_fields_translation":{"_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,"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,"_et_pb_predefined_layout":1,"_et_pb_page_layout":1,"_et_pb_side_nav":1,"_et_pb_post_hide_nav":1,"_et_pb_show_title":1,"_et_pb_use_builder":1,"_et_pb_old_content":1,"_et_pb_ab_stats_refresh_interval":1,"_et_pb_ab_bounce_rate_limit":1,"_et_pb_enable_shortcode_tracking":1,"_et_pb_custom_css":1,"_et_pb_light_text_color":1,"_et_pb_dark_text_color":1,"_et_pb_content_area_background_color":1,"_et_post_bg_color":1,"_et_post_bg_layout":1,"_et_pb_use_ab_testing":1,"_et_pb_ab_testing_id":1,"_et_pb_ab_subjects":1,"_et_pb_ab_goal_module":1,"et_pb_post_hide_nav":3,"_et_pb_built_for_post_type":1,"_yoast_wpseo_opengraph-title":2,"_yoast_wpseo_opengraph-image":3,"_yoast_wpseo_twitter-image":3},"custom_fields_readonly_config":["_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","_yoast_wpseo_opengraph-title","_yoast_wpseo_opengraph-image","_yoast_wpseo_twitter-image","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","_et_pb_predefined_layout","_et_pb_page_layout","_et_pb_side_nav","_et_pb_post_hide_nav","_et_pb_show_title","_et_pb_use_builder","_et_pb_old_content","_et_pb_ab_stats_refresh_interval","_et_pb_ab_bounce_rate_limit","_et_pb_enable_shortcode_tracking","_et_pb_custom_css","_et_pb_light_text_color","_et_pb_dark_text_color","_et_pb_content_area_background_color","_et_post_bg_color","_et_post_bg_layout","_et_pb_use_ab_testing","_et_pb_ab_testing_id","_et_pb_ab_subjects","_et_pb_ab_goal_module","et_pb_post_hide_nav","_et_pb_built_for_post_type"],"custom_fields_translation_custom":[],"custom_fields_translation_custom_readonly":[],"doc_translation_method":0,"__custom_types_readonly_config_prev":[],"custom_types_readonly_config":[],"__custom_fields_readonly_config_prev":["_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","_yoast_wpseo_opengraph-title","_yoast_wpseo_opengraph-image","_yoast_wpseo_twitter-image","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","_et_pb_predefined_layout","_et_pb_page_layout","_et_pb_side_nav","_et_pb_post_hide_nav","_et_pb_show_title","_et_pb_use_builder","_et_pb_old_content","_et_pb_ab_stats_refresh_interval","_et_pb_ab_bounce_rate_limit","_et_pb_enable_shortcode_tracking","_et_pb_custom_css","_et_pb_light_text_color","_et_pb_dark_text_color","_et_pb_content_area_background_color","_et_post_bg_color","_et_post_bg_layout","_et_pb_use_ab_testing","_et_pb_ab_testing_id","_et_pb_ab_subjects","_et_pb_ab_goal_module","et_pb_post_hide_nav","_et_pb_built_for_post_type"],"__custom_term_fields_readonly_config_prev":[],"custom_term_fields_readonly_config":[],"taxonomies_readonly_config":{"translation_priority":1,"project_category":1,"project_tag":1,"layout_category":1,"layout_type":0,"scope":0,"module_width":0,"layout_pack":0},"custom-types_readonly_config":{"attachment":1,"project":1,"et_pb_layout":1}},"custom-types_sync_option":{"attachment":1,"project":1,"et_pb_layout":1},"language_selector_initialized":1,"languages_order":["nl","en"],"dont_show_help_admin_notice":true,"site_key":"JQKLhVdJLb","site_does_not_use_icl":true,"st":{"WPML_ST_Upgrade_Migrate_Originals_has_run":true,"WPML_ST_Upgrade_Db_Cache_Command_2.4.2_1_has_run":true,"WPML_ST_Upgrade_Display_Strings_Scan_Notices_has_run":true,"WPML_ST_Upgrade_MO_Scanning_3_has_run":true,"WPML_ST_Upgrade_DB_String_Name_Index_2_has_run":true,"WPML_ST_Upgrade_DB_Longtext_String_Value_has_run":true,"strings_per_page":10,"icl_st_auto_reg":"disable","strings_language":"en","translated-users":[],"db_ok_for_gettext_context":true,"sw":[],"plugin_localization_domains":{"wpml-string-translation\/plugin.php":{"wpml-string-translation":278},"elegant-themes-support\/elegant-themes-support.php":{"et_support":2},"wordpress-seo\/wp-seo.php":{"wordpress-seo":1586},"limit-login-attempts-reloaded\/limit-login-attempts-reloaded.php":{"limit-login-attempts-reloaded":62},"sitepress-multilingual-cms\/sitepress.php":{"installer":1207,"sitepress":23},"wpml-translation-management\/plugin.php":{"wpml-translation-management":1011}},"theme_localization_domains":{"Divi":{"et-core":2,"Divi":641,"et_builder":2608}}},"admin_text_3_2_migration_complete_ae92dd5a52a39031e67eadedf2035949":true,"admin_text_3_2_migration_complete_40cd750bba9870f18aada2478b24840a":true,"admin_text_3_2_migration_complete_97b716772cf69af37edbb4b4c4deabd2":true,"xliff_newlines":1,"tm_xliff_version":"12","language_per_domain_sso_enabled":false,"admin_text_3_2_migration_complete_8218ea3cba0de5405e3f3ff9ea16ea41":true,"admin_text_3_2_migration_complete_f2037c666209c9c799260132ae7cb5b8":true,"admin_text_3_2_migration_complete_6b85f05371150cd5a8becb2545701f1a":true},"installer":{"version":"1.9.4","repositories":{"wpml":{"api-url":"https:\/\/api.wpml.org\/","products":"http:\/\/d2salfytceyqoe.cloudfront.net\/wpml33-products.json","subscription":{"key":"JQKLhVdJLb","data":{"subscription_type":17118,"expires":"2019-08-01","status":"1"},"registered_by":1,"site_url":"http:\/\/vipxl.nl"}},"toolset":{"api-url":"https:\/\/api.toolset.com\/","products":"http:\/\/d7j863fr5jhrr.cloudfront.net\/toolset33-products.json","subscription":""}},"instances":{"\/var\/www\/vhosts\/vipxl.nl\/httpdocs\/wp-content\/plugins\/sitepress-multilingual-cms\/vendor\/otgs\/installer\/installer.php":{"bootfile":"\/var\/www\/vhosts\/vipxl.nl\/httpdocs\/wp-content\/plugins\/sitepress-multilingual-cms\/vendor\/otgs\/installer\/installer.php","version":"1.9.4","args":{"plugins_install_tab":1,"site_key_nags":[{"repository_id":"wpml","product_name":"WPML","condition_cb":[{"locale_utils":{},"footer_preview":false,"icl_translations_cache":null,"icl_language_name_cache":{"name":"language_name","cache_to_option":true,"cache_needs_saving":false},"icl_term_taxonomy_cache":null,"wpdb":{"show_errors":false,"suppress_errors":false,"last_error":"","num_queries":105,"num_rows":1,"rows_affected":0,"insert_id":114856,"last_query":"SELECT meta_value FROM yufS1C3Nu_sitemeta WHERE meta_key = \u0027wpmu_upgrade_site\u0027 AND site_id = 1","last_result":[{"meta_value":"44719"}],"queries":null,"prefix":"yufS1C3Nu_","base_prefix":"yufS1C3Nu_","ready":true,"blogid":1,"siteid":"1","tables":["posts","comments","links","options","postmeta","terms","term_taxonomy","term_relationships","termmeta","commentmeta","yoast_seo_links","yoast_seo_meta"],"old_tables":["categories","post2cat","link2cat"],"global_tables":["users","usermeta"],"ms_global_tables":["blogs","blogmeta","signups","site","sitemeta","sitecategories","registration_log","blog_versions"],"comments":"yufS1C3Nu_comments","commentmeta":"yufS1C3Nu_commentmeta","links":"yufS1C3Nu_links","options":"yufS1C3Nu_options","postmeta":"yufS1C3Nu_postmeta","posts":"yufS1C3Nu_posts","terms":"yufS1C3Nu_terms","term_relationships":"yufS1C3Nu_term_relationships","term_taxonomy":"yufS1C3Nu_term_taxonomy","termmeta":"yufS1C3Nu_termmeta","usermeta":"yufS1C3Nu_usermeta","users":"yufS1C3Nu_users","blogs":"yufS1C3Nu_blogs","blogmeta":"yufS1C3Nu_blogmeta","blog_versions":"yufS1C3Nu_blog_versions","registration_log":"yufS1C3Nu_registration_log","signups":"yufS1C3Nu_signups","site":"yufS1C3Nu_site","sitecategories":"yufS1C3Nu_sitecategories","sitemeta":"yufS1C3Nu_sitemeta","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_ci","func_call":"$db-\u003Equery(\u0022SELECT meta_value FROM yufS1C3Nu_sitemeta WHERE meta_key = \u0027wpmu_upgrade_site\u0027 AND site_id = 1\u0022)","is_mysql":true,"categories":"yufS1C3Nu_categories","post2cat":"yufS1C3Nu_post2cat","link2cat":"yufS1C3Nu_link2cat","yoast_seo_links":"yufS1C3Nu_yoast_seo_links","yoast_seo_meta":"yufS1C3Nu_yoast_seo_meta"}},"setup"]}]},"delegated":true}}}}}
June 10, 2019 at 4:48 pm #3988925

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi and thanks for the extra details.

I think that the message refers to a string from the breadcrumbs option of Yoast. But I do not see that you are using this option on your site. Are you using?
If not then I think it would be safe to dismiss this notice as mentioned in the errata page here.
https://wpml.org/errata/duplicate-entry-for-key-uc_domain_name_context_md5/

But if the issue returns or you see any other problem because of it then, please let me have access to your site so I can check things.
Please also allow me to install the Adminer script (hidden link) to check things on your site. For this, I also need FTP access.

If you need further help with this, please share the access details to your site with me.
I'm enabling a private message for the next reply.

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. --

Thanks,
Itamar.

June 11, 2019 at 6:25 am #3992071

jeroenG-5

Hello Itamar,

The breadcrumb option of Yoast is disabled on all websites of the multi installation.
So I think it is save to ignore the message?

June 11, 2019 at 2:32 pm #3996253

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi.

Yes, I also think that it is safe to ignore it.
Do you have the option to dismiss this message?
If so, please dismiss it. But if after a while it shows again, please tell us about it.

Thanks,
Itamar.

The topic ‘[Closed] Problem detected with some tables in the database’ is closed to new replies.