mysql error 1071 - max key length error on installation
Permalink
Hello all,
i’m trying to install concrete5 for the first time, and ran into a problem, which seems to be related to the MySQL Character Set and Collation. If set to UTF-8 - which i would prefer, since some sites i have to manage are multi language - i keep getting the MySQL error message below:
mysql error: [1071: Specified key was too long; max key length is 767 bytes] in EXECUTE("CREATE TABLE AreaGroupBlockTypes ( cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, gID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (cID, arHandle, gID, uID, btID) );")
When set to latin1, installation runs smoothly on my test system (MAMP). Is there any way to change this behavior or is a specific collation needed to install concrete5?
i’m trying to install concrete5 for the first time, and ran into a problem, which seems to be related to the MySQL Character Set and Collation. If set to UTF-8 - which i would prefer, since some sites i have to manage are multi language - i keep getting the MySQL error message below:
mysql error: [1071: Specified key was too long; max key length is 767 bytes] in EXECUTE("CREATE TABLE AreaGroupBlockTypes ( cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, gID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (cID, arHandle, gID, uID, btID) );")
When set to latin1, installation runs smoothly on my test system (MAMP). Is there any way to change this behavior or is a specific collation needed to install concrete5?
