Resolved
Overview of the issue
If you have the option: “Increase speed by disabling do_action calls in wp_insert_post during import” enabled when doing an import with WP All Import, you might have issues with how the posts are imported and that can lead to a number of problems with WPML and potentially other related plugins too.
That option is created for increasing the speed, however, when inserting new post, WPML is doing some magic that makes the post assigned to a certain language.
If that option is enabled, you will not have the content appear in any language and you should run troubleshooting action to set language information afterwards.
This can be especially problematic if you try to insert translations of content as even running afterwards the troubleshooting action will not properly assign the content.
Workaround
We recommend to disable that option when using WPML
I have problems importing a simple table. The first import works fine. When I want to update data with a 2nd import, everything goes slowly. At the latest with the 3rd import nothing works anymore. The following error log file appears:
AH01071: Got error ‘PHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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\nPHP message: WordPress-Datenbank-Fehler Column ‘translation_id’ cannot be null f\xc3\xbcr Abfrage INSERT INTO `wp_icl_translation_status` (`status`, `translation_id`) VALUES (‘9’, NULL) von edit_post, 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_
Sorry about that, but we can not debug and fix issues in comments on errata. Please report that issue in our WPML Support forum here – https://wpml.org/forums/forum/english-support/ so we can help you.