[jira] [Commented] (OFBIZ-8098) CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation

2016-09-07 Thread Hani H. (JIRA) 

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

Hani H. commented on OFBIZ-8098:


Hi Team, you were right , it was related to the Mysql Bug link mentioned above 
, I reinstalled all using the default Mysql config regarding 
character-set="latin1"
collate="latin1_general_cs">
and all was good...
Thanks Team!


> 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 H.
>
> 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: 
>

[jira] [Commented] (OFBIZ-8098) CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation

2016-09-01 Thread Deepak Dixit (JIRA) 

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

Deepak Dixit commented on OFBIZ-8098:
-

Hi Hani,

Could you please share your entity engine config file?
Did you made any changes in mysql default config?

https://bugs.mysql.com/bug.php?id=4541

> 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

[jira] [Commented] (OFBIZ-8098) CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation

2016-09-01 Thread Taher Alkhateeb (JIRA) 

[ 
https://issues.apache.org/jira/browse/OFBIZ-8098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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: