I’m getting a database error due to WPML cms plugin which is slowing the website and corrupting other actions to be completed.. kindly check these attached logs
[15-Aug-2023 02:14:27 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_gk5v32rfj0_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\Media\Translate\Endpoint\TranslateExistingMedia->run, WPML_Media_Attachments_Duplication->batch_translate_media, WPML_Media_Attachments_Duplication->translate_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_status
[15-Aug-2023 02:14:27 UTC] WordPress database error Duplicate entry '27375471-ar' for key 'trid_lang' for query INSERT INTO `wp_gk5v32rfj0_icl_translations` (`element_type`, `language_code`, `source_language_code`, `trid`, `element_id`) VALUES ('post_attachment', 'ar', 'en', '27375471', '5003864') made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\Media\Translate\Endpoint\TranslateExistingMedia->run, WPML_Media_Attachments_Duplication->batch_translate_media, WPML_Media_Attachments_Duplication->translate_attachments, WPML_Media_Attachments_Duplication->create_duplicate_attachment, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, SitePress->set_element_language_details, WPML_Set_Language->set, WPML_Set_Language->insert_new_row
[15-Aug-2023 02:14:27 UTC] PHP Warning: Attempt to read property "status_id" on null in /home/u156430489/domains/strongandsavage.com/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 163
[15-Aug-2023 02:14:27 UTC] PHP Warning: Attempt to read property "transid" on null in /home/u156430489/domains/strongandsavage.com/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 173
[15-Aug-2023 02:14:27 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_gk5v32rfj0_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\Media\Translate\Endpoint\TranslateExistingMedia->run, WPML_Media_Attachments_Duplication->batch_translate_media, WPML_Media_Attachments_Duplication->translate_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_status
[15-Aug-2023 02:14:31 UTC] WordPress database error Duplicate entry '27375487-fr' for key 'trid_lang' for query INSERT INTO `wp_gk5v32rfj0_icl_translations` (`element_type`, `language_code`, `source_language_code`, `trid`, `element_id`) VALUES ('post_attachment', 'fr', 'en', '27375487', '5003962') made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\Media\Translate\Endpoint\TranslateExistingMedia->run, WPML_Media_Attachments_Duplication->batch_translate_media, WPML_Media_Attachments_Duplication->translate_attachments, WPML_Media_Attachments_Duplication->create_duplicate_attachment, WPML_Model_Attachments->duplicate_attachment, WPML_Model_Attachments->add_language_information_to_attachment, SitePress->set_element_language_details, WPML_Set_Language->set, WPML_Set_Language->insert_new_row
[15-Aug-2023 02:14:31 UTC] PHP Warning: Attempt to read property "status_id" on null in /home/u156430489/domains/strongandsavage.com/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 163
[15-Aug-2023 02:14:31 UTC] PHP Warning: Attempt to read property "transid" on null in /home/u156430489/domains/strongandsavage.com/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/post-translation/class-wpml-post-status.php on line 173
[15-Aug-2023 02:14:31 UTC] WordPress database error Column 'translation_id' cannot be null for query INSERT INTO `wp_gk5v32rfj0_icl_translation_status` (`status`, `translation_id`) VALUES ('9', NULL) made by do_action('wp_ajax_wpml_action'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\Ajax\Factory->WPML\Ajax\{closure}, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\Container\Container::execute, WPML\Auryn\Injector->execute, call_user_func_array, WPML\Auryn\Executable->__invoke, ReflectionMethod->invokeArgs, WPML\Media\Translate\Endpoint\TranslateExistingMedia->run, WPML_Media_Attachments_Duplication->batch_translate_media, WPML_Media_Attachments_Duplication->translate_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_status
Hello There,
Thanks for contacting WPML Support. I will try my best to assist you in this matter.
The error log indicates that there is an attempt to insert a null record into the 'translation_id' column of the "_icl_translation_status" table. the "translatio_id" column will not accept any null value and therefore, a database error is happening on your site.
Can you please try the following options in their order and see how it goes, kindly backup your site completely before trying any of these suggestions, or better if you can test it on a staging site where the issue is replicated first.
- Please Go to the WPML-> Support-> Troubleshooting page and click on the buttons mentioned here: hidden link
Check if that solves the issue. If not, please do the following:
- Deactivate all of your plugins except for WPML and its add-ons. If the error goes away, it’s likely that one of your plugins is the cause of the issue.
- Start activating the plugins one at a time and after each activation check if the error comes back. This will help you to pinpoint which plugin is causing the issue.
- If the issue persists even after the plugin conflict test, switch your theme to one of the default WordPress themes (like Twenty Twenty-One). If this fixes the error, the issue might be in your theme. In that case, it will be better to reach out to the theme author or support and discuss further about the issue.
Please let me know how it goes. I will be happy to help if you need further assistance in this matter.
Hello There,
Thank you for your reply. I was trying the first method but it seems that the "remove ghost entries from the translation tables" takes a lot of time to load without executing, should I still proceed and ignore it?
As you didn’t replied I’ve reloaded the page and continued with others, and it seems that the same issue occurred also on “set language information” it still loading
I noticed that you have reached out to us again via chat, and my colleague Lauren has already provided you with all the necessary steps to resolve the issue. Since you are continuing further on the other ticket, I'm marking this thread as resolved. Feel free to reach us if you ever need any assistance. We will be happy to help.
Best Regards,
Prosenjit
This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.
