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

Unable to execute SQL during a fresh install

    • 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'
      

          [CMS-9073] Unable to execute SQL during a fresh install

          Simon Prieul (Inactive) made changes -
          Fix Version/s New: 4.0.8 [ 14493 ]
          Frederic Ravetier (Inactive) made changes -
          Status Original: Resolved [ 5 ] New: Closed [ 6 ]
          Simon Prieul (Inactive) made changes -
          Resolution New: Fixed [ 1 ]
          Status Original: Patch available [ 10005 ] New: Resolved [ 5 ]
          Simon Prieul (Inactive) made changes -
          Assignee Original: Simon Prieul [ sprieul ]
          Simon Prieul (Inactive) made changes -
          Status Original: In Progress [ 3 ] New: Patch available [ 10005 ]
          Simon Prieul (Inactive) made changes -
          Status Original: Open [ 1 ] New: In Progress [ 3 ]
          Simon Prieul (Inactive) made changes -
          Assignee New: Simon Prieul [ sprieul ]
          Laurence Aumeunier made changes -
          Fix Version/s New: 4.1.0 [ 13987 ]
          Sprint New: 4.1 RC3 [ 17 ]
          Laurence Aumeunier made changes -
          Link New: This issue Référence CMS-8180 [ CMS-8180 ]
          Frederic Ravetier (Inactive) created issue -

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

              Created:
              Updated:
              Resolved: