Sorry for mixing issues, but I can't open new ticket.
In production site of this ticket I faced a new issue. Products imported daily base by cheduled import jobs both in site main language (English) and secondary language (Hungarian). English import finish well, but Hungarian import failing (host server terminate import processes about 80%).
I see following records in error_log:
[01-Nov-2020 09:47:34 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `mns22_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, pmxi_wp_loaded_99, WpaiSchedulingImport->process, PMXI_Import_Record->execute, PMXI_Import_Record->process, 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
Languages: English (English )German (Deutsch )French (Français )
Timezone: Europe/Zagreb (GMT+02:00)
Hi,
Looks correct - can you tell me if you have a staging site perhaps, like testing server with a site copy?
I am wondering whether there is a timeout that happens here, so some restriction set by the host, so perhaps it we test this in a smaller batch, run manually. That may tell us whether this is a restriction related to the length of the operation itself and not an error.
Can you perhaps try that?
Also, any logs from the server that shows some other info perhaps, apart from the message above?