Issue installing with MySQL
Posted: 27 Sep 2013, 19:39
Hi,
I'm installing Essential Project 4 on MySQL 5.6 and having problems with setting this up on the DB. I've gone through the installation instructions and all is well until I get to the "convert project to format" stage. Clearly the DB connection is working as the table gets created in my schema, however no data is added and I get the error message below:
1. Errors at copying knowledgebase jdbc:mysql://localhost/essential
Exception class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException. Message: Specified key was too long; max key length is 767 bytes
See console and log for more details
An extract from the log does not shed any more light for me
2013.09.27 20:30:17.953 BST INFO: Creating database indicies: -- DefaultDatabaseFrameDb.createIndices()
2013.09.27 20:30:18.875 BST WARNING: Failed to create table on database MySQL with command 'CREATE TABLE essentialRepository1 (frame VARBINARY(310) NOT NULL, frame_type SMALLINT NOT NULL, slot VARBINARY(310) NOT NULL, facet VARBINARY(310) NOT NULL, is_template BIT NOT NULL, value_index INT NOT NULL, value_type SMALLINT NOT NULL, short_value VARCHAR(310) COLLATE utf8_general_ci, long_value MEDIUMTEXT) ENGINE = INNODB DEFAULT CHARACTER SET 'utf8'' :Specified key was too long; max key length is 767 bytes -- DefaultDatabaseFrameDb.createTable()
2013.09.27 20:30:18.937 BST WARNING: Errors at copying knowledgebase jdbc:mysql://localhost/essential -- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
Has anyone hit this before? Have I missed something in my config somewhere?
Thanks
I'm installing Essential Project 4 on MySQL 5.6 and having problems with setting this up on the DB. I've gone through the installation instructions and all is well until I get to the "convert project to format" stage. Clearly the DB connection is working as the table gets created in my schema, however no data is added and I get the error message below:
1. Errors at copying knowledgebase jdbc:mysql://localhost/essential
Exception class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException. Message: Specified key was too long; max key length is 767 bytes
See console and log for more details
An extract from the log does not shed any more light for me
2013.09.27 20:30:17.953 BST INFO: Creating database indicies: -- DefaultDatabaseFrameDb.createIndices()
2013.09.27 20:30:18.875 BST WARNING: Failed to create table on database MySQL with command 'CREATE TABLE essentialRepository1 (frame VARBINARY(310) NOT NULL, frame_type SMALLINT NOT NULL, slot VARBINARY(310) NOT NULL, facet VARBINARY(310) NOT NULL, is_template BIT NOT NULL, value_index INT NOT NULL, value_type SMALLINT NOT NULL, short_value VARCHAR(310) COLLATE utf8_general_ci, long_value MEDIUMTEXT) ENGINE = INNODB DEFAULT CHARACTER SET 'utf8'' :Specified key was too long; max key length is 767 bytes -- DefaultDatabaseFrameDb.createTable()
2013.09.27 20:30:18.937 BST WARNING: Errors at copying knowledgebase jdbc:mysql://localhost/essential -- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
Has anyone hit this before? Have I missed something in my config somewhere?
Thanks