ja-pagebuilder-component_1.0.0_beta2.zip / Joomla! 3.9.18
Page builder component install error:
JInstaller: :Instalar: Error SQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Extensión Instalar: SQL error procesando la consulta: Función de la base de datos fallida con el número de error 1293
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
SQL =
CREATE TABLE #__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,
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 NULL,
catid int(10) NOT NULL DEFAULT '0',
access int(11) NOT NULL,
tag_id int(11) DEFAULT NULL,
page_html longtext COLLATE utf8mb4_unicode_ci,
content mediumtext COLLATE utf8mb4_unicode_ci,
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) DEFAULT NULL,
working_content mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
images mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
ordering int(11) NOT NULL DEFAULT '0',
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
hits bigint(20) NOT NULL,
css longtext COLLATE utf8mb4_unicode_ci NOT NULL,
js longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;