[Building Sakai] MySQL Error on upgrade script for version 2.9 to version 10

[Sam Ottenhoff]

My guess is that your default database engine is MyISAM instead of InnoDB.
If your default engine was set to InnoDB, this key creation would not
produce an error.

On Wed, Nov 12, 2014 at 7:16 AM, James Scoble <scoble.james at gmail.com>
wrote:

> Hi folks
> In the script to upgrade the database to version 10, the following entry
> is found:
>
> -- ------------------------
> --
> -- SAK-23812 Peer Review feature for Assignments
> --
> -- ------------------------
>
> CREATE TABLE ASN_PEER_ASSESSMENT_ITEM_T  (
>     SUBMISSION_ID       varchar(255) NOT NULL,
>     ASSESSOR_USER_ID    varchar(255) NOT NULL,
>     ASSIGNMENT_ID       varchar(255) NOT NULL,
>     SCORE               int(11) NULL,
>     REVIEW_COMMENT             varchar(6000) NULL,
>     REMOVED             bit(1) NULL,
>     SUBMITTED             bit(1) NULL,
>     PRIMARY KEY(SUBMISSION_ID,ASSESSOR_USER_ID)
> );
>
> create index PEER_ASSESSOR_I on ASN_PEER_ASSESSMENT_ITEM_T (SUBMISSION_ID,
> ASSESSOR_USER_ID);
> create index PEER_ASSESSOR2_I on ASN_PEER_ASSESSMENT_ITEM_T
> (ASSIGNMENT_ID, ASSESSOR_USER_ID);
>
> -- --------------------
> --
> -- END SAK-23812 Peer Review feature for Assignments
> --
> -- --------------------
>
>
> When I try to run this, I get the following error:
>
> #1071 - Specified key was too long; max key length is 1000 bytes
>
> This seems to be based on the varchar length - I'm guessing UTF-8 chars
> take up more than one byte.
> How have others worked around this problem?
>
> regards
> James
>
>
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141112/abe949ff/attachment.html