When I try to import products with wpallimport, I am getting the following error and the whole import proccess is stuck.
AH01071: Got error 'PHP message: PHP Notice: Trying to get property 'status_id' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 163PHP message: PHP Notice: Trying to get property 'transid' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 173PHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_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, 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, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, WPML_Post_Status->set_statusPHP message: PHP Notice: Trying to get property 'status_id' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 163PHP message: PHP Notice: Trying to get property 'transid' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 173PHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_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, PMWI_Import_Record->import, wpai_woocommerce_add_on\\XmlImportWooCommerceProduct->import, wpai_woocommerce_add_on\\importer\\ProductsImporter->import, wpai_woocommerce_add_on\\importer\\products\\ImportVariableProduct->import, wpai_woocommerce_add_on\\importer\\products\\ImportVariableProduct->importParentProduct, wpai_woocommerce_add_on\\importer\\products\\ImportVariableProduct->initParentProduct, 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_attachme...PHP message: PHP Notice: Trying to get property 'status_id' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 163PHP message: PHP Notice: Trying to get property 'transid' of non-object in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 173PHP message: WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_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, PMWI_Import_Record->import, wpai_woocommerce_add_on\\XmlImportWooCommerceProduct->import, wpai_woocommerce_add_on\\importer\\ProductsImporter->import, wpai_woocommerce_add_on\\importer\\products\\ImportVariableProduct->import, wpai_woocommerce_add_on\\importer\\products\\ImportVariableProduct->importVariations, wpai_woocommerce_add_on\\importer\\products\\ImportProduct->save, WC_Product->save, WC_Data_Store->update, WC_Product_Variation_Data_Store_CPT->update, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Media_Attachments_Duplication->save_p...PHP message: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/class-wpdb.php on line 2425'
I searched our forum and internal reports and the only instance I saw was a case in which the problem was caused by a custom code added in the Child Theme of the customer.
So for now I'd appreciate it if you could test the import process in a copy/staging website as a test with the criteria below:
- Change the website theme to 2020 or a default theme.
- Deactivate all plugins except, WPML, Woocommerce, WP All Import (and their necessary add-on plugins to make sure everything works)
- Perform the process again.
- See if the result is ok.
- If yes, then please enable the Child theme and test, if it is ok then plugins one by one, to find the culprit.
I have already check that but same error. If I change the php version to 8.0.3, I get this error:
AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Exception: No trid for product variation in secondary language, imposssible to set _wcml_duplicate_of_variation in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/wpml-all-import/wpml-all-import.php:325\nStack trace:\n#0 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/class-wp-hook.php(312): WPAI_WPML->saved_post()\n#1 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters()\n#2 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action()\n#3 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/wp-all-import-pro/models/import/record.php(4725): do_action()\n#4 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/wp-all-import-pro/controllers/admin/import.php(2799): PMXI_Import_Record->process()\n#5 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/wp-all-import-pro/wp-all-import-pro.php(763): PMXI_Admin_I...', referer: hidden link
Could you help us?
Do you need admin credentials ?
The "_wcml_duplicate_of_variation" portion of the error gave me an idea, please make sure that the attributes of the products are already translated from Woocommerce > Woocommerce > Multilingual & Multicurrency > Attributes (tab).
After that, please do the import but make sure you set the option mentioned below correctly:
In Step 3, expand the Configure Advanced Settings section and disable the option to increase the speed of the import process. You can do this by unchecking the box next to Increase speed by disabling do_action calls in wp_insert_post during import.
I am having the following error in the end of wpallimport process:
AH01071: Got error 'PHP message: PHP Fatal error: Uncaught TypeError: call_user_func_array(): Argument #1 ($callback) must be a valid callback, class WCML_Synchronize_Product_Data does not have a method "delete_empty_post_meta_for_translations" in /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/class-wp-hook.php:312\nStack trace:\n#0 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters()\n#1 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action()\n#2 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/meta.php(528): do_action()\n#3 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-includes/post.php(2496): delete_metadata()\n#4 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-variable-data-store-cpt.php(602): delete_post_meta()\n#5 /var/www/vhosts/b2b.catherinebijoux.com/httpdocs/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(2...'
Would you please use the workaround there and see if the message goes away?
Thanks.
The topic ‘[Closed] Wpml + Wpallimport Problem’ is closed to new replies.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
