[Building Sakai] Installing 2.9.0

[Sam Ottenhoff]

Not using the InnoDB Hibernate dialect?  MySQL5InnoDbDialect


On Fri, Nov 30, 2012 at 11:15 AM, Mark J. Norton
<markjnorton at earthlink.net>wrote:

> I got a database table create error on installing 2.9.0:
>
> 2012-11-30 08:09:32,172  WARN pool-2-thread-1
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean
> - Unsuccessful schema statement:
>
> create table EMAIL_TEMPLATE_ITEM (ID bigint not null auto_increment,
> LAST_MODIFIED datetime not null, OWNER varchar(255) not null, SUBJECT
> longtext not null, emailfrom varchar(255), MESSAGE longtext not null,
> HTMLMESSAGE longtext, TEMPLATE_KEY varchar(255) not null,
> TEMPLATE_LOCALE varchar(255), defaultType varchar(255), VERSION integer,
> primary key (ID), unique (TEMPLATE_KEY, TEMPLATE_LOCALE))
>
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was
> too long; max key length is 1000 bytes
>
> This seems odd to me, since a bigint isn't 1000 bytes long (to my
> knowledge).  Could this be an incorrect MySQL setting somewhere?
>
> - Mark Norton
>
> _______________________________________________
> 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/20121130/f0930b3b/attachment.html