Problem: If you're unable to access the Advanced Translation Editor (ATE) on your site, and clicking the icon to edit/create translations redirects you to the transaction dashboard, with an error message 'the translator could not be assigned to the job' appearing briefly, the issue might be related to database privileges and missing database columns. Solution: First, check your debug log file for any explicit denial of CREATE privileges in your database. This issue is indicated by an error from MySQL, not WordPress or WPML. If you find a line similar to
Commande CREATE refusée à l'utilisateur " username "@" host "
, it means the database user does not have the necessary CREATE privilege. To resolve this, execute the following SQL query to restore the correct privileges:
GRANT CREATE, ALTER, INDEX, DROP ON `your-database-name`.* TO 'your-database-user'@'%';
Next, ensure that all required columns are present in your database tables. Due to the privilege issue, some columns necessary for the latest WPML version might not have been created. Run the following SQL query to add the missing columns, making sure to replace 'wp_' with your site's table prefix if it differs:
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 these steps do not resolve your issue or if the solution seems outdated or irrelevant to your case, we highly recommend checking 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. If problems persist, please open a new support ticket.
