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