[jira] [Closed] (OFBIZ-5426) mysql: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

["Pawan Verma (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-5426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pawan Verma closed OFBIZ-5426.
------------------------------
    Fix Version/s: Upcoming Branch
       Resolution: Fixed

This has been fixed in trunk via the mentioned PRs.

Thanks, Leon for the report and Adrian Crum, Jacques Le Roux, Ingo Wolfmayr, Deepak Dixit, Pierre Smits Gil Portenseigne and Jacopo for the discussion and review.

> mysql: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
> ----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-5426
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5426
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Leon
>            Assignee: Pawan Verma
>            Priority: Major
>             Fix For: Upcoming Branch
>
>         Attachments: OFBIZ-5426.patch, OFBIZ-5426.patch, OFBIZ-5426.patch, OFBIZ-5426.patch, OFBIZ-5426.patch
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> Due to revision 1529838, the length of data type "email" was increased from 254 to 320. But It makes the ofbiz failed to create tables such as "PRODUCT_PROMO_CODE_EMAIL" which includes an email fields as its primary key.
> The database is mysql, innodb engine and utf8 charset. The error msg:
> ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes.
> I suggest to revert change of r1529838.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)