Joined: 07/06/2011 22:47:36
When try to create spagobi repository by MySQL_create.sql in scheme utf8 i get error Error Code: 1071. Specified key was too long; max key length is 767 bytes. The is no problem when schema latin1.
Also the solution of bug is here http://bugs.mysql.com/bug.php?id=4541
Error in table
CREATE TABLE SBI_KPI_PERIODICITY (
ID_KPI_PERIODICITY INT NOT NULL ,
NAME VARCHAR(400) NOT NULL,
USER_IN VARCHAR(100) NOT NULL,
TIME_IN TIMESTAMP NOT NULL,
TIME_UP TIMESTAMP NULL DEFAULT NULL,
TIME_DE TIMESTAMP NULL DEFAULT NULL,
UNIQUE XIF1SBI_KPI_PERIODICITY ( NAME ),
PRIMARY KEY ( ID_KPI_PERIODICITY )
) ENGINE = INNODB;
Solution is to change "NAME VARCHAR(400) NOT NULL," to "NAME VARCHAR(255) NOT NULL,".
This message was edited 1 time. Last update was at 27/01/2012 00:25:50