VersionX icon indicating copy to clipboard operation
VersionX copied to clipboard

Incompatibility with MariaDB

Open sonicpunk opened this issue 5 months ago • 0 comments

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

sonicpunk avatar Jul 03 '25 09:07 sonicpunk