zascok
07-15-2012, 12:41 PM
Hi all, trying to update 3 into 4. UTF-8. What do i do?
An error has occurred with your database.
Module: 400a1, Step 55 Database Error:1071
Specified key was too long; max key length is 767 bytes
Query:
CREATE TABLE stylevar (
stylevarid varchar(250) NOT NULL,
styleid SMALLINT NOT NULL DEFAULT '-1',
value MEDIUMBLOB NOT NULL,
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
UNIQUE KEY stylevarinstance (stylevarid, styleid)
)
An error has occurred with your database.
Module: 400a1, Step 55 Database Error:1071
Specified key was too long; max key length is 767 bytes
Query:
CREATE TABLE stylevar (
stylevarid varchar(250) NOT NULL,
styleid SMALLINT NOT NULL DEFAULT '-1',
value MEDIUMBLOB NOT NULL,
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
UNIQUE KEY stylevarinstance (stylevarid, styleid)
)