Not a bug

Symptoms

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

2 Responses to “WP All Import issues when option “Increase speed by disabling do_action calls in wp_insert_post during import” is enabled”

  1. 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_

Leave a Reply

Please leave here comments about this page only.
For technical support and feature suggestions, head to our forum. We are waiting there!

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>