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.
Background of the issue:
I have WooCommerce and after the last WPML update, I can't translate manually. When I go to 'Products,' I see language flags and a '+' for each language. When I click '+' next to a given translation, it takes me to the 'translation queue' page. When I click 'accept and translate,' I get an error. The same issue occurs when I go to 'translations' from the menu and manually select a translator.
Symptoms:
Error: 'The translator could not be assigned to the job.' Instead of opening the edit page, it takes me to the 'translation queue' page. The translator receives the message: 'The translator could not be assigned to the job.'
Questions:
Why can't I translate manually after the WPML update?
How can I resolve the error 'The translator could not be assigned to the job'?
Kindly make a full backup of your site and let me know once it’s ready so I can begin the process. Please be aware that this step may temporarily affect your site’s performance and could cause minor interruptions.
Rest assured that once the issue is resolved, I will delete the local site and the package.
Yes, please install Duplicator and create a duplicate site for further testing. Please note that the site has a large number of photos, and the entire photos backup may contain approximately 20 GB of data.
Thanks for your reply. Duplicator plugin is not working so I made a backup using the All in one backup plugin. Could you upload this file to Google Drive hidden link and share with me?
Thanks for your patience. I'm able to replicate it with only WPML plugins activated. Please allow me to escalate this further to our 2nd Tier Support for further investigation. I will come back to you once I've feedback.
Thank you for your efforts so far. I know you must have a lot of work to do, but we are also very keen to solve this problem because it prevents us from working normally. Do you have a solution for us?
Thanks for your reply. I have some feedback, and this is what our 2nd Tier Support mentioned.
WordPress database error CREATE command denied to user 'web'@'localhost' for table
Looks like a database permissions issue, can you confirm with the hosting provider if the mentioned user has enough privileges to create table on the database?
Once this is fixed, resend the jobs for translations and see if it helps.
Adding "create" permissions for the "web" user is dangerous.
We have a dedicated server, and even though such permissions are dangerous, we added them—even though they didn't exist before, and everything worked (after a WPML update, it stopped working).
After adding these permissions, I still get the same error. Please fix this bug.
