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.