TRying to install T4 Page Builder files and getthe following
Warning
JInstaller: :Install: Error SQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Extension Install: SQL error processing query: DB function failed with error number 1293
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
SQL =
CREATE TABLE IF NOT EXISTS #__jae_item (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
alias varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
thumb varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
slug varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
state tinyint(3) NOT NULL,
asset_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
asset_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Joomla Item reference',
asset_id int(11) DEFAULT 0,
catid int(10) NOT NULL DEFAULT 0,
access int(11) NOT NULL DEFAULT 0 ,
tag_id int(11) DEFAULT 0,
page_html longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
content mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
created_by bigint(20) NOT NULL,
ctime timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
rev int(11) NOT NULL DEFAULT 0 ,
working_content mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
images mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci DEFAULT '*' ,
hits bigint(20) NOT NULL DEFAULT 0 ,
css longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
bundle_css longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
js longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Package Install: There was an error installing an extension: com_t4pagebuilder