Bug installing GDPR extension. It Say:
Advertencia
JInstaller: :Install: Error SQL Invalid default value for 'date_add'
Extensión Instalar: error al procesar consulta SQL: Función de la Base de datos falló, número de error 1067
Invalid default value for 'date_add'
SQL =
CREATE TABLE #__jagdpr_activities
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
userid
int(11) NOT NULL,
name
varchar(255) NOT NULL DEFAULT '',
username
varchar(255) NOT NULL DEFAULT '',
email
varchar(255) NOT NULL,
task
varchar(25) NOT NULL DEFAULT '',
status
varchar(25) NOT NULL DEFAULT '',
plugin
varchar(25) NOT NULL DEFAULT '',
date_add
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
date_update
datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id
),
UNIQUE KEY UNIQE
(userid
,status
,plugin
)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;
×
Error
Error al instalar componente