We're updating the issue view to help you get more done. 

Fix PK length error when upgrading jivePrivate in MySQL using utf8

Description

When using MySQL 4.1.* and character set UTF-8 then the following error is generated when trying to increase the username field to 64:

[localhost] ERROR 1071: Specified key was too long; max key length is 1024 bytes

Environment

None

Acceptance Test - Entry

None

Activity

Show:
Gaston Dombiak
June 22, 2006, 9:46 AM

The fix was to change the PK to only index the first 100 chars of the namespace field.

ALTER TABLE jivePrivate DROP PRIMARY KEY
ALTER TABLE jivePrivate MODIFY username VARCHAR(64);
ALTER TABLE jivePrivate ADD PRIMARY KEY (username, name, namespace(100));

Assignee

Gaston Dombiak

Reporter

Gaston Dombiak

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure