You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ofbiz.apache.org by "Leon (JIRA)" <ji...@apache.org> on 2013/12/13 04:59:08 UTC

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

Leon created OFBIZ-5426:
---------------------------

             Summary: 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: SVN trunk
            Reporter: Leon


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
(v6.1.4#6159)