Uploaded image for project: 'CMS'
  1. CMS
  2. CMS-9073

Unable to execute SQL during a fresh install

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 4.0.8, 4.1.0
    • 4.1.0
    • None
    • None
    • 4.1.0RC2
    • 4.1 RC3

      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'
      

            Unassigned Unassigned
            fravetier Frederic Ravetier (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: