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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk
• Component/s: framework
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Pawan Verma
• Reporter: Leon
• Created: 13/Dec/13 03:57
• Updated: 11/Jan/22 09:37
• Resolved: 31/Mar/20 05:25

Description

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.

Issue Links

• is related to: OFBIZ-8098 CREATE TABLE PRODUCT_PROMO_CODE_EMAIL generate error during tenant creation
• links to: GitHub Pull Request #21
• links to: GitHub Pull Request #44
• links to: GitHub Pull Request #55