-
Notifications
You must be signed in to change notification settings - Fork 20
Description
Upon installing the latest version of VersionX (3.1.3) we encountered errors in the MODX console which showed us that VersionX could not create the delta table into the database (MariaDB).
Error:
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Here is the statement that triggered the error:
CREATE TABLE
modx_versionx_delta (
idINTEGER unsigned NOT NULL AUTO_INCREMENT,
principal_packageVARCHAR(128) NOT NULL DEFAULT 'core',
principal_classVARCHAR(128) NOT NULL,
principalINT(10) unsigned NOT NULL DEFAULT '0',
type_classVARCHAR(128) NOT NULL,
milestoneVARCHAR(128) NOT NULL DEFAULT '',
time_startTIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
time_end TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (
id), INDEX
principal_class (
principal_class), INDEX
principal (
principal), INDEX
time_start (
time_start), INDEX
time_end (
time_end)) ENGINE=InnoDB