Problem: The client was unable to upload images to the WordPress media library, receiving an error message about server capacity and a PHP Fatal error related to WPML translations. The issue was suspected to be due to a corrupted 'wp_icl_translations' database table. Solution: 1. Backup the site completely. 2. Execute the following SQL commands to repair the database:
DELETE FROM `wp_icl_translations` WHERE `translation_id` = '0';
ALTER TABLE `wp_icl_translations` CHANGE `translation_id` `translation_id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `wp_icl_translations` ADD UNIQUE `trid_lang` (`trid`, `language_code`), ADD UNIQUE `el_type_id` (`element_type`, `element_id`), ADD INDEX `trid` (`trid`), ADD INDEX `id_type_language` (`element_id`, `element_type`, `language_code`);
3. Navigate to WPML -> Support -> Troubleshooting and click the 'Set language information' button. After these steps, the image upload issue should be resolved. If other database issues arise, further investigation may be necessary.
If this solution does not apply to your case, or if it seems outdated, we recommend opening a new support ticket. We also advise 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. For further assistance, please visit our support forum at WPML Support Forum.
