Unable to Install Crowd on MySQL 4.X
Symptoms
Installing Crowd errors out after configuring a database:
2009-10-25 12:33:51,781 http-8195-1 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table cwd_group_attribute (id bigint not null, group_id bigint not null, directory_id bigint not null, attribute_name varchar(255) not null, attribute_value varchar(255), attribute_lower_value varchar(255), primary key (id), unique (group_id, attribute_name, attribute_lower_value)) ENGINE=InnoDB
2009-10-25 12:33:51,782 http-8195-1 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Specified key was too long; max key length is 1024 bytes
Cause
The issue is caused by a bug in MySQL 4.x. Unfortunately, there is no known workaround for this bug.
Resolution
MySQL 4.x is not supported by Crowd. Please upgrade to the latest MySQL 5.x release.
Last modified on Feb 26, 2016
Powered by Confluence and Scroll Viewport.