Background of the issue:
I am trying to complete translations for some pages on my site hidden link using WPML. I initially used automatic translations, but they remained pending. I then attempted manual translations.
Symptoms:
When I click the 'review' button in the translation queue, all strings are translated, and I click 'complete translation,' but the page remains in the translation queue with a status of 'in progress.'
Questions:
How can I get those pages to be shown as complete instead of in progress
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Rome (GMT+01:00)
They are not files, they are database entries. You're looking for the content files instead of the site database entries. Your siteground hosting has a way to check the database, but you may be able to ask the support of your hosting to do what I asked for you 🙂
Ah, sorry I missed that and assumed they were files. What table are these in? Do you have a sql query I can run? I ran various searches and can't find these anywhere.
SELECT * FROM `hfw_options` WHERE option_name like 'wpml%' order by option_name returns:
wpml_allow_translatable_job_fields a:0:{} on
wpml_base_slug_translation 1 auto
wpml_built_with_page_builder a:1:{i:0;s:10:"/<!-- wp:/";} on
wpml_config_files_arr O:8:"stdClass":2:{s:6:"themes";a:0:{}s:7:"plugins"... off
wpml_config_index O:8:"stdClass":2:{s:7:"plugins";a:105:{i:0;O:8:"st... off
wpml_config_index_updated 1741266269 off
wpml_dependencies:expected_versions a:7:{s:23:"wpml-string-translation";s:5:"3.3.0";s:... auto
wpml_dependencies:installed_plugins a:2:{s:26:"sitepress-multilingual-cms";s:5:"4.7.1"... auto
wpml_dependencies:invalid_plugins a:0:{} auto
wpml_dependencies:needs_validation auto
wpml_dependencies:valid_plugins a:2:{i:0;s:26:"sitepress-multilingual-cms";i:1;s:2... auto
WPML_Group_Keys a:9:{i:0;s:11:"WPML(setup)";i:1;s:8:"WPML(ST)";i:2... auto
wpml_language_switcher a:8:{s:8:"migrated";i:0;s:18:"converted_menu_ids";... auto
wpml_language_switcher_template_objects a:6:{s:20:"wpml-legacy-dropdown";a:12:{s:4:"path";... auto
wpml_login_page_translation 1 auto
wpml_login_page_translation_update_rules auto
wpml_notices a:1:{s:7:"default";a:1:{s:31:"SendStringsForTransl... off
wpml_shortcode_list a:291:{i:0;s:14:"call_to_action";i:1;s:10:"newslet... on
wpml_show_login_page_language_switcher 1 off
WPML_SITE_ID:ate 30663130-3165-5363-a663-643062623766 off
WPML_SITE_ID:global 61633165-3638-5333-b733-313936373237 off
wpml_st_display_strings_scan_notices 1 auto
wpml_start_version 4.7.1 auto
wpml_string_table_ok_for_mo_import yes on
wpml_strings_need_links_fixed a:108:{i:2;s:3:"134";i:3;i:313;i:4;i:314;i:5;i:470... auto
WPML_TM_AMS a:4:{s:7:"user_id";i:5;s:6:"secret";s:44:"Y2w7RWrb... auto
wpml_tp_com_log astest-growing Language Service Providers in the w... off
wpml_translation_services a:96:{i:0;O:15:"WPML_TP_Service":39:{s:2:"id";i:10... off
wpml_translation_services_timestamp 1741110402 auto
wpml_update_statuses a:51:{s:31:"wpml-upgrade-localization-files";b:1;s... on
wpml_wp_updated_mo_files a:3:{s:4:"core";a:1:{s:7:"default";i:1741110964;}s... off
wpml_xliff_shortcodes a:1:{i:0;s:7:"caption";} off
wpml-cache-translators-manage_translations a:0:{} auto
wpml-cache-translators-translate a:3:{i:5;s:11:"Chad Gilles";i:6;s:6:"Mark H";i:8;s... auto
wpml-gutenberg-config a:70:{s:14:"core/paragraph";a:1:{s:5:"xpath";a:1:{... off
wpml-gutenberg-config-ids-in-blocks a:1:{s:10:"core/image";a:1:{s:3:"key";a:1:{s:2:"id... on
wpml-old-jobs-editor wpml auto
wpml-package-translation-db-updates-run a:1:{i:0;s:5:"0.0.2";} auto
wpml-package-translation-refresh-required no off
wpml-package-translation-string-packages-table-upd... 0.0.2 off
wpml-package-translation-string-table-updated 1 off
wpml-previous-default-language en auto
wpml-tm-all-translation-jobs-migration 3 on
wpml-tm-translation-jobs-migration 1 on
wpml.WPML\Media\Translate\Endpoint\PrepareForTrans... 1741110405 off
wpml.WPML\Media\Translate\Endpoint\PrepareForTrans... 794d795a-c953-4433-8c2c-eda322a450a2 auto
wpml.WPML\TM\ATE\Sitekey\Endpoint.lock 1741110404 off
WPML(api-pb-config) a:1:{s:9:"elementor";a:75:{s:13:"stripe-button";a:... off
WPML(last) a:1:{s:17:"WPML\TM\ATE\Retry";i:1741359150;} off
WPML(logs) a:1:{s:10:"TM\ATE\Log";a:50:{i:0;a:6:{s:9:"timesta... off
WPML(post-type) a:1:{s:16:"automatic-config";a:9:{s:10:"attachment... on
WPML(setup) a:10:{s:13:"is-tm-allowed";b:1;s:13:"original-lang... off
WPML(ST) a:1:{s:50:"WPML\ST\Batch\Translation\Records_schem... on
WPML(tea_previously_unsupported_content) a:2:{s:19:"post_types_executed";b:1;s:17:"packages... on
WPML(TM-has-run) a:1:{s:24:"WPML\TM\ATE\Sitekey\Sync";b:1;} on
WPML(TM) a:2:{s:35:"previous-custom-fields-to-translate";a:... on
