[Contrib: Evaluation System] Cannot startup cafe trunk: Hibernate issue on Snow Leopard Server

[Lovemore Nalube]

Hi
 
I have been running an instance of cafe trunk with not startup issues. Today I was working on Course Evaluations and dropped that into my instance and now sakai won't start.
 
There seems to be a hibernate related error in the logs:
 
2010-02-16 20:20:17,851  INFO main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Updating database schema for Hibernate SessionFactory
2010-02-16 20:20:18,641  WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create table EVAL_ASSIGN_USER (ID bigint not null auto_increment, EID varchar(255), LAST_MODIFIED datetime not null, OWNER varchar(255) not null, USER_ID varchar(255) not null, GROUP_ID varchar(255) not null, ASSIGN_TYPE varchar(255) not null, ASSIGN_STATUS varchar(255) not null, LIST_ORDER integer not null, ASSIGN_GROUP_ID bigint, EVALUATION_FK bigint not null, primary key (ID), unique (USER_ID, GROUP_ID, ASSIGN_TYPE, EVALUATION_FK))
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 
I am running MySql Server version: 5.1.43 on a MAC OSX Snow Leopard Server.
Can someone help me with this?
 
 
--
Lovemore Nalube
Online Learning Environments Developer (Vula)
PASS Transformation Committee REP
Centre for Educational Technology
CHED
University of Cape Town
www.cet.uct.ac.za

/* Work Email: lovemore.nalube at uct.ac.za
/* Cell: 076 186 1244
/* GTalk: lovenalube at gmail.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20100216/92f0c322/attachment.html