Unable to Install Crowd on MySQL 4.X
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
The issue is caused by a bug in MySQL 4.x. Unfortunately, there is no known workaround for this bug.
MySQL 4.x is not supported by Crowd. Please upgrade to the latest MySQL 5.x release.