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.

This topic contains 28 replies, has 3 voices.

Last updated by Sumit 1 year, 10 months ago.

Assisted by: Sumit.

Author Posts
January 2, 2023 at 11:22 am #12739337

kristoferS-2

After the new year our sites lost connection with our pay-as-you go subscription for automatic translation, though they were visible here on wpml.org.

After reentering payment information I tried updating an original page and the AJAX POST to the page would timeout after 2 minutes. No issues when manually updating a translation (not using ATE).

If I deactivate all WPML plugins there is no timeout.

Activating the WPML plugins will also timeout, though they seem to be activated in the end. No such issues with other plugins.

My translation memory also seems to be out of sync. The left hand side shows an older version of the original and when I save the translation the not matching paragraphs will be copied instead of translated.

I have edited manually as needed for now but I am very conserned about the reliablility of the system.

January 2, 2023 at 2:42 pm #12740329

Faisal Ahammad

Hello,
Apologies for the inconvenience. I have identified that the max_execution_time is set to 90, and the max_input_vars is set to 3000. Could you please increase the max_execution_time to 300 and the max_input_vars to 10000 and then recheck the issue?

If that does not resolve the issue, could you please open your browser console and check if there are any errors when AJAX requests time out? To help us better understand the issue, it would be greatly appreciated if you could attach some screenshots.

Thank you for your assistance.

January 2, 2023 at 4:06 pm #12740855

kristoferS-2

I have changed my PHP settings as you requested. The AJAX POST to /sv/wp-json/wp/v2/pages/7719?_locale=user fails with status code 524. No information in the response body.

January 3, 2023 at 10:28 am #12744117

Faisal Ahammad

Hello,
Apologies for the inconvenience. I did not encounter any issues accessing the URL hidden link. It returned the data successfully with a 200 status code.

Could you provide me with your WordPress login credentials so I can further investigate the issue? I’m enabling a private message for the following 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 backup the site files and database before providing us access.
- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.

Thank you

json_request.png
January 3, 2023 at 4:00 pm #12746237

Faisal Ahammad

Hi,
Sorry for the trouble! It looks like you haven’t set up the root page when using the "Use directory for default language" option. You have a few options here: you can set up a custom .html file, create a new page, or use your existing page. For step-by-step instructions, please refer to the following links:

1. Language URL format options: https://wpml.org/documentation/getting-started-guide/language-setup/language-url-options/

2. Language Directory for the Default Language: https://wpml.org/documentation/getting-started-guide/language-setup/directory-default-language/

Once you have set up your root page, please recheck the issue. If you still experience an AJAX timeout error, please let us know.

Thank you for your patience and understanding.

January 4, 2023 at 9:18 am #12749873

kristoferS-2

I tried creating a root page. Now it does not timeout, instead I get status 500. I checked the error_log file and found this:

[02-Jan-2023 16:06:11 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->update_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Media_Attachments_Duplication->save_post_actions, WPML_Media_Attachments_Duplication->sync_attachments, WPML_Media_Attachments_Duplication->duplicate_post_attachments, WPML_Media_Attachments_Duplication->create_duplicate_attachment_not_static, WPML_Media_Attachments_Duplication->create_duplicate_attachment, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_status

Thought something might be wrong the the translation relationship so I disconnected the English translation. Then saving the Swedish original did work without issues. After reconnecting it fails the same way again.

January 4, 2023 at 3:12 pm #12752187

Faisal Ahammad

Hi,
I suspect that there is a collision with the theme or another plugin that might cause this problem. If possible, get your site into a minimum environment. A minimum environment means switching to a default WordPress theme like TwentyTwenty-One and no plugins activated except WPML.

First, you will need to check if the problem persists when just the theme is switched to TwentyTwenty-One. If it persists, then deactivate all plugins except the WPML, its add-ons, and WooCommerce itself (without its extensions). Then please check if the problem persists. If it does not persist, start by activating the plugins one by one and check when the problem comes back, then report to me which was the culprit plugin.

⚠️ Important! Please make a full site backup (files and DB) before you proceed with those steps. ⚠️
** If your site is live, you might want to try those procedures in a staging environment or a snapshot of your site on your local server or another server. **

Let me know how that goes! Thank you

January 4, 2023 at 3:24 pm #12752297

kristoferS-2

I disabled all plugins except WPML and changed theme to TwentyTwenty and it still will not save.

January 5, 2023 at 5:15 pm #12760471

Faisal Ahammad

Hello,
We apologize for the inconvenience. After deactivating and reactivating WPML’s all plugins, the error no longer appears in the error_log file, and your posts and pages are now saving the updates. I have tested it multiple times and have not encountered any issues. Here is the screenshot:
hidden link

However, you may still be experiencing a fatal error due to your low max_execution_time limit. I suggest increasing it from 90 to 300 to resolve the issue.

Could you test this now and let us know how it goes?

Thank you for your time and patience.

January 9, 2023 at 9:09 am #12774431

kristoferS-2

I tested again.

Reactivating WPML plugins did not timeout.

Updating the page /wp-admin/post.php?post=7719&action=edit still does not work, even though I encreased max_execution_time to 300.

This was written repeatedly in error_log:
[09-Jan-2023 09:07:51 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->update_item, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Media_Attachments_Duplication->save_post_actions, WPML_Media_Attachments_Duplication->sync_attachments, WPML_Media_Attachments_Duplication->duplicate_post_attachments, WPML_Media_Attachments_Duplication->create_duplicate_attachment_not_static, WPML_Media_Attachments_Duplication->create_duplicate_attachment, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_status

January 9, 2023 at 3:37 pm #12778637

kristoferS-2

Hi Faisal,

I have completed the Cloudways migration with the credentials you specified. I logged in to the Cloudways site and tested updating the page and the issue seems reproducible in this environment as well.

January 10, 2023 at 4:37 pm #12787087

kristoferS-2

Any update?

January 10, 2023 at 5:30 pm #12787701

Faisal Ahammad

Hello,
Apologies for the delay. I have tested multiple times and spent several hours investigating your issue, but I have not been able to find a solution.

I have escalated your issue to our second-tier support team and will provide you with an update as soon as I hear back from them.

Thank you for your patience.

January 17, 2023 at 7:25 am #12831235

kristoferS-2

Any update? Have they managed to find the cause of the issue?

January 18, 2023 at 5:47 pm #12845483

Faisal Ahammad

Hello,
I am still awaiting a response from our second-tier support team regarding this issue, and I will update you as soon as I have received it.

I appreciate your patience.