ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taher Alkhateeb (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-8098) CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation
Date Thu, 01 Sep 2016 07:50:21 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-8098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15454656#comment-15454656
] 

Taher Alkhateeb commented on OFBIZ-8098:
----------------------------------------

Hi Hani,

Some help would be great from your side, can you please:

# provide exact steps to repeat, including gradle command and database setup
# Can you confirm that this behavior _does not_ happen in a standard Derby database?

> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation
> ---------------------------------------------------------------------------
>
>                 Key: OFBIZ-8098
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-8098
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ALL APPLICATIONS
>    Affects Versions: Trunk
>         Environment: windows / MYSQL
>            Reporter: Hani Hankir
>
> Hi Team,
> During tenant creation ( and I think during the defaut laod) , Mysql is throwinf this:
> {code}
> 2016-08-31 15:41:49,279 |pool-5-thread-1      |DatabaseUtil                  |E| Could
not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following:
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP
DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID,
EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
> Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
> 2016-08-31 15:42:11,169 |pool-3-thread-1      |DatabaseUtil                  |E| Could
not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following:
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP
DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID,
EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
> Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
> 2016-08-31 15:42:43,160 |pool-7-thread-1      |DatabaseUtil                  |E| Could
not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following:
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP
DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID,
EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
> Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
> 2016-08-31 15:51:46,356 |pool-3-thread-1      |DatabaseUtil                  |E| Could
not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following:
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP
DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID,
EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
> Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
> 2016-08-31 15:51:57,493 |pool-7-thread-1      |DatabaseUtil                  |E| Could
not create table [PRODUCT_PROMO_CODE_EMAIL]: SQL Exception while executing the following:
> CREATE TABLE PRODUCT_PROMO_CODE_EMAIL (PRODUCT_PROMO_CODE_ID VARCHAR(20) CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL, EMAIL_ADDRESS VARCHAR(320) CHARACTER SET utf8 COLLATE
utf8_general_ci NOT NULL, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP
DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_PRODUCT_PROMO_CODE_EMAIL PRIMARY KEY (PRODUCT_PROMO_CODE_ID,
EMAIL_ADDRESS)) ENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
> Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message