We found a bug 11 months ago with media duplication and not deleted properly with WPML All import. The ticket issued to cover the situation is: WPML All Import does not remove old media when overriding the images on import
I just need to know if that is still the appropriate solution for the problem or the bug is finally fixed in latest releases.
We have been having a weird error when running the import process and i suspect the solution is no longer working:
WPML_Media_Attachments_Duplication
[Fri Mar 10 08:48:14.270798 2023] [proxy_fcgi:error] [pid 20664:tid 140355804518144] [client 89.46.89.142:55744] AH01071: Got error 'e error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_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, Wpai\\Scheduling\\Import->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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by require_once('w
i dont think that the custom code you gave me is the issue. i changed the file back to its original content and the issue persists. this is a very important issue since i cannot run my importation process and thus my products are displaying no images. i have tried importing a single product too with only text fields with the same result. This seems to be the main error that is blocking the importation:
Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL)
Got error 'e error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL)
I also understand that you're using the latest versions of the plugin, but we want to take a look at the debug information, and they can help us know better about your installation.
The problem is far more severe than the workaround not working: i cannot run any importation process.
This is causing my website to not display the correct information. When running the importation (with or without the setting for updating images) the process gets stuck and i am not even able to import 1 single product. the concrete error that seems to be causing this is:
Got error 'e error Column 'translation_id' cannot be null for query INSERT INTO `j6J2dIQ_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL)
As already pointed out by Ahmed.
At this point i do not care about the images getting duplicated in the import process but the fact i cannot run any import process whatsoever. I need to please be able to run the import, even if the images get duplicated
I would like to request temporary access (wp-admin and FTP) to your site to test the issue.
(preferably to a test site where the problem has been replicated if possible)
**Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken **
I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/
You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you enter is private which means only you and I have access to it.
NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin.
Hi Bobby, I am trying to upload the XML and all the configuration to the testing environment you provided but i am getting a problem with the pro version of the plugin, could you please install it?
"Upgrade to the Pro edition of WP All Import to use the Function Editor.
If you already own it, remove the free edition and install the Pro edition."
In any case, the issue with the null value in the translation_id, I think is related to a new instance that is trying to be recorded in the database, not that we are quering a value that is null. Checking the database table i do not see any null values for the said column. I think that the import is trying to create a new instance with a null value for translation_id and given the not null restriction the error is being raised. What do you think?
Please try again I have activated the PRO version on the sandbox.
"I think that the import is trying to create a new instance with a null value for translation_id and given the not null restriction the error is being raised. What do you think?"
Yes, I believe that is what is happening. Are you using any custom function/code that would attempt to create a NULL entry to the database during the import?
The reason of testing this on a clean environment is to determine if something is causing this behavior in the import itself meaning that it's import XML fille specific or if it happens due to a bug.
