This thread is resolved. Here is a description of the problem and solution.
Problem: After a recent WPML update, you are unable to manually translate products in WooCommerce. When attempting to translate, you encounter an error stating 'The translator could not be assigned to the job,' and you are redirected to the 'translation queue' page instead of the product edit page. Solution: This issue is due to missing fields in the database table wp_icl_translate_job. To resolve this, please ensure you back up your entire server first for safety. Then, run the following database query to add the necessary fields:
ALTER TABLE `wp_icl_translate_job`
ADD `wpml_words_to_translate_count` int unsigned NULL,
ADD `wpml_automatic_translation_costs` int unsigned NULL AFTER `wpml_words_to_translate_count`;
If this solution does not apply to your case, or if it seems outdated, we highly recommend checking for related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. Should the problem persist, please do not hesitate to open a new support ticket with us for further assistance.
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.
To fix this, please back up the entire server and run the database query below
ALTER TABLE `wp_icl_translate_job`
ADD `wpml_words_to_translate_count` int unsigned NULL,
ADD `wpml_automatic_translation_costs` int unsigned NULL AFTER `wpml_words_to_translate_count`;
Dear Kor, we added those two columns to the table (own different table prefix) but we have still the same error.
Did second-tier support try this and see if it worked for them? Or are they just guessing?
You have copies of everything (database, files), so let second-tier support test whatever they come up with. Let them first check if it works. It looks like they came up with something and didn't test it. It's frustrating.
Thanks for your reply. They have tested it on a local dev site. If you've applied to this Website hidden link and the issue persists, please backup the entire site and share database access(phpmyadmin) and I will forward this to our 2nd Tier Support for a second look.
Sorry for last message, but we've applied your solution to a table with a different prefix (different WordPress instance in the same DB). Now Everything IS WORKING 🙂
Thank you for your support, and thanks to the entire support team for trouble solving.
PS.
Probably in last update your developers added two new columns to the table, but my user "web" didn't have "Alter" permission at that time. Even though we added "Alter," the columns didn't exist before. Now are two columns and it's OK.
