Skip to Content
0
Former Member
Aug 12, 2016 at 08:54 AM

Mysql 5.5.49, hybris 6.1.0.0, datetime type column

241 Views

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