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, 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
Location: org.ametys.core.script.SQLScriptHelper._execute(SQLScriptHelper.java:403)
Thrown:
java.sql.SQLException: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
problem in jdbc_cache_mon.sql
version of MySQL : mysql Ver 14.14 Distrib 5.5.19, for Win64 (x86)