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

Unable to execute SQL during a fresh install

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.0.8, 4.1.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      4.1.0RC2
    • Sprint:
      4.1 RC3

      Description

      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'

        Attachments

          Issue Links

          Référence

          Bug - A problem which impairs or prevents the functions of the product. CMS-8180 Error when creating Cache_RA_HTTPServer table with MySQL

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                fravetier Frederic Ravetier
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: