Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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 thread is resolved. Here is a description of the problem and solution.

Problem:

504 gateway timeout for a sub-site in a multisite installation where WPML is installed

Solution:

It was not clear what caused this issue and if WPML is the reason for it.

The user wrote:

I actually had to delete the entire "ch" website, and start from scratch... which is not the best solution, but luckily I did not have so much content....

Tagged: 

This topic contains 25 replies, has 2 voices.

Last updated by Itamar 1 month, 3 weeks ago.

Assigned support staff: Itamar.

Author Posts
November 12, 2019 at 4:56 pm #4933649

robertoM-8

I have a multisite intallation

WPML is Network Activated
WPML is active on the main (id=1) and two subsites. Few more subsites do not have WPML activated

On subsite 1, everything works perfectly
On subsite 2, i get locked out of the wp-admin by 504 gateway timeout.

This message

WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.
Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem.

This warning will disappear once this issue is fixed.

keeps appearing but there is no

Clear language information and repopulate languages

anywhere to be clicked on the troubleshooting page.

Please assist. My subsite is completely unusable.

November 13, 2019 at 2:32 pm #4940193

Itamar
Supporter

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

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

Hi.

Can you please share with me the debug information of the site and the access details so I can check the issue?

Could you please share your Debug information with me?
You can read a detailed explanation about it here.
http://wpml.org/faq/provide-debug-information-faster-support
The debug info will give me a lot of information about how your site is configured and will help me understand the source of the problem.

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.

November 14, 2019 at 5:46 pm #4949303

robertoM-8

Do you have any update for me?

November 14, 2019 at 5:59 pm #4949365

Itamar
Supporter

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

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

Hi, and thanks for the access details.

I can see the 504 problem on your subsite here hidden link
I can also see the error in the debug log. Currently, I'm consulting our second tier supporters about this issue. But you also mentioned that this message is appearing.

WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.
Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem.
 
This warning will disappear once this issue is fixed.

I couldn't find where it is appearing. Can you please tell me that?

In Network Admin -> WPML I've deactivated WPML for the 'ch' site. Please see the attached screenshot. But the site is still 504. So I'm not 100% sure that WPML causes the issue. I'm waiting for our second-tier supporter reply and comment here.

Do you have the possibility to temporarily deactivate WPML for the network and see if it makes any difference for the subsite with the 504 problems?

Thanks,
Itamar.

November 18, 2019 at 6:53 am #4962125

robertoM-8

I did deactivate it on all the network, but it's still on a 504 bad gateway.
Did your support team find out something?

November 18, 2019 at 9:27 am #4963375

robertoM-8

I can tell you that the problematic subsite had a default language WHICH WAS CHANGED just before it stopped working

This might have occurred in some problems in WPML tables?

Thanks

November 18, 2019 at 12:42 pm #4965093

Itamar
Supporter

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

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

Hi.

Our second tier supporter suggests that the procedure on the following errata be implemented to recover those _icl_strings tables.
https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/
Could you please perform this procedure?

**** Important! Please make a full site backup (files and DB) before you proceed with those steps****

This should recreate the missing tables on the sub-site.
Please let me know if it is working for you, or if you have any questions.

Thanks,
Itamar.

November 18, 2019 at 1:48 pm #4965575

robertoM-8

I performed it as you said

Still, on the other (working) subsite with WPML active i get the notice

WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.
Please go to the Troubleshooting page and click on "Clear language information and repopulate languages" to fix this problem.

This warning will disappear once this issue is fixed.

link:

<em><u>hidden link</u></em>

on hidden link i still get the 504

November 19, 2019 at 4:17 pm #4974207

robertoM-8

Do you have any idea about how to solve my problem? The subsite is unaccessible, and AT LEAST i wish to extract the pages data from the table/DB in order to dump the subsite and recreate it, but as of now i'm totally blocked (and the subsite is offline)

Thanks

November 19, 2019 at 5:00 pm #4974527

Itamar
Supporter

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

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

Hi, and thanks for trying my suggestions.

I can see the message in the admin of hidden link. I don't think that it is a critical message. It might be an issue of a stuck message. Let's first, please focus on the hidden link issue.

Could you please proceed with the following?

1. Take a backup of the DB of your site.

2. Access the DB interface of your site (usually with PHPMyAdmin.)

3. Now to SQL queries need to be executed.

4. For the wp_icl_strings table run this SQL.

CREATE TABLE IF NOT EXISTS `wp_icl_strings` (
  `id` bigint(20) unsigned NOT NULL,
  `language` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `context` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `string_package_id` bigint(20) unsigned DEFAULT NULL,
  `location` bigint(20) unsigned DEFAULT NULL,
  `wrap_tag` varchar(16) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'LINE',
  `title` varchar(160) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `gettext_context` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `domain_name_context_md5` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `translation_priority` varchar(160) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `word_count` int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=14311 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

In the SQL you need to change the wp_ prefix to the prefix of the hidden link tables. This might be something like wp_2_

5. For the wp_icl_string_translations table run this SQL.

CREATE TABLE IF NOT EXISTS `wp_icl_string_translations` (
  `id` bigint(20) unsigned NOT NULL,
  `string_id` bigint(20) unsigned NOT NULL,
  `language` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` tinyint(4) NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_520_ci,
  `mo_string` longtext COLLATE utf8mb4_unicode_520_ci,
  `translator_id` bigint(20) unsigned DEFAULT NULL,
  `translation_service` varchar(16) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `batch_id` int(11) NOT NULL DEFAULT '0',
  `translation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

In the SQL you need to change the wp_ prefix to the prefix of the hidden link tables. This might be something like wp_2_

Now please check if the two tables were created and if the 504 error is gone.

If you need help from me to perform this procedure, then please approve that you have a full site backup and allow me to proceed with the above steps. Please also approve that I can install the Adminer (hidden link) script so I can have access to the DB of your site.

**** Important! Please make a full site backup (files and DB) before you proceed with those steps****

Thanks,
Itamar.

November 19, 2019 at 5:27 pm #4974745

robertoM-8

Hi.

The tables are already present. Therefore running the two queries, no table gets updated or created.

Should i DELETE the two original tables?

November 19, 2019 at 5:47 pm #4974923

robertoM-8

Hi.

I moved (renamed) the two tables, and created 2 tables with your script.
Still same error, nothing changes. I will roll back now

November 20, 2019 at 4:09 pm #4982049

robertoM-8

i am still stuck. any ideas? 🙁

November 20, 2019 at 6:39 pm #4983345

Itamar
Supporter

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

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

Hi.

We need a copy of your site to continue debugging this issue. For this, I've created you a test server on our server. The migration process is quite easy. Please find all the details at the next private message.

Regards,
Itamar.

November 21, 2019 at 7:39 am #4985629

robertoM-8

Done!