I am doing a fresh install.
I've set a data source sql
I've done the configuration
and I have an error :
2018-03-06 17:19:40,962 ERROR [org.ametys.core.script.SQLScriptHelper] (http-nio-8080-exec-8;/_admin/plugins/admin/config/set) Unable to execute SQL: 'CREATE TABLE Cache_RA_HTTPServer ( Unique_Id VARCHAR(255) NOT NULL, Site VARCHAR(255) NOT NULL, Request_Date TIMESTAMP NOT NULL DEFAULT 0, Method VARCHAR(255) NOT NULL, Path_Hash VARCHAR(255) NOT NULL, Path TEXT NOT NULL, Query_String TEXT NOT NULL, Ori_Status_Code CHAR(3) NOT NULL, Ret_Status_Code CHAR(3) NOT NULL, Cache_Hit TINYINT(1) NOT NULL, Created_At TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, Processed TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (Unique_Id) ) ENGINE=InnoDB' at line 33 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'Request_Date'
- Référence
-
CMS-8180 Error when creating Cache_RA_HTTPServer table with MySQL
- Closed