Problem: The client is experiencing fatal errors when trying to access the Translation Management section in WPML, due to missing 'batch_id' column and incorrect data type for 'translation_package' column in the 'wp_icl_translation_status' table. Solution: First, add the missing 'batch_id' column by executing the following SQL command:
ALTER TABLE wp_icl_translation_status ADD COLUMN batch_id INT NOT NULL DEFAULT 0;
Next, change the data type of the 'translation_package' column to 'longtext' to prevent data corruption. Run this SQL command:
ALTER TABLE wp_rascg4p5t7_icl_translation_status CHANGE translation_package translation_package LONGTEXT COLLATE 'utf8mb4_unicode_ci' NOT NULL AFTER translation_service;
After updating the database, follow these steps to clean up and resend the affected translation: 1. Identify the original post ID. 2. In the 'icl_translations' table, locate the 'trid' for that post ID. 3. Use the 'trid' to filter records in the same table and remove any rows where the 'element_id' column is 'NULL'. 4. Go to WPML > Packages in the WordPress admin and delete the package with the identified ID. 5. Resend the content for translation as usual, following the instructions here: Translating Your Contents.
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 at WPML Support Forum.
