Skip to content Skip to sidebar

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This topic contains 1 reply, has 0 voices.

Last updated by erikv-28 1 month, 3 weeks ago.

Author Posts
February 25, 2026 at 3:49 pm #17852227

erikv-28

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

February 25, 2026 at 5:30 pm #17852617

Nigel
WPML Supporter since 02/2016

Timezone: Europe/Madrid (GMT+02:00)

Hi there

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.

February 26, 2026 at 8:19 am #17855279

erikv-28

Ah yes im running MariaDB 5.5.68, thanks i will upgrade this later.