[Contrib: Evaluation System] EVALSYS broken for MySQL???

[Stephen Marquard]

I have an idea that this may be dependent on specific versions on mysql connector and server, but looking at the field lengths below, the user-related ones only need to be max 99 chars (user_id = 99, eid = 255).

Jim, what mysql versions are you using?

Regards
Stephen
 
>>> Jim Eng <jimeng at umich.edu> 6/16/2010 8:58 AM >>> 
I think we've discussed this before, but I am not finding a record of it. 

I am attempting to build trunk of evaluation along with the 1.2.5 tag of hierarchy in sakai trunk.  It builds and deploys just fine but fails to start up due to SQL errors.  In particular, there are a number of errors relating to primary keys that exceed MySQL's 1000-byte maximum key length.  Here's an example: 

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.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes

Have other people seen this with MySQL?  Is there an existing fix or workaround?

Thanks.

Jim
_______________________________________________
evaluation mailing list
evaluation at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/evaluation

TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"



 

###
UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.

###