Vista Combinata Vista Piatta Vista ad Albero
Discussioni [ Precedente | Successivo ]
Behemoth .
mistakes in create-minimal-mysql.sql
10 settembre 2010 8.29
Risposta

Behemoth .

Punteggio: New Member

Messaggi: 19

Data di Iscrizione: 3 agosto 2008

Messaggi recenti

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)