Warning
JInstaller: :Install: Error SQL Invalid default value for '_expire'
Extension Install: SQL error processing query: DB function failed with error number 1067
Invalid default value for '_expire'
SQL =
CREATE TABLE IF NOT EXISTS `#__saml_LogoutStore`
(
`_authSource` varchar(191) NOT NULL,
`_nameId` varchar(40) NOT NULL,
`_sessionIndex` varchar(50) NOT NULL,
`_expire` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
`_sessionId` varchar(50) NOT NULL,
UNIQUE KEY `_authSource` (`_authSource`(191), `_nameId`, `_sessionIndex`),
KEY `#__saml_LogoutStore_expire` (`_expire`),
KEY `#__saml_LogoutStore_nameId` (`_authSource`(191), `_nameId`)
)
ENGINE = InnoDB
DEFAULT CHARSET = utf8;
Package Install: There was an error installing an extension: com_ro_sso_1.2.0.zip
Here is the system configuration:
PHP Built On Linux 4.12.14-197.45-default #1 SMP Thu Jun 4 11:06:04 UTC 2020 (2b6c749) x86_64
Database Type mysql
Database Version 5.5.39
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.5
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.10.0-alpha1 Alpha [ Amani ] 23-July-2020 21:10 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Regards,
Eddie