Combination View Flat View Tree View
Threads [ Previous | Next ]
Behemoth .
mistakes in create-minimal-mysql.sql
September 10, 2010 8:29 AM
Answer

Behemoth .

Rank: New Member

Posts: 19

Join Date: August 3, 2008

Recent Posts

Using create-minimal-mysql.sql (from liferay-portal-sql-6.0.5.zip) with mysql (v.5.1.50) has result:

Warning (Code 1071): Specified key was too long; max key length is 767 bytes

Reason:
create table Release_ (
...
testString varchar(1024) null
)
and
create table User_ (
...
openId varchar(1024) null,
...
) engine InnoDB;

Please, correct it.

PS:
"Index key prefixes can be up to 767 bytes. See Section 12.1.13, “CREATE INDEX Syntax”." (http://dev.mysql.com/doc/refman/5.1/en/innodb-restrictions.html)