[Building Sakai] evals tool and MySQL

[Sam Ottenhoff]

I believe it's from attempting to create a table using MyISAM engine and 
character set UTF8.

You can try changing your global storage engine to InnoDB first:

    mysql> set GLOBAL storage_engine='InnoDb';

--Sam

> Looks like it might be an InnoDB issue. Old database.
>
> Steve
>
>
> On 29/10/2010, at 9:51 AM, Steve Swinsburg wrote:
>
>> Hi all,
>>
>> Is anyone running the Evaluations tool [1] under MySQL (5.1.40)? I'm having hard time starting up because of the keys being too long for MySQL:
>>
>> 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
>>
>> Unsuccessful schema statement: create table EVAL_RESPONSE (ID bigint not null auto_increment, LAST_MODIFIED datetime not null, OWNER varchar(255) not null, GROUP_ID varchar(255) not null, START_TIME datetime not null, COMMENT_RESPONSE text, SELECTIONS_CODE text, END_TIME datetime, EVALUATION_FK bigint not null, primary key (ID), unique (OWNER, GROUP_ID, EVALUATION_FK))
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
>>
>> Anyone addressed this?
>>
>> Thanks,
>> Steve
>>
>> [1] http://confluence.sakaiproject.org/display/EVALSYS/Home
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"