Problem: If you're experiencing database errors indicating a missing 'review_status' column or a non-existent 'wp_icl_background_task' table in your WPML plugin, it might be due to recent changes or migrations in your site. Solution: First, we recommend checking if the 'review_status' column exists in your 'wp_icl_translation_status' table. You can do this by logging into your database using a tool like PHPMyAdmin. If the column is missing, please ensure you have backed up your site, then run the following SQL queries to add the missing columns:
ALTER TABLE `wp_icl_translation_status` ADD COLUMN `review_status` enum('NEEDS_REVIEW','EDITING','ACCEPTED') COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE `wp_icl_translation_status` ADD COLUMN `ate_comm_retry_count` int UNSIGNED DEFAULT '0';
After applying these changes, verify if the issue persists.
Please note that this solution might be outdated or not applicable to your specific 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 the problem continues, please open a new support ticket.
Problem: After upgrading the WPML plugin, an error appeared in the PHP error log indicating that the table 'cordmagazine.wp_icl_background_task' does not exist. Solution: If you're experiencing this issue, we recommend you first log into your database to check if the wp_icl_background_task table exists. If it doesn't, please perform a full site backup before proceeding. After ensuring your site is backed up, you can try to resolve the issue by running the following SQL query in your database management tool like PHPMyAdmin:
DROP TABLE IF EXISTS `wp_icl_background_task`;
CREATE TABLE IF NOT EXISTS `wp_icl_background_task` (
`task_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
`task_type` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
`task_status` smallint UNSIGNED NOT NULL DEFAULT '0',
`starting_date` datetime DEFAULT NULL,
`total_count` int UNSIGNED NOT NULL DEFAULT '0',
`completed_count` int UNSIGNED NOT NULL DEFAULT '0',
`completed_ids` text COLLATE utf8mb4_unicode_ci,
`payload` text COLLATE utf8mb4_unicode_ci,
`retry_count` smallint UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`task_id`)
)
This solution might be outdated or not applicable 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 the problem persists, please open a new support ticket at WPML support forum.
