Bulk copy products to different language

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: America/Los_Angeles (GMT-07:00)

Tagged: Known issue

This topic contains 16 replies, has 4 voices.

Last updated by Bobby 1 year, 3 months ago.

Assisted by: Bobby.

Author	Posts
April 19, 2024 at 8:19 am #15542213
artjanv	HI Bobby, We have done all these actions and also the WPML Woocommerce actions. Stil this error: Got error 'PHP message: WordPress database error Duplicate entry '3429-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `trid` = '3429', `language_code` = 'en', `source_language_code` = 'nl' WHERE `element_type` = 'post_product' AND `element_id` = '151343' made by do_action('wp_ajax_make_duplicates'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Meta_Boxes_Post_Edit_Ajax->duplicate_post, TranslationManagement->make_duplicates, TranslationManagement->make_duplicate, SitePress->make_duplicate, WPML_Post_Duplication->make_duplicate, WPML_Post_Duplication->run_wpml_actions, SitePress->set_element_language_details, WPML_Set_Language->set, WPML_Set_Language->change_translation_of', referer: hidden link Anu suggestion? Maybe SQL query?
April 19, 2024 at 6:40 pm #15544892
Bobby WPML Supporter since 04/2015 Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Thank you for updating me! After some discussion with our team, this is a known issue that we are working on resolving. See more information about it here: https://wpml.org/errata/wordpress-database-error-duplicate-entry/ While we do not officially recommend this as a workaround, If you are comfortable working with SQL queries, please consider using the following query provided by another user here: https://wpml.org/forums/topic/duplicate-entry-2028-en-for-key-trid_lang/page/2/#post-8232421 NOTE: Always have a recent and working backup before making any changes recommended by our team or a 3rd party

The topic ‘[Closed] Bulk copy products to different language’ is closed to new replies.