When try to activate WPML Multilingual CMS 4.9.1. it wont activate and debug.log throws:
[25-Feb-2026 14:42:37 UTC] WordPress database error Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause for query
CREATE TABLE IF NOT EXISTS `wp_icl_translate_unsolvable_jobs` (
`job_id` BIGINT(20) UNSIGNED NOT NULL,
`ate_job_id` BIGINT(20) UNSIGNED NOT NULL,
`error_type` VARCHAR(500) NOT NULL,
`error_message` text NULL,
`error_data` text NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`counter` tinyint(4) NOT NULL,
PRIMARY KEY (`job_id`),
KEY `ate_job_id` (`ate_job_id`)
) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
made by activate_plugin, plugin_sandbox_scrape, include_once('/plugins/sitepress-multilingual-cms/sitepress.php'), load_essential_globals, icl_sitepress_activate, WPML\TM\Upgrade\Commands\CreateUnsolvableJobsTable::create_table_if_not_exists
While waiting for one of my colleagues to take this ticket and help you, could I ask you to check what database version you are using?
The error might be expected from old versions of MySQL, version 5.5 or earlier, for example, and it would be recommended to upgrade to a more modern version.
You can go to Tools > Site Health > Info and check the Database section to confirm which version you are using.