Skip Navigation

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.

Elementor users - please update WPML to the latest version to maintain compatibility. More details here - https://wpml.org/changelog/2024/12/wpml-4-6-15-critical-update-for-elementor-sites/
Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 13:00 9:00 – 13:00 9:00 – 13:00 8:00 – 12:00 8:00 – 12:00 -
- 14:00 – 17:00 14:00 – 18:00 14:00 – 18:00 13:00 – 17:00 13:00 – 17:00 -

Supporter timezone: Europe/Zagreb (GMT+01:00)

This topic contains 0 replies, has 0 voices.

Last updated by Bruno Kos 4 days, 2 hours ago.

Assisted by: Bruno Kos.

Author Posts
December 16, 2024 at 5:55 am #16515790

gurshinderS-2

Background of the issue:
I am trying to upload and activate the WPML plugin on my website hosted on the Azure platform. The website URL is hidden link.

Symptoms:
The website is getting down after activating the WPML plugin. My hosting is Microsoft Azure Platform. I have given the screenshot of errors i am receiving

Questions:
Why is my website going down after activating the WPML plugin?
How can I successfully activate the WPML plugin without issues?

December 16, 2024 at 6:37 am #16515890

Bruno Kos
Supporter

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+01:00)

Can you please try the following:

1. **Log in to Azure Portal**:
- Access your Azure account at [Azure Portal](hidden link).

2. **Modify Azure WAF Policy**:
- Navigate to your Azure WAF Policy under Application Gateway or Front Door.
- Under **Managed Rules**, add an exclusion rule to bypass specific blocking rules.
- **Settings for the Exclusion Rule**:
- **Match Variable**: Request URI
- **Operator**: Contains
- **Value**: `cdn.wpml.org/wpml-config/config-index.json`

3. **Allow Outbound Requests**:
- Confirm that the server hosting your WordPress site can make outbound requests to `cdn.wpml.org`.
- Adjust your firewall settings or Network Security Groups in Azure as needed to allow this connection.

4. **Test Access**:
- Verify that the file at `hidden link` can be accessed.
- Confirm the WPML plugin is functioning correctly.

5. **Verify Connectivity**:
- If issues persist, check the WAF logs to identify if Azure is still blocking the outbound connection.
- Test connectivity using a tool like `cURL`:

 curl -I <em><u>hidden link</u></em>

Let me know if additional troubleshooting steps are needed!

December 16, 2024 at 12:17 pm #16517200

gurshinderS-2

Hi

I have tried the same process you mentioned last time but still my issue is not solved ...

here is the debug.log file last few lines

[16-Dec-2024 10:44:53 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_languages' doesn't exist for query
SELECT
l.code,
m.locale,
l.default_locale
FROM wp_icl_languages AS l
LEFT JOIN wp_icl_locale_map AS m ON m.code = l.code
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/advanced-custom-fields-pro/acf.php'), acf, ACF->initialize, __, translate, get_translations_for_domain, _load_textdomain_just_in_time, determine_locale, get_locale, apply_filters('locale'), WP_Hook->apply_filters, SitePress->locale_filter, WPML_Locale->locale, WPML_Locale->get_locale, WPML_Locale->get_all_locales
[16-Dec-2024 10:44:54 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query SELECT * FROM wp_icl_mo_files_domains made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Initialize->run, WPML_ST_Initialize->loadEarlyHooks, WPML\ST\TranslationFile\Hooks->install, WPML_Action_Filter_Loader->load, WPML_Action_Filter_Loader->load_factory_or_action, WPML_Action_Filter_Loader->load_factory, WPML_Action_Filter_Loader->run_factory, WPML\ST\MO\Hooks\CustomTextDomains->add_hooks, WPML\ST\TranslationFile\Domains->getCustomMODomains, WPML\ST\TranslationFile\Domains->getMODomains, WPML\ST\TranslationFile\Domains->getJEDDomains, WPML_ST_Translations_File_Dictionary->get_domains, WPML_ST_Translations_File_Dictionary_Storage_Table->find, WPML_ST_Translations_File_Dictionary_Storage_Table->load_data
[16-Dec-2024 10:44:54 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_strings' doesn't exist for query
SELECT DISTINCT context
FROM wp_icl_strings
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Initialize->run, WPML_ST_Initialize->loadEarlyHooks, WPML\ST\TranslationFile\Hooks->install, WPML_Action_Filter_Loader->load, WPML_Action_Filter_Loader->load_factory_or_action, WPML_Action_Filter_Loader->load_factory, WPML_Action_Filter_Loader->run_factory, WPML\ST\MO\Hooks\CustomTextDomains->add_hooks, WPML\ST\TranslationFile\Domains->getCustomMODomains, WPML\ST\TranslationFile\Domains->getMODomains
[16-Dec-2024 10:45:01 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_translations' doesn't exist for query SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_on_front'
LIMIT 1))
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF->init, do_action('acf/init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF_Taxonomy->register_taxonomies, ACF_Internal_Post_Type->get_posts, ACF_Internal_Post_Type->get_raw_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/languages/ar.mo', '3251dc671a31b3095630eb4f870aca28', 'default', 'not_imported', 0, 1733896610, 'other', '' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/sitepress-multilingual-cms/locale/sitepress-ar.mo', 'e31bce056d0b1e813c9092865d2f5eb3', 'sitepress', 'not_imported', 0, 1734345247, 'plugin', 'sitepress-multilingual-cms/sitepress.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/advanced-custom-fields-pro/lang/acf-ar.mo', '925ac7cb08c8b2f07bbac74e168c8d2e', 'acf', 'not_imported', 0, 1731912307, 'plugin', 'advanced-custom-fields-pro/acf.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/updraftplus/languages/updraftplus-ar.mo', '82dfecbe85ff9ce93c6a7619d418af0f', 'updraftplus', 'not_imported', 0, 1732344873, 'plugin', 'updraftplus/updraftplus.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/sitepress-multilingual-cms/locale/wpml-translation-management-ar.mo', 'c7b88e8561418b298fb021ed8b2657aa', 'wpml-translation-management', 'not_imported', 0, 1734345247, 'plugin', 'sitepress-multilingual-cms/sitepress.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:09 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/languages/admin-ar.mo', '8561c993122e01db02cf002d0dd10971', 'default', 'not_imported', 0, 1733896608, 'other', '' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:12 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_languages' doesn't exist for query
SELECT
l.code,
m.locale,
l.default_locale
FROM wp_icl_languages AS l
LEFT JOIN wp_icl_locale_map AS m ON m.code = l.code
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/advanced-custom-fields-pro/acf.php'), acf, ACF->initialize, __, translate, get_translations_for_domain, _load_textdomain_just_in_time, determine_locale, get_locale, apply_filters('locale'), WP_Hook->apply_filters, SitePress->locale_filter, WPML_Locale->locale, WPML_Locale->get_locale, WPML_Locale->get_all_locales
[16-Dec-2024 10:45:13 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query SELECT * FROM wp_icl_mo_files_domains made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Initialize->run, WPML_ST_Initialize->loadEarlyHooks, WPML\ST\TranslationFile\Hooks->install, WPML_Action_Filter_Loader->load, WPML_Action_Filter_Loader->load_factory_or_action, WPML_Action_Filter_Loader->load_factory, WPML_Action_Filter_Loader->run_factory, WPML\ST\MO\Hooks\CustomTextDomains->add_hooks, WPML\ST\TranslationFile\Domains->getCustomMODomains, WPML\ST\TranslationFile\Domains->getMODomains, WPML\ST\TranslationFile\Domains->getJEDDomains, WPML_ST_Translations_File_Dictionary->get_domains, WPML_ST_Translations_File_Dictionary_Storage_Table->find, WPML_ST_Translations_File_Dictionary_Storage_Table->load_data
[16-Dec-2024 10:45:13 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_strings' doesn't exist for query
SELECT DISTINCT context
FROM wp_icl_strings
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Initialize->run, WPML_ST_Initialize->loadEarlyHooks, WPML\ST\TranslationFile\Hooks->install, WPML_Action_Filter_Loader->load, WPML_Action_Filter_Loader->load_factory_or_action, WPML_Action_Filter_Loader->load_factory, WPML_Action_Filter_Loader->run_factory, WPML\ST\MO\Hooks\CustomTextDomains->add_hooks, WPML\ST\TranslationFile\Domains->getCustomMODomains, WPML\ST\TranslationFile\Domains->getMODomains
[16-Dec-2024 10:45:15 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_translations' doesn't exist for query SELECT element_id, language_code
FROM wp_icl_translations
WHERE trid =
(SELECT trid
FROM wp_icl_translations
WHERE element_type = 'post_page'
AND element_id = (SELECT option_value
FROM wp_options
WHERE option_name='page_on_front'
LIMIT 1))
made by include('hidden link'), include('hidden link'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF->init, do_action('acf/init'), WP_Hook->do_action, WP_Hook->apply_filters, ACF_Taxonomy->register_taxonomies, ACF_Internal_Post_Type->get_posts, ACF_Internal_Post_Type->get_raw_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option, apply_filters('pre_option_page_on_front'), WP_Hook->apply_filters, SitePress->pre_option_page_on_front, WPML_Pre_Option_Page->get
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/languages/ar.mo', '3251dc671a31b3095630eb4f870aca28', 'default', 'not_imported', 0, 1733896610, 'other', '' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/sitepress-multilingual-cms/locale/sitepress-ar.mo', 'e31bce056d0b1e813c9092865d2f5eb3', 'sitepress', 'not_imported', 0, 1734345899, 'plugin', 'sitepress-multilingual-cms/sitepress.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/advanced-custom-fields-pro/lang/acf-ar.mo', '925ac7cb08c8b2f07bbac74e168c8d2e', 'acf', 'not_imported', 0, 1731912307, 'plugin', 'advanced-custom-fields-pro/acf.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/updraftplus/languages/updraftplus-ar.mo', '82dfecbe85ff9ce93c6a7619d418af0f', 'updraftplus', 'not_imported', 0, 1732344873, 'plugin', 'updraftplus/updraftplus.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/plugins/sitepress-multilingual-cms/locale/wpml-translation-management-ar.mo', 'c7b88e8561418b298fb021ed8b2657aa', 'wpml-translation-management', 'not_imported', 0, 1734345902, 'plugin', 'sitepress-multilingual-cms/sitepress.php' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist
[16-Dec-2024 10:45:17 UTC] WordPress database error Table 'dubaigamin_f6775f34ec0a39ea4501b3c5_database.wp_icl_mo_files_domains' doesn't exist for query INSERT IGNORE INTO wp_icl_mo_files_domains ( file_path, file_path_md5, domain, status, num_of_strings, last_modified, component_type, component_id ) VALUES ( 'wp-content/languages/admin-ar.mo', '8561c993122e01db02cf002d0dd10971', 'default', 'not_imported', 0, 1733896608, 'other', '' ) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_ST_Translations_File_Dictionary_Storage_Table->persist

curl-img.png
December 16, 2024 at 2:00 pm #16517661

Bruno Kos
Supporter

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+01:00)

Can you please try the following:

1. Check your database to see if the relevant `icl_` tables are present. If they are missing, proceed with the steps below.

2. If the WPML setup wizard completed but you can access its troubleshooting section, follow the instructions here to reset WPML:
[WPML Reset Instructions](https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/#step-3-do-the-wpml-reset).
Complete the reset and re-run the setup wizard.

3. If the reset doesn't resolve the issue, manually remove `icl_` entries from the `wp_options` table in your database and then re-run the WPML setup wizard.

4. If the `icl_` tables are still not created after these steps, verify that your database user has the necessary permissions to create tables.

Let us know the results after trying these steps.

icl.jpg
icl2.jpg
December 18, 2024 at 7:33 am #16524360

gurshinderS-2

Hi

I have check the above in database. I have removed all icl entries from wp_options table and redid the process . Only WP options shows values but only wp_icl_background_task table gets created. None of the other tables get created.

rest connectivity with the database in terms of other actions are happening. Only WPML is unable to create tables.

Kindly let me know what other steps should i take in order to fix the issue

Best

December 18, 2024 at 12:52 pm #16526041

Bruno Kos
Supporter

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+01:00)

Can you do this? So delete everything again and try the WPML wizard while having the below active:

1. **Collect Logs**:
- Enable debugging in `wp-config.php`:

 define('WP_DEBUG', true);
     define('WP_DEBUG_LOG', true);
     define('WP_DEBUG_DISPLAY', false);

- Check the `wp-content/debug.log` for WPML-related errors.
- Review PHP and MySQL logs for SQL or permission errors.

2. **Test Database Privileges**:
- Run these SQL commands to confirm permissions:

  CREATE TABLE test_table (id INT AUTO_INCREMENT PRIMARY KEY);
     DROP TABLE test_table;

- Ensure the database user has `CREATE`, `ALTER`, `INSERT`, and `DELETE` privileges.

3. **Enable Database Query Logging**:
- Enable query logging in MySQL:

  SET GLOBAL general_log = 'ON';

- Review the query log for errors or failed WPML-related SQL commands.

Let me know if the above brings some info.

December 22, 2024 at 3:03 pm #16537875

gurshinderS-2

Hi, i will revert back after testing the same tomorrow.

December 23, 2024 at 7:35 am #16539394

Bruno Kos
Supporter

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+01:00)

Ok, let me know if these logs return something.