Sync fails - Synchronize posts taxonomies for woocommerce products

This thread is resolved. Here is a description of the problem and solution.

Problem:
You are trying to synchronize posts taxonomies for WooCommerce products after automatic translation and encountering a 'Maximum execution time of 600 seconds exceeded' error. This issue escalates as the number of products increases.
Solution:
We recommend following these steps to identify and resolve the issue:
1. Create a full backup of your site or set up a staging site.
2. Update any outdated plugins or themes.
3. Clear any existing cache.
4. Deactivate all plugins, including WPML ones, and switch to a default WordPress theme like Twenty Twenty.
5. Downgrade your PHP version to 8.2 or 8.1, as not all plugins are compatible with PHP 8.3.
6. Reactivate the WPML plugins, WooCommerce, and WooCommerce Multilingual & Multicurrency.
7. Run the synchronization process again.
8. If the issue is resolved, reactivate your theme and other plugins one by one to identify the problematic plugin.

If these steps do not resolve the issue or if the solution seems outdated or irrelevant to your case, please visit our support forum to open a new ticket. We also highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins.

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.

Tagged: Exception

This topic contains 2 replies, has 1 voice.

Last updated by Carlos Rojas 2 months, 4 weeks ago.

Assisted by: Carlos Rojas.

Author	Posts
November 14, 2024 at 9:05 am #16401289
jozefC-3 Site owner	Background of the issue: I am trying to synchronize posts taxonomies for WooCommerce products after automatic translation. Problems began to appear as the number of products grew. Link to a page where the issue can be seen: hidden link Symptoms: Synchronization fails with the error 'Maximum execution time of 600 seconds exceeded' in the error log. Questions: Could you help to prevent the synchronization from failing? Any tip to process the synchronization in several parts?
November 15, 2024 at 9:58 am #16407029
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hello, Thank you for contacting us To rule out possible causes I would like to ask you to follow these steps: - Create a full backup of the site or create a staging site with a copy of the live site and run the tests there - Update any outdated plugins or themes - Flush any cache memory that might exist - Deactivate all plugins, including the WPML ones - Activate a default WordPress theme, like Twenty Twenty - Downgrade the PHP version to 8.2 or 8.1 because not all WordPress plugins are compatible with PHP 8.3 - Activate the WPML plugins, Woocommerce and Woocommerce Multilingual & Multicurrency - Run the sync - If the issue disappeared, start by activating the theme and then the rest of the plugins, one by one, until the issue appears again and you find the culprit\ Could you tell me the results of the steps described above? Regards, Carlos
November 22, 2024 at 8:44 am #16432428
jozefC-3 Site owner	This error appears multiple times in the debug log, just with different "VALUES" [22-Nov-2024 08:30:18 UTC] WordPress database error Result consisted of more than one row for query INSERT INTO `adtb_term_relationships` (`object_id`, `term_taxonomy_id`) VALUES (11854, 3736) made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, wpml_troubleshoot_action_load, WPML_Troubleshoot_Sync_Posts_Taxonomies->run, WPML_Troubleshoot_Sync_Posts_Taxonomies->synchronize_batch, WPML_Term_Translation_Utils->sync_terms, WPML_Term_Translation_Utils->synchronize_terms, wp_set_object_terms Is there any way I can enable this synchronization for products via WP CLI?
November 22, 2024 at 10:29 am #16433209
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Buenos dias, Muchas gracias por su respuesta. Me gustaría revisar la configuración de WPML en el sitio. Le pido que comparta las credenciales de acceso al sitio en su próximo mensaje que he establecido como privado. Por favor no olvide crear una copia de seguridad del sitio completo antes de compartir las credenciales. Como alternativa, puede crear un sitio staging con una copia del sitio en producción y compartir las credenciales de dicho sitio para poder realizar pruebas sin afectar al sitio publicado. Quedo a la espera de su mensaje.
November 22, 2024 at 12:10 pm #16433700
Carlos Rojas Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Madrid (GMT+01:00)	Hi there, Thank you for sharing the credentials requested. And I'm sorry for answering in Spanish, it was an honest mistake 🙂 Before continuing, I kindly ask you to update all outdated functionalities in this link: hidden link and double-check if the issue disappeared.