Hello
I'm trying to initialize Hybris 6.1.0.0, b2c_acc receipe on linux with mysql 5.5.49 and mysql-connector-java-5.1.39.d I get an error:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6), modifiedTS DATETIME(6), TypePkString BIGINT, OwnerPkString BIGI' at line 1
What I found out is that Hybris is trying to create table:
CREATE TABLE promotionaction ( hjmpTS BIGINT, createdTS DATETIME(6), modifiedTS DATETIME(6), TypePkString BIGINT, OwnerPkString BIGINT, PK BIGINT NOT NULL, p_markedapplied TINYINT(1), p_guid VARCHAR(255) NULL, p_promotionresult BIGINT, aCLTS BIGINT DEFAULT 0, propTS BIGINT DEFAULT 0, p_amount DOUBLE, p_orderentryproduct BIGINT, p_orderentryquantity BIGINT, p_orderentrynumber INTEGER, p_freeproduct BIGINT, p_deliverymode BIGINT, p_usedcouponcodes LONGBLOB NULL, p_rule BIGINT, p_strategyid VARCHAR(255) NULL, p_metadatahandlers LONGBLOB NULL, p_amoun0 DECIMAL(30,8), p_product BIGINT, p_quantity BIGINT, p_deliverycost DECIMAL(30,8), p_replaceddeliverymode BIGINT, p_replaceddeliverycost DECIMAL(30,8), PRIMARY KEY (PK) )ENGINE InnoDB CHARSET=utf8 COLLATE=utf8_bin;
but it seems that you cannot specify size in datetime type columns in mysql 5.5 but you still list mysql 5.5. as a supported db in https://help.hybris.com/6.0.0/hcd/8c71300f866910149b40c88dfc0de431.html
How can I fix the error?
Regards