Hi all, I came across with the following issue while running the mysql script.
23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key was too long; max key length is 767 bytes 0.078 sec pls refer the mail thread [1] it turns out that this happens when you use varchar(255<) values and innodb does not support it for unique keys. for an example query in carbon4-kernel master is [2] as mentioned in the thread [1] we need to fix this kernel wide, hence would like to draw your attention to this. cheers [1] [Dev] MySQL error while executing dbscripts in windows env [2] https://github.com/wso2/carbon4-kernel/blob/master/distribution/kernel/carbon-home/dbscripts/mysql.sql#L31 -- *Niranda Perera* Software Engineer, WSO2 Inc. Mobile: +94-71-554-8430 Twitter: @n1r44 <https://twitter.com/N1R44> https://pythagoreanscript.wordpress.com/
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
