I have a problem with installing.
Joomla! 3.9.18
PHP Version: 7.0.27
JInstaller: :Install: Errore SQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Estensione Installazione: richiesta di elaborazione degli errori di SQL: DB function fallita con errore numero 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 utf8_unicode_ci DEFAULT NULL,
alias varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
thumb varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
slug varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
type varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
state tinyint(3) NOT NULL,
asset_type varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
asset_name varchar(50) COLLATE utf8_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 utf8_unicode_ci,
content mediumtext COLLATE utf8_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 utf8_unicode_ci NOT NULL,
images mediumtext COLLATE utf8_unicode_ci NOT NULL,
ordering int(11) NOT NULL DEFAULT '0',
language char(7) COLLATE utf8_unicode_ci NOT NULL,
hits bigint(20) NOT NULL,
css longtext COLLATE utf8_unicode_ci NOT NULL,
js longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;