[Escalated to WPML Developers team] 504 timeout when using ACFML and importing fields

Hi,

Can you try this:

1. Edit wp-config.php and insert the following lines (just before /* That's all, stop editing! Happy publishing. */ part)

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

2. Reproduce the issue

3. Locate the debug log in: /wp-content/debug.log

4. Paste the latest lines here. No need to paste the entire log file, just 10 lines or so will do. Please censor any sensitive information.

https://codex.wordpress.org/Debugging_in_WordPress

But more importantly we need this:

- do the above reproducing (so from step 2)
- get the latest server debug logs (you can ask hosting support if unsure how to locate them)

Let us know how it goes or if you need further information!

Regards,
Bruno Kos

I see, can you tell me if there is website available for us to check or only in the localhost? Or if you can provide us with Duplicator package so we could debug this?

I don't see Sync Available inside the group, but I see this:
hidden link

But this import of edited file took several minutes, I paused the recording. I think that in most hosting environments it would hit the timeout.

If I disable ACFML, it goes quickly, this import takes several seconds only.

I can report this issue to our 2nd tier for further checks if this is what you are reporting?

We found that this is most likely related WPML_ACF_Field_Settings::update_existing_subfields function, specifically problematic thing is about OEmbed field (as it's triggering an external request).

Our developers are currently investigating this, but can you try this as a workaround?

in \WPML_ACF_Field_Settings::update_existing_subfields in acfml\classes\class-wpml-acf-field-settings.php

Change the line:

$query          = "SELECT * FROM {$wpdb->postmeta} WHERE meta_key LIKE %s";

to:

$query          = "SELECT `meta_key`,`post_id` FROM {$wpdb->postmeta} WHERE meta_key LIKE %s";

also, after the line:

	$acf_field_object = get_field_object( $custom_field->meta_key, $custom_field->post_id );

change from:

								$acf_field_object = get_field_object( $custom_field->meta_key, $custom_field->post_id );
									if ( $acf_field_object ) { // this is valid ACF field.
										foreach ( $this->tm_setting_index as $setting_index ) {
											$this->maybe_set_new_preference( $setting_index, $custom_field->meta_key, $field['wpml_cf_preferences'] );
										}
										if ( WPML_IGNORE_CUSTOM_FIELD !== (int) $field['wpml_cf_preferences'] ) {
											$this->update_corresponding_system_field_settings( $acf_field_object, $custom_field->meta_key );
										}
									}

to:

								$acf_field_object = get_field_object( $custom_field->meta_key, $custom_field->post_id );
								if ( $acf_field_object["type"] !== "oembed" ) {
									if ( $acf_field_object ) { // this is valid ACF field.
										foreach ( $this->tm_setting_index as $setting_index ) {
											$this->maybe_set_new_preference( $setting_index, $custom_field->meta_key, $field['wpml_cf_preferences'] );
										}
										if ( WPML_IGNORE_CUSTOM_FIELD !== (int) $field['wpml_cf_preferences'] ) {
											$this->update_corresponding_system_field_settings( $acf_field_object, $custom_field->meta_key );
										}
									}
								}

and finally, In the import file change from:

        "acfml_field_group_mode": "translation",

to:

        "acfml_field_group_mode": "advanced",

Let me know if still getting 504.